NON-STOCK-TAKE ? Flag to identify items as being excluded from the stock take process.
DATE-COUNTED D, E Last date a stock count was done for this item.
COUNTED-QTY K, L, M The ‘physically’ counted quantity entered for the stock item
COMPARE-QTY K, L, M The quantity recorded by the computer as the Physical quantity when the stock take procedure is begun (initialised).
DISCREP-QTY * The difference between the counted and compare quantities.
STATUS X (1) Holds flag for where in the stock take process the item is. ‘ ‘ shows either not in the stock take process or is completed, ‘I’ shows the stock take has begun for the item, ‘E’ shows the item has been counted but any required adjustment not yet made.
REFERENCE X (6) Holds the reference entered when the counted quantity was recorded.
F/ORDER-RESERVED K, L, M Sales Order Processing allows an ‘F-Forward’ Order Status for where orders are entered but are not yet required for shipment. This value shows the quantity required for these orders – when the order is made active the quantity is moved from here into the standard reserved quantity item.
F/ORDER-ONORDER K, L, M As above but for Purchase Order Processing.
NB: The previous values refer to the Forward Order Status; the following refer to transactions entered within the forward stock period.
FORWARD DEMAND K, L, M Stock demand for transactions entered with a date in the next period.This value is moved into PERIOD-DEMAND as part of the period end.
FORWARD SALES K, L Sales Value for transactions entered with a date in the next period. This value is moved into PERIOD-SALES as part of the period end.
FORWARD COSTS K, L Cost of Sales Value for transactions entered within the next period.This value is moved into PERIOD-COSTS as part of the period end.
FORWARD PHYSICAL K, L, M The net effect on Physical of transactions entered for the next period (unlike the values above physical has also been updated for these transactions).
FORWARD RESERVED K, L, M The net effect on Reserved of sales orders entered for the next period.
FORWARD ONORDER K, L, M The net effect on On-Order of purchase orders entered for the next period.
Article ID: 529
Created On: Tue, Jun 19, 2012 at 12:08 PM
Last Updated On: Thu, Jun 22, 2023 at 10:48 PM
Online URL: https://kb.datafile.co.uk/article/stock-take-forward-stock-control-529.html