Stock FIFO 1 - Stock Control

FIFO COST 1-9 K, L, M Holds the last n cost prices for which goods were received at. This is used within the Stock Valuation report as appropriate.

FIFO DATE 1-MAX D, E Holds the last n dates for which goods were received. Referencing these items allows the Stock Valuation Report to show the dates the FIFO batches were received plus to maintain these details in date sequence rather than the order they were entered.NB: You must have an equivalent number of FIFO date fields as for the FIFO cost/quantity fields however unlike cost/quantity the dates must be consecutive within the database structure.