Line Type

Select Product or Narrative.

Product

The Product code from IC (if IC is installed). Selecting a Product code loads a number of defaults: the Description, Unit, Group and Commission fields are loaded with the values from the Product record.

Description

Defaults to the description from a selected product (can be overwritten). Up to 60 characters are available on the selected line. For Narrative lines, for more characters click Narrative (F2) to open the Narrative Editor.

UOM Code

(UOM Active Only)

These are obtained from the Product record. They can be used (in a script) for apportioning freight and other costs across different Products. Only available when UOM is Active.

UOM Quantity

(UOM Active Only)

The quantity of the UOM on the Invoice. If the UOM has a Multiplier of more than 1, the Quantity will be calculated as the UOM Quantity * UOM Multiplier.

Quantity

The quantity of the Product on the shipment.

If UOM is Active:

• Quantity is calculated as the UOM Quantity * UOM Multiplier.
• Quantity is not shown in the grid by default.

If UOM is not Active, the Quantity is entered.

Unit

These are obtained from the Product record. They can be used (in a script) for apportioning freight and other costs across different Products.

Cost Price / UOM Cost Price

The Cost Price of the product, used to calculate the gross of all lines. When you add a product to a shipment, Accredo uses the Unit Cost and Additional Cost associated with the creditor specified for the shipment on the Suppliers grid of the IC Product record. If a product is selected which is not associated with the creditor, or a creditor has not been specified for the shipment, Accredo will use the Latest Cost from the Product tab of the IC Product record as the Unit Cost, with no Additional Cost.

For Cost Mode Divide Cost, this is calculated as (Extended Cost / Quantity) / (1- Discount%).

Discount

The discount percentage to be applied to the Cost. Defaults from the relevant Supplier Cost.

GST Code

The GST code for the line. If the Creditor has a GST Override set, it will be the default, otherwise the GST code comes from the Product, for the Tax Regime of the document. If there is no Product Code, the GST code will come from the Expense analysis code. It is unusual to need to change this code manually.

Ext Cost

The extended cost.

For Cost Mode Multiply Cost, this is calculated as (Cost Price x Quantity) - Discount %.

Ordered GST

Ordered GST amount. Read-only. See GST Line Calculations for calculation details.

GST

Amount of GST on the line.

Inclusive

The GST inclusive extended cost.

Exp Code

The Expense code the line will be analysed to when an Invoice transaction is posted.

Add'l Cost

Additional costs, such as freight or clearance fees, can be added to the Unit Cost to calculate the latest cost for inventory. Additional Costs can be automatically apportioned to the Receipt Cost, based on costs and apportionment types on the Additional Costs tab.

• Manually Apportion - If the line has Manually Apportion selected, the additional cost will be retrieved from Maintain > IC > Products > Suppliers/Bar Codes if one is found, or it can be added. Then you can use scripting to apportion the costs to the Unit Cost as you require.
• Automatically Apportion - If the Shipment line does not have Manually Apportion selected, the Additional Cost field is read-only and is populated from the Additional Costs tab where it will be apportioned to the Receipt Cost according to the apportionment type.

Receipt Cost

The cost that will be used for IC Receipt and JC transactions, including Additional Cost and Duty.

Duty (%)

The import duty percent applicable to the product, default is the figure from the IC Product record. This is also added to the Unit Cost for calculating the latest cost for inventory. The cost for inventory is calculated as: Unit Cost x (1 + Duty / 100.0) + Additional Cost.

Manually Apportion

Selected, the additional cost will be retrieved from Maintain > IC > Products > Suppliers/Bar Codes if one is found, or it can be added. Then you can use scripting to apportion the costs to the Unit Cost as you require.

Unselected, the Additional Cost field is read-only and is populated from the Additional Costs tab where it will be apportioned to the Receipt Cost according to the apportionment type.

Alternate Code

The alternate code from the product record. Read-only.

Bar Code

The default bar code from the product record. Read-only.

Base UOM Code

(UOM Active)

The Base UOM Code for the Product. Only available when UOM is Active.

Bin Code

Bin Code from the product record. Read-only.

Branch

The Branch the purchase on the line is analysed to when processing the Shipment. (Accredo Saturn Only)

Comment

Comment which flows through to the JC transaction, if the line has a Job Code. See JC Enter Transactions.

Complete for WIP

Selected, transaction will be excluded from WIP calculations when the shipment receipt is posted. The Period Complete for WIP for the transaction will be set to the Shipment Receipt PeriodID.

Clear, completes the period for WIP allowing the transaction to be included in WIP calculations.

Component code

Component Code from the job record.

Cost Centre Code

Cost Centre from the job record.

CurrencyCode

The Creditor's Currency Code. Read-only.

Custom 1

Custom 2

These fields can be customised into the grid. They can be used to add information to be stored with Shipments. These have no effect on posting unless used in a User defined script. Labels can be replaced in AP Settings.

Dept

The Department to which the purchase on the line is analysed to, when processing the Shipment. (Accredo Saturn Only)

Details

Details from the product record. Read-only.

Disc%

The discount percent to be applied to the Unit Sell Price for the Job Transaction.

Eff. Cost Price

Effective cost price, calculated as the Cost Price - Discount %.

Eff. Cost Price Bs

Effective cost price in the Base Currency.

ExtendedAdditionalCostBs

Extended additional cost in the Base Currency. Read-only.

Ext Cost Bs

Extended cost in the Base Currency. Read-only.

Extended Discount

The amount of the discount, exclusive of tax. This can be edited directly when the Cost Mode is Divide Amount.

Extended Discount Bs

The Extended Discount in the Base Currency. This can be edited directly when the Cost Mode is Divide Amount.

Extended Receipt Cost

Extended receipt cost. Read-only.

Ext Sell

The extended Selling Price for the JC transaction, calculated as Quantity x Unit Sell. This field is only available if you have JC installed. See JC Enter Transactions. Read-only.

Extended Volume

If UOM is Active, this is calculated as (Volume * UOM Quantity)+UOM Additional Volume.

If UOM is not Active, this is calculated as the Volume * Quantity.

UOM Additional Volume is setup in IC Units of Measure.

Extended Weight

If UOM is Active, this is calculated as (Weight * UOM Quantity)+UOM Additional Weight.

If UOM is not Active, this is calculated as the Weight * Quantity.

UOM Additional Weight is setup in IC Units of Measure.

GL Account Code

For Shipment lines relating to diminishing products if IC Integrate to GL is not None and Integration Basis is Perpetual the GL Account Code is read-only and is set on Post Invoice to the GL Stock Purchases Account Code for the IC Stock Group of the product.

For other lines you may override the GL Account associated with the Expense code (for example, if you purchase a fixed asset you can use a Miscellaneous Expense code, but override the GL Account with the GL Asset code at the time of Receipt, adding a narration to explain this). If a GL Account code is:

• Entered, it will override the GL Account code mapped from the Analysis code on transfer to the GL.
• Not entered, Accredo will use the default GL Account code mapped from the Analysis code on transfer to the GL.

GST Bs

The GST amount in base currency. Read-only.

ICTransactionID

If receipts have been posted, the unique identifier for the IC Receipt transaction. Read-only.

Inclusive Bs

Inclusive amount in the Base Currency. Read-only.

Inclusive Discount

The amount of the discount including tax. This can be edited directly when the Cost Mode is Divide Amount.

Inclusive Discount Bs

The Inclusive Discount in the Base Currency. This can be edited directly when the Cost Mode is Divide Amount.

Invoice Status

Can contain one of the following:

• Unposted - not yet posted to AP.
• Posted - posted to AP.
• Not Applicable - This line is not to be posted to AP. This is used for lines that are intended to be Receipted but not Invoiced or vice versa.

JC Fully Invoiced

Only applicable with JC installed.

Selected, the transaction is fully invoiced for JC, or the transaction is never to be invoiced for JC.

Clear, the transaction is partially invoiced or not yet invoiced. (Default)

JC Tran Type

Only applicable with JC installed. Job Costing transaction type.

JCTransactionID

Only applicable with JC installed. If receipts have been posted, the unique identifier for the JC transaction. Read-only.

Job Code

Job code for the line.

Line Break

Used for lines imported from the Narrative Editor. Indicates whether to include a line break when invoices are printed.

Line Number

Shows the current line number on the Shipment. Read-only.

LineID

Identifier for the line. Read-only.

Line Space

Used for lines imported from the Narrative Editor. Indicates whether to include a line space when invoices are printed.

Location

The Location for which Products are ordered. This field is only needed on lines with a Product code. (Accredo Saturn Only)

Markup (%)

The percentage Markup for the line, calculated as:

Markup = (Unit Sell Price - Cost Price) / (Cost Price x 100).

This figure is used to update the Selling Price for the product on the Job specified on the Shipment Line and can be overwritten to calculate a new Unit Sell Price based on the Cost Price.

Narration

Type a narration, such as to explain the reason for overriding the GL Account code, for example, Fixed Asset Purchase. This can be customised into the grid.

Non-Diminishing

Whether the product stock levels are tracked as sales, receipts and credits are processed. From the Product record. Read-only.

Order No

Populated when Shipment lines are obtained from a purchase order. Read-only.

OrderID

Identifier for the order. Read-only.

OrderLineID

Identifier for the order line. Read-only.

Quantity Invoiced

Quantity of the product invoiced. Read-only.

Quantity Ordered

Quantity of the product ordered. Read-only.

Quantity Outstanding Invoice

Quantity of the product on outstanding invoice. Read-only.

Quantity Outstanding Receipt

Quantity of the product on outstanding receipt. Read-only.

Quantity Pending Invoice

Quantity of the product pending invoice. Read-only.

Quantity Receipted

Quantity of the product receipted. Read-only.

Quantity Shipped

Quantity of the product shipped. Read-only.

Receipt Status

Can contain one of the following:

• Unposted - not yet posted to IC.
• Posted - posted to IC.
• Not Applicable - line is not to be posted to IC. Used for lines that are intended to be Invoiced but not receipted or vice versa.

Sell Currency Code

Sell currency code. Read-only.

Sell Exchange Rate

Sell exchange rate. Read-only.

Sell Price Bs

Unit sell price in the Base Currency.

Sell Rate Type

Sell rate type. Read-only.

Serial No

For Serial No Purchase tracked products if the quantity is 1 or -1 the Serial No may be entered, for other quantities enter Serial Nos in the Tracking tab.

For other Products the field is not available except where Allow Serial No on Non-Serial Lines has been selected in Company Settings.

Unit Sell

Unit sell price. Read-only.

UOM Eff. Cost Price (UOM Active Only)

Effective cost price per unit, calculated as the UOM Cost Price - Discount %.

UOM Eff. Cost Price Bs (UOM Active Only)

Effective cost price per unit in the Base Currency.

UOM Multiplier

(UOM Active Only)

The multiplier for the UOM Unit, set in IC Units of Measure. Read-only.

UOM Receipt Cost

(UOM Active Only)

The Amount receipted.

UOM Sell Price

(UOM Active Only)

Calculated as the Sell Price * UOM Multiplier. Read-only.

UOM Sell Price Bs

(UOM Active Only)

The UOM Sell Price in the Base Currency. Read-only.

Vendor Code

Retrieved from the IC Product Supplier Record. May be edited subject to AP > Shipments > Vendor code permission. Vendor code is saved to the Supplier Record when the line is receipted.

Volume

Product volume from the Product record. Read-only.

Weight

Product weight from the Product record. Read-only.

Tracking Panel

Show Tracking
Hide Tracking
(Ctrl+T)

Show or hide the tracking detail for the current line.