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.
Article ID: 525
Created On: Tue, Jun 19, 2012 at 12:00 PM
Last Updated On: Thu, Jun 22, 2023 at 10:49 PM
Online URL: https://kb.datafile.co.uk/article/stock-fifo-1-stock-control-525.html