I need to be able to show aged inventory as in how long the goods have been in stock and the current value.
The reason the client needs this is so they can revalue the inventory based on age.
Report 5808 does not do it, that only covers the immediate periods, what is needed is an age in say months or years and sorted by time.
Anyone written such a report they would like to share?
not exactly what you want, but you may be able to get the info from it.
report 10161 - Serial number atatus aging
will give you the age of each open item ledger entry, not just serialized items.
This may be a US specific report, I do not have it V4 (UK).
If possible, can you send as .txt to me?
colingbradley@gmail.com
Many thanks,
Colin
OK, found a copy of the US version and have the report.
Thanks,
Colin