Home » Categories » Multiple Categories

Detail Optional 3

Datafile Software

Detail Optional 3

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.

Custom Fields
  • Release ID: Standard
Attachments Attachments
There are no attachments for this article.
Related Articles RSS Feed
Record Last Order Details for Account and Stock
Viewed 3084 times since Fri, Jun 19, 2020
Select Alternate Part References
Viewed 256 times since Tue, Oct 15, 2024
Order Detail Pick Lists – Select by Order Reference
Viewed 81 times since Thu, Oct 24, 2024
Designing a SOP System
Viewed 1605 times since Tue, Jul 3, 2012
Purchase Order Processing Implications
Viewed 1723 times since Tue, Jul 3, 2012
Ledger Enquiry History File
Viewed 1955 times since Wed, Jun 13, 2012
Cost Price Checking – Checks by User-ID (SOP Only)
Viewed 69 times since Tue, Oct 22, 2024
Reports and Analysis - Application User Facilities
Viewed 1773 times since Wed, Jul 4, 2012
Default Stock Location
Viewed 1836 times since Fri, Oct 26, 2012
Status – Amend an Order Status
Viewed 856 times since Tue, Jul 3, 2012