Stock Optional 1 - Stock Control

SALES-ANALYSIS N, T Default sales analysis code used on sales issues. Also used as analysis code for sales order processing and invoicer.

PURCHASE-ANALYSIS N, T Default purchase analysis code used on purchase orders.

NOMINAL SALES CODE X (10) Default sales nominal code used on sales issues. Also used as the nominal code for sales order processing and invoicer.

NOMINAL PURCHASE X (10) Default purchase nominal code.

SUPPLIER-CODE X (10) Used primarily for reference, this holds the supplier code for that stock item. This code is transferred to the sales order detail as the supplier for use on back-2-back orders.

DESCRIPTION-2 X (30) Optional second line of stock description.

MINIMUM-STOCK K, L, M Used by the potential out of stock report to report stock items where physical/free stock falls below this value (if non-zero).

ESTIMATED-USAGE K, L, M Estimated Usage is the value of stock used in a given ‘period’ (this is the period as set in the Stock System Profiles rather than the stock period itself). This can be calculated as part of the period end processes from demand or you can maintain your own values. Again this is used on the potential out-of stock report.

LEAD-TIME N Number of periods (again as defined in the Stock System Profiles not the stock period itself) between order of the stock item and receipt.

IDEAL-BUYING-QTY K, L, M Typically used for convenience on the (potential) out of stock reports, it is also the default quantity for purchase order used within back-2-back order processing (when not simply purchasing the sales quantity).

ASSY-NO (non DFD) N, T Used for the old-style assembly maintenance, no longer used.

FIRST-ACTIVE-TRANS Y (6) Holds the record number of the first transaction generated for this stock this period.

DATE SET-UP D, E Holds the system date the stock record was created.

DEFAULT TAX CODE X (1) Default VAT code used on stock issues for ‘UK’ customers within Sales Order Processing and Invoicer. Also used for the calculation of tax value on transactions generated within stock itself.

PACK QUANTITY N Holds the number of items in a pack for this stock item.