Name Type Description
First Batch/Serial Item X, Y You can pre-assign batch/serial numbers against an order line.This is the first of a set of continuous data items to hold these numbers. The maximum number of fields you must create is defined in the batch tracking System Profiles. The field length must be the same as that of the batch/serial number code
First Batch/Serial Qty K, L, M As above, but to hold the matching quantities. Must be present if the above fields are present, even if only ever use serial numbers
Last invoiced quantity L, K, M Holds the quantity last invoiced
Credit del quantity L, K, M Holds the total delivery quantity credited on this order
Credit inv quantity L, K, M Holds the total invoice quantity credited on this order
Write-off del quantity L, K, M Holds the total delivery write-off qty
Write-off inv quantity L, K, M Holds the total invoice write-off qty
Alt price (cost) each L, K, M If using discount matrix, price is copied from stock record or from discount matrix. If the price field is a calculated field, however, that mechanism can’t work, so this field is used to put appropriate price value. Price itself would normally use this field in calculation
VAT (Tax excl) L, K POP equivalent option named Tax Value. Tax value of this order line if price is VAT exclusive. Needed particularly if using sales order multiple cash payment option
Pack Mult N, K POP only – SOP equivalent on Detail Optional 2. See also Pack Multiplier in stock control Database Profiles. Copied from stock file
Tax each L, K SOP only. If use the optional features ‘back calculate from tax inclusive price input’ this holds the unit tax value stripped from the tax inclusive price. Used on documents to ensure that end price is no greater than original input price (i.e. to avoiding rounding issues)
Tax fixed ? SOP only. If Y, then tax is not recalculated during document production but instead the above tax each value is used.
Job reference X, Y SOP only – POP equivalent on Detail Optional 2. Job code if this order detail is linked to job costing. Set as secondary index if job ledger enquiry to link to sales orders.
Job code analysis X, Y SOP only – POP equivalent on Detail Optional 2. Cost code if this order detail is linked to job costing and posting stock issues.
Omit discount ? SOP only. If Y then any overall discount is not calculated including this line.
Omit stock issue ? SOP only. If set then stock issue is not generated on update of stock control for this line (although reserved will be updated)
Packing item ? If Y, then allows document to omit print of this line but to accumulate the value of the line for inclusion in the document totals.
Article ID: 1579
Created On: Wed, Jul 4, 2012 at 11:03 AM
Last Updated On: Mon, Jun 12, 2023 at 3:14 PM
Online URL: https://kb.datafile.co.uk/article/detail-optional-3-1579.html