Hi
NAV 2017
I was wondering if anyone has designed a stock ageing report which can be run at a date in the past. This is for a FIFO based system, which means individual entries need to be monitored, not just totals.
I have one which can be run now, but am stumped by the past date option
Any ideas/assistance would be much appreciated
You will be looking at a combination of the Item Ledger Entry for qty and Value Entries for the cost.
If you use lot, batch, or serial # tracking then would include those in the NL(SUM...) to get the granularity u are looking for. Along with Posting Date = ..2024-07-31 or w/e your date is.
what level of detail u looking to get at?
