Stock aging report

In this procedure you can see information about quantity and value of the parts in stock for different age intervals. This is based on the number of days which the parts have been in stock. The list takes the FIFOClosed FIFO is calculated via the old stock log records existing in the system. All records have a price which is saved during the arrival reporting. However, for a purchase order the price will be updated when the supplier invoice becomes linked to the arrival reported items. This means that the FIFO value can change even though no stock transaction has taken place after the most recent inventory value list was created. Stock count and direct stock reporting will have the standard price as value. Other transactions such as negative reporting of material via manufacturing order, gets the standard price and also affect the FIFO. When FIFO is to be calculated, the part's balance is first checked. Then the program will find as many (positive) transactions as needed to be able to valuate these parts. The most recent transactions will then be used first. Example: If you have a balance of 100 units and the most recent transactions are: first a purchase of 80 units for EUR 10 each and then a purchase of 20 units for EUR 20 each, then the FIFO will be: 80 × EUR 10 + 20 × EUR 20 = EUR 1200, that is EUR 12 per unit. principle into consideration. The stock aging report distributes the stock balance after the user defined interval based on the stock transaction log's balance changes. You can use the list to trace old parts and for cost purposes.

Default number of age intervals and default number of days per age interval are determined by the system settings Number of intervals and Number of days per interval.