Previous Topic

Next Topic

PO Order Line Fields

Navigator > Tasks > Purchase Orders > Enter Purchase Orders > Lines Tab > Zoom or Customise Fields

Note: Outstanding figures are zeroed when a line is flagged Processed, or when the whole Order is marked Processed.

Line Type
(Type)

Select Product or Narrative.

Product

Enter product items.

Narrative

Enter extended lines of text, such as a detailed description of a job. Click Narrative Narrative (F2) in the Description field of a narrative line to open the Narrative Editor, then type a narrative or choose a global narrative.

 

Product Code
(Product)

The Product code from IC (if IC is installed), or selecting a Product code loads a number of defaults: the Unit Cost, and Lead Time fields are loaded with the values from the Product Suppliers tab.

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 Narrative (F2) to open the Narrative Editor.

Quantity Ordered
(Quantity)

The original quantity of the Product ordered on the Purchase Order.

If UOM is Active:

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

If UOM is not Active, the Quantity Ordered is entered.

Unit

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

Cost Price
(Price)

/ Cost Price Bs
(Price Bs)

The Cost Price for the item defaults to the Supplier Cost or Supplier Standard Cost on the Supplier tab of the Product record per AP Shipments Settings.

If there is no Supplier record for the product, the Cost Price will default to the Standard or Latest Cost or none per AP Shipments Settings.

/ Cost Price in the Base Currency.

Discount Percentage

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

GST Code
(GST)

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.

ExpenseCode
(Exp Code)

The Expense Analysis code that the net purchase on the line is analysed to when the Purchase Order line is transferred to a shipment. This defaults from the Product Expense Code if set, otherwise to the Expense Code entered on the Purchase Order header tab.

Ordered Amount
(Amount)

/ Ordered Amount Bs

The extended line amount, calculated as (Quantity Ordered x Cost Price) - Discount %. Read-only.
/ Ordered Amount in the Base Currency.

Vendors Code
(Vendor Code)

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

Date Expected

Calculated from the PO Order Date and the Lead Time from the Product Suppliers tab.

Branch Code
(Branch)

The branch the purchase is analysed to when processing. (Accredo Saturn Only)

 

Currency Code

Currency code for the purchase order. Read-only.

Custom 1

Custom 2

These fields can be used to add information to be stored with purchase orders, and printed on documents. To change the field names, go to PO Settings - Display labels tab and change the display labels.

Date Of Last Sale

Date the product was last sold from the product record. Read-only.

Date Of Last Sale or Usage

Date the product was last sold or used from the product record. Read-only.

Date Of Last Usage

Date the product was last used from the product record. Read-only.

Department Code
(Dept)

The department the purchase is analysed to when processing. (Accredo Saturn Only)

 

Effective Cost Price

/Effective Cost Price Bs

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

/ Effective Cost Price in the Base Currency.

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 Expense code (for example, if you purchase a fixed asset, use a Miscellaneous Expense code, but override the GL Account with the GL Asset code at the time of purchase, adding a narration to explain this). If a GL Account code is,

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

This field can be customised into the grid and is not visible by default, and controlled by permissions.

Invoiced Amount
(Value Invoice)

/ Invoiced Amount Bs

Amount invoiced on posted Shipments. Read-only.

/ Invoiced Amount in the Base Currency.

Line Break

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

Line ID

Unique identifier for the line. Read-only.

Line Number

Shows the current line number on the purchase order.

Line Space

Used for lines saved from the Narrative Editor. Indicates whether to include a line space when purchase orders are printed.

Line Status

Lines can be:

  • Unprocessed, the line has not yet been fully receipted and invoiced on one or more shipments.
  • Receipted, the line is not yet Processed no further delivery is expected.
  • Processed, the line has been fully receipted and invoiced on one or more shipments. A purchase order will become Processed when there are no further unprocessed lines.
    Selecting Processed for a line which is not fully receipted and invoiced indicates no further receipts or invoices are expected.
    A line can not be set Processed while there are unposted shipments relating to the line.
  • Cancelled, the line has been cancelled and will not be received on a Shipment. This is typically used where a supplier has advised that the goods cannot be supplied.
    A line can not be cancelled once there are shipment lines relating to it.


Setting Line Status to Receipted, Processed or Cancelled zeroes outstanding quantities and amounts and removes the line from IC Pending Transactions and On Order quantities.

Location Code
(Location)

The location for the ordered products, only required for lines with a Product code. (Accredo Saturn Only)

 

Narration

Type a narration, for example, to explain the reason for overriding the GL Account code, for example Fixed Asset Purchase.

Ordered GST

/ Ordered GST Bs

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

/ Ordered GST amount in the Base Currency.

Outstanding Amount Invoice

/ Outstanding Amount Invoice Bs

Amount outstanding for Invoice. Read-only.

i.e. Quantity Outstanding Invoice* Effective Cost Price.

Zeroed when the Line or Order is marked Processed.

/ Outstanding Amount Invoice in the Base Currency.

Outstanding Amount Receipt

/ Outstanding Amount Receipt Bs

Amount outstanding for Receipt. Read-only.

i.e. Quantity Outstanding Receipt * Effective Cost Price.

Zeroed when the Line or Order is marked Processed.

/ Outstanding Amount Receipt in the Base Currency.

Pending Invoice Amount

/ Pending Invoice Amount Bs

Value yet to be invoiced on unposted shipments. Read-only.

/ Pending Invoice Amount in the Base Currency.

Quantity Invoiced
(Qty Invoice)

Quantity invoiced from posted invoices from shipments. Read-only.

Quantity Outstanding Invoice

Quantity outstanding for invoice. Read-only.

i.e. Quantity Ordered - Quantity Invoiced - Quantity Pending Invoice.

Zeroed when the Line or Order is marked Processed.

Quantity Outstanding Receipt

Quantity outstanding for Receipt. Read-only.

i.e. Quantity Ordered - Quantity Receipted - Quantity Shipped.

Zeroed when the Line or Order is marked Processed.

Quantity Pending Invoice

Quantity yet to be invoiced on unposted shipments. Read-only.

Quantity Receipted
(Qty Receipt)

Quantity receipted from posted receipts from shipments. Read-only.

Quantity Shipped

Quantity yet to be receipted on unposted shipments. Read-only.

Receipted Amount

/ Receipted Amount Bs

Receipted amount from posted receipts from shipments. Read-only.

/ Receipted Amount in the Base Currency.

Shipped Amount

/ Shipped AmountBs

Value yet to be receipted on unposted shipments. Read-only.

/ Shipped Amount in the Base Currency.

UOM Fields

 

Only available if UOM is active for Inventory.

Base UOM Code

The Base UOM Code for the Product.

UOM Code

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 Ordered

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

UOM Cost Price

/ UOM Cost Price Bs

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

/ The UOM Cost Price in the Base Currency.

UOM Effective. Cost Price

/ UOM Effective. Cost Price Bs

Effective cost price per UOM.

UOM Effective. Cost Price in the Base Currency.

UOM Multiplier

The multiplier for the UOM Code. Read-only.

UOM Supplier Standard Cost

(UOM Active Only)

Standard cost from the supplier for the UOM. Read-only.

Job Costing Fields

Only available with JC installed, only applicable if a JobCode is entered.

Comment

Only available with JC installed, only applicable if a JobCode is entered.

Comment for the JC transaction. See JC Enter Transactions.

Complete for WIP

Only available with JC installed, only applicable if a JobCode is entered.

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, does not set the period for WIP allowing the transaction to be included in WIP calculations.

Component Code

Only available with JC installed, only applicable if a JobCode is entered.

The component code for the JC transaction when receipting against the purchase order.

Cost Centre Code

Only available with JC installed, only applicable if a JobCode is entered.

The default cost centre code for JC transactions when receipting against the purchase order.

JC Fully Invoiced

Selected, the JC transaction is marked fully invoiced for JC.

Clear, the JC transaction is available to be invoiced. (Default)

JC Tran Type

Job costing transaction type.

Job Code

The Job Code for the transaction when receipting against the purchase order.

Markup (%)

This is calculated as:

((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 Purchase Order line.

Sell Currency Code

Sell currency code for the Job.

Sell Discount Percentage
(Disc%)

The discount percent to be applied to the Sell Price.

Sell Exchange Rate

Sell exchange rate.

Sell Price

/ Sell Price Bs

Unit sell price for the JC Transaction.

/ The Sell Price in the Base Currency.

Sell Rate Type

Sell exchange rate type.

UOM Sell Price

/ UOM Sell Price Bs

(UOM Active Only)

Calculated as the Sell Price * UOM Multiplier.

/ The UOM Sell Price in the Base Currency.

Product Fields

 

From the product record. Read-only.

Alternate Code

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

Average Cost

The average cost of the product. Read-only.

Bar Code

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

Bin Code

Bin Code from the product record. Read-only.

Latest Cost

Latest cost from the Product record. Read-only.

Lead Time

From the product record. Read-only.

Details
(Product Details)

Details from the product record. Read-only.

Standard Cost

Standard cost of the product. Read-only.

Supplier Standard Cost

Standard cost from the supplier. Read-only.

Volume

Volume from the Product record.

Weight

Weight from the Product record.

See Also

PO Purchase Orders - Lines tab

Book Contents

Book Index