By using this website, you agree to our Terms of Use (click here)
Does anyone know a way to show the age in days for the qty on hand of a given inventory item when the valuation method is set to average? I have been able to do this with a valuation method of FIFO using cost layers but the average method does not have any cost layers.
Hi Nheuer,
The only thing I can think would be to make some assumptions that the current quantity on hand came in from the most recent purchase receipts (or, if you want to get more complicated, from the combination of most recent purchase receipts and transfers in). Then you would have to traverse that transaction chain until you reach the quantity on hand amount and find the date of the transaction.
Sounds messy, but I can't really think of a better way to do it personally.