BATCH NUMBER X (32) The prime index of the batch file holding the batch code itself.
STOCK CODE X (32) Holds the stock code that the batch/serial item belongs to.
STOCK RECORD NO Y (6) Holds the record number within the stock database of the stock code that the batch/serial item belongs to.
NEXT BATCH Y (6) Holds the record number of the next batch/serial item for the stock code that this batch item belongs to.
ORIGINAL QUANTITY K, L, M Holds the quantity originally purchased/built when this batch record created.
PHYSICAL QUANTITY K, L, M Holds the quantity currently physically available.
ON-ORDER QUANTITY K, L, M Holds the quantity on-order through Bill of Materials and Purchase Order Processing.
RESERVED QUANTITY K, L, M Holds the quantity reserved through Bill of Materials and Sales Order Processing
FREE QUANTITY * A calculation of Physical plus On-Order less Reserved
COST PRICE K, L, M Holds the cost price the batch was received/built at
PREV BATCH Y (6) Holds the record number of the previous batch/serial item for the stock code that this batch item belongs to
Article ID: 579
Created On: Wed, Jun 20, 2012 at 11:32 AM
Last Updated On: Thu, Jun 22, 2023 at 10:33 PM
Online URL: https://kb.datafile.co.uk/article/batch-mandatory-batch-tracking-579.html