IN Invoice Line Fields

Navigator > Tasks > Invoicing System > Enter Invoices > Lines Tab > Zoom or Customise Fields

Field Name

Description

Line Type

Select Product or Narrative.

Auto Kitset, Manual Kitset, Component and Usage line types are selected from the Product code entered and do not appear in the line type lookup. See Components. Job lines do not appear in the line type lookup as they are generated from JC.

Product	Enter product items.
Narrative	Enter extended lines of text, such as a detailed description of a job. Click Narrative `(F2)` in the Description field of a narrative line to open the Narrative Editor, then type a narrative or choose a global narrative.
Auto Kitset	Followed by a list of components. When posted, the components on the lines following are sold, not the product on the Auto Kitset line.
Component	Lines below an Auto Kitset line. These products are recognised as sold when the invoice is posted.
Manual Kitset	The product is manufactured on the fly from the usage lines below and then sold. If Supply Whole Manual Kitsets is selected in IN Settings, usage quantities for Manual Kitsets cannot be edited once calculated based on the Kitset quantity. If Supply Whole Manual Kitsets is unselected, usage quantities can be edited on the Invoice lines.
Usage	Lines below a Manual Kitset line. When the invoice is posted, these products are used to manufacture the Manual Kitset Product which is recognised as a sale.

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 of the 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)

The UOM Code from the Product. Only available when UOM is Active. If the Product has more than one UOM Code, you can select the code to use.

Note: If the quantity is not representable in the selected UOM Code decimals, the UOM Code will default to the Base UOM Code.

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 invoice.

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

The unit for the product (for example, Each or Doz) usually printed on the invoice. If a UOM Code is entered, shows the UOM Code Description. If no UOM Code exists, this can be entered.

Price

Price per the Discount mode in the Discount Schedule. If the Discount Mode is:

Explicit, displays the Sell Price for the item before a discount, the discount appears in the Disc% field.
Implicit, displays the discounted price. No discount shows in the Disc% field.

If using Special Pricing, shows the special price according to the rules above.

If UOM is Active, the Price is not shown in the grid by default.

UOM Selling Price

(UOM Active Only)

The UOM Selling Price is calculated as the Price * UOM Multiplier. This can be overwritten.

Disc %

The discount shown depends on the Discount Mode specified in the Discount Schedule. If the Discount Mode is:

Explicit, shows the discount percentage applied to the extended amount (Quantity x Price).
Implicit, no discount shown.

If you use Special Pricing, shows the total discount according to the rules above.

GST

The GST code for the line. If a GST Override has been specified for the Customer, that will be the default. Otherwise, the GST is the default GST code for the Product, or Sales Group if the line does not have a Product code. It is unusual to need to change this code manually.

Group

The Sales Group the net sale on the line is analysed to when an invoice is generated and posted. If the line does not include a product from IC, type the appropriate Sales Group code or the amount will be analysed to unspecified group code 0000 - to avoid code 0000, ensure Allow Unspecified 0000 Sales Analysis Codes is clear in AR Settings..

Amount

The extended line amount, calculated as QuantitySupplied x SellingPrice - EnteredDiscount. Read-only.

AlternateCode

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 from the product record. Read-only.

BranchCode

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

Comm Amount

The amount of commission. Normally calculated from the commission percentage applied to the price or the gross profit on the line, based on the Commission Basis. If commission is based on profit, it can be recalculated during Invoice posting (when the latest Cost Price is available).

Comment

Comment for the JC transaction. This field is only available if JC is installed. See JC Enter Transactions.

Commission%

Commission percentage applicable to this line. By default it is loaded from the Product record.

Commission Amount Bs

Commission amount in the Base Currency. Read-only.

Complete For WIP

Available when a Job Code is selected for the Invoice or the Line.

Selected, the transaction will be excluded from WIP calculations when the invoice is posted.

Clear, the transaction is included in WIP calculations.

Not available for OE sourced lines.

Component code

Component Code from the job record. Read-only.

Cost Centre Code

Cost Centre from the job record. Read-only.

Cost Price

The Cost Price for the Product record. This is determined by the Valuation Basis (Standard, Average or Latest Cost) in IC Settings. Read-only.

Cost Price BS

Cost price in the Base Currency. Read-only.

Currency Code

Currency code for the invoice. Read-only.

Custom 1 & Custom 2

Use these fields to add information stored with orders to be printed on packing slips and invoices. To change the field names, select Customise on the line grid and change the Display Label.

Date Supplied

Date the product line was supplied.

Dept

The Department the line is analysed to. (Accredo Saturn Only)

Disc

Discount dollar amount can be entered if the Discount Percentage is blank, allows discounts that do not represent an exact percentage.

Disc Bs

Discount dollar amount in the Base Currency. Read-only.

Eff. Sell Price

Effective sell price. Read-only.

Eff. Sell Price Bs

Effective sell price in the Base Currency. Read-only.

EnteredAmountBs

Entered amount in the Base Currency. Read-only.

Excl Amount

Selling Price, excluding GST, less applicable discounts, of all the items in the Invoice line. Read-only.

Exclusive Amount Bs

Exclusive amount in the Base Currency. Read-only.

Exclusive Cost Bs

Exclusive cost price in the Base Currency. Read Only.

Exclusive Discount

Exclusive discount amount. Read-only.

Exclusive Discount Bs

Exclusive discount amount in the Base Currency. Read-only.

Ext Cost

Extended cost value for the line. It is calculated as QuantitySupplied x CostPrice. 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

You can override the GL Account associated with the Sales Group. For example, if you sell a fixed asset you can use a Miscellaneous Sales Group and override the GL Account with the Asset GL code, adding a narration to explain this. If a GL Account code is:

Entered, Accredo 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.

Group Name

Name of the Sales Group specified in the Group field.

GST Amount

Amount of GST on the line, can be edited if the GST Code is G (all GST).

See GST Line Calculations for calculation details.

GST Amount Bs

GST amount in the Base Currency. Read-only.

JC Actuals

Available when a Job Code is selected for the Invoice or the Line.

Selected, JC Actuals and related IC Usages will be created for the JC Transaction when the Invoice is posted. If Allow IN Sourced Invoice Lines is selected in JC Settings, Complete for WIP will also be set to Selected.

Not available for OE sourced lines.

JC Tran Type

JC transaction type. Read-only.

JCTransaction ID

The unique identifier for the JC transaction, if the line comes from a JC transaction. Read-only.

Job Code

Job code for the line. Not available for OE sourced lines.

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 invoice. 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 product supply location, only needed on lines with a Product code. (Accredo Saturn Only)

Margin

The percentage gross margin for the line, calculate as:

100 * (ExclusiveAmount - ExclusiveCost) / ExclusiveAmount)

Read-only. Hint: See Permissions on restricting access to Commissions, Cost and Selling Prices.

Markup (%)

The percentage Markup for the line, calculated as:

Markup = ((SellPrice * (100-Discount%)/100) - CostPrice) * 100 / CostPrice

SellPrice (before discount) = CostPrice * (100 + Markup%) / (100 - Discount%)

Note: If the Sell Price is GST inclusive, the GST is not deducted before the calculation, that is, Markup includes GST.

Hint: See Permissions on restricting access to Commissions, Cost and Selling Prices.

Narration

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

Order Number

Populated when Invoice lines are obtained from a sales order.

OrderID

Identifier for the order. Read-only.

OrderLineID

Identifier for the order line. Read-only.

P/Slip Number

Packing slip number if the invoice was generated from an Order.

Product Details

Details from the product record. Read-only.

Selling Price Bs

Selling price in the Base Currency.

Serial No

For Serial No 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.

UOM Cost Price

(UOM Active Only)

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

UOM Cost Price Bs

(UOM Active Only)

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

UOM Eff. Sell Price

(UOM Active Only)

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

UOM Eff. Sell Price Bs

(UOM Active Only)

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

UOM Multiplier

(UOM Active Only)

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

UOM Selling Price Bs

(UOM Active Only)

The UOM Selling Price in the Base Currency.

Usage cost

Usage cost. Read-only.

Usage Cost Bs

Usage cost in the base currency. Read-only.

Volume

For Automatic Kitsets, this is the sum of the Volume of the component lines. For other products, this is the Product Volume from the Product record. Read-only.

Weight

For Automatic Kitsets, this is the sum of the Weight of the component lines. For other products, this is the Product Weight from the Product record. Read-only.

Write Off

Available for Credit lines only (i.e. Credit with positive quantity or Invoice with negative quantity).

Selected, when the Credit is posted a write off IC Adjustment transaction will be posted to adjust the quantity out of stock after the IC Credit transaction which returns the stock.