Name Type Description
Alt items below provide capability to manage stock in one unit, but take orders in different units (for example, stock in metres; orders placed in metres, feet or yards). If technique used, then all items below must be defined. Order processing application would normally use look-up file for unit (metres, feet, yards) and copy across pre-defined conversion factor, which would be used in Alt-Stk-Ord-Qty and Alt-Stk-Doc-Qty calculated fields below. The order quantities of whatever unit requested by the customer (or on the supplier) are entered into standard fields defined above, and fields below are used by the system in converting to the actual stock-keeping units used by the stock system
Alt Stock Ord Qty L, K, M, * Holds quantity ordered in stock update unit. Usually calculated field of order quantity x conversion factor
Alt Stock Doc Qty L, K, M, * Holds quantity processed on document in stock update unit. Usually calculated field of work quantity x conversion factor
Alt Stock Del Qty L, K, M Holds quantity delivered in stock update unit
Alt Stock Inv Qty L, K, M Holds quantity invoiced in stock update unit
Alt Stock Del W/Off L, K, M Holds quantity written off on delivery in stock update unit
Alt Stock Inv W/Off L, K, M Holds quantity written off on invoice in stock update unit
Alt Stock Cr Del Qty L, K, M Holds delivery quantity credited in stock update unit
Alt Stock Cr Inv Qty L, K, M Holds invoice quantity credited in stock update unit
User Accum Val 1 L, K, M, * } Up to three values can be accumulated on the order
User Accum Val 2 L, K, M, * } header, as defined above. These are the data items in
User Accum Val 3 L, K, M, * } the order detail records which are accumulated
Disc-Mat "Item 13” Although the discount matrix is fixed in format, an extra item can be created as data item 13 in this file, and this value be copied into the order detail if the discount matrix is used to determine the price
Mult Disc 1 L, K }
Mult Disc 2 L, K } Multiple progressive discounts can be used in order
Mult Disc 3 L, K } processing in which case these are the fields in which
Mult Disc 4 L, K } they are used
Article ID: 1580
Created On: Wed, Jul 4, 2012 at 11:04 AM
Last Updated On: Mon, Jun 12, 2023 at 3:14 PM
Online URL: https://kb.datafile.co.uk/article/detail-optional-4-1580.html