OE Order Line Fields

Navigator > Tasks > Order Entry > Enter Sales Orders > Lines Tab > Zoom or Customise Fields

Field Name

Description

Type

Select Product, Narrative or Sticky 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.

Product	For entering Product items. These can be products held in IC but need not be as all details can be entered manually.
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.
Sticky Narrative	A special type of narrative line that is linked with the line above. When invoices are generated, these lines will be transferred to the invoice only if the line above is also, that is, the order contains some supplied items. These lines are also only printed on packing slips if the line they are linked to is printed. Ordinary narrative lines are always transferred during invoice generation. Sticky narrative lines can attach narration to a Product line.
Auto Kitset	Gets the list of components on the order. When posted, the components on the following lines are sold, not the product on the Auto Kitset line. Special Pricing is not applied to Auto Kitset lines. To apply Special Pricing to a group of products, you must use a Manual Kitset.
Component	Lines below an Auto Kitset line. These products are recognised as sold when the order is posted.
Manual Kitset	The product is manufactured on the fly from the usage lines below and then sold.
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 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 Ordered

(UOM Active Only)

The quantity of the UOM ordered. If the UOM has a Multiplier of more than 1, the Ordered will be calculated as the UOM Ordered * UOM Multiplier.

Ordered

The quantity ordered. When a product is selected, this defaults to the value specified in Settings (often 0).

If UOM is Active:

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

If UOM is not Active, Ordered is entered.

UOM Supplied

(UOM Active Only)

The quantity of the UOM supplied. If the UOM has a Multiplier of more than 1, the Supplied will be calculated as the UOM Supplied * UOM Multiplier.

Supplied

The quantity supplied will default to the quantity ordered if sufficient stock is available.

If UOM is Active:

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

If UOM is not Active, Supplied can be entered.

UOM Back Order

(UOM Active Only)

The quantity of the UOM on back order. If the UOM has a Multiplier of more than 1, the Back Order will be calculated as the UOM Back Order * UOM Multiplier.

Back Order

The quantity to be placed on back-order, based on the Default If Insufficient Stock option in OE settings.

If UOM is Active:

Back Order is calculated as the UOM Back Order * UOM Multiplier.
Back Order is not shown in the grid by default.

If UOM is not Active, Back Order can be 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, shows the Sell Price for the item before a discount, the discount appears in the Disc% field.
Implicit, shows the discounted price, discount not in the Disc% field.

For 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 if the line does not have a Product code, the GST for the Sales Group. 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. You cannot enter in this field; it is calculated as QuantitySupplied x SellingPrice - EnteredDiscount. Read-only.

Alternate Code

The alternate code from the product record, read-only.

Group Name

The name of the Sales Group specified in the Group field. 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 sale on the line is analysed to when processing the Order. (Accredo Saturn Only)

Comm Amount

The amount of commission attached to this line, usually 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 Order posting (when the latest Cost Price is available).

Comment

30 character text field.

Commission %

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

Commission Amount BS

The commission amount in the Base Currency. 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

The cost price in the Base Currency. Read-only.

Currency Code

Currency code for the sales order. Read-only.

Custom 1

Custom 2

These fields can be used to add information to be stored with sales orders, and printed on documents. 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)

Eff. Sell Price

Effective selling price. Read-only.

Eff. Sell Price Bs

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

EnteredAmountBs

Entered amount in the Base Currency. Read-only.

Excl Amount

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

Exclusive Amount Bs

Exclusive amount in the Base Currency. Read-only.

Excl Amt Ordered

Exclusive amount ordered. For back orders, this is calculated as the exclusive amount of the (Quantity Ordered - Quantity Invoiced). Read-only.

Excl Amount Ordered Bs

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

Exclusive Cost Bs

Exclusive Cost in the Base Currency. Read-only.

Exclusive Cost Ordered

Exclusive Cost Ordered, calculated as CostPrice * QuantityOrdered. Read-only.

Exclusive Ordered Cost Bs

Exclusive Cost Ordered in the Base Currency, calculated as CostPriceBs * QuantityOrdered. Read-only.

Ext Cost

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

GST Amount Ordered BS

GST Amount Ordered in the Base Currency. Read-only.

GST Amt Ordered

GST Amount on the products ordered. Read-only.

Invoiced

Quantity invoiced on the order line. Read-only.

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 order. Read-only.

Line ID

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.

Line Status

Shows the current line status.

Lines can be:

Unprocessed, the line has not yet been fully supplied and invoiced.
Processed, the line has been supplied and invoiced. Updated automatically when fully supplied and invoiced but may be selected for a partially invoiced line if no further supply will be made.
Cancelled, the line has been cancelled and will not be supplied.
Deleted, the Order has been deleted.

Setting Line Status to Processed or Cancelled zeroes any Quantity Supplied or Back Ordered and removes the line from IC Pending Transactions and quantities.

See OE Settings - Misc tab for settings controlling Line behavior on Generate.

Location

The product supply location, only needed for lines with a Product code. (Accredo Saturn Only)

Margin

The percentage gross margin for the line, calculated as:

100 * (ExclusiveAmount - ExclusiveCost) / ExclusiveAmount.

Read-only.

Hint: see permissions on 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.

Product Details

Details from the product record. Read-only.

Selling Price Bs

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

Usage Cost Ordered

Usage Cost Ordered. Read-only.

Usage Cost Ordered Bs

Usage Cost Ordered 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.

Tracking Panel

Show Tracking
Hide Tracking
(Ctrl+T)

Show or hide the tracking detail for the current line.