We want to put together an Excess & Obsolete (E&O) Inventory analysis. I’ve looked at the inventory reports in NAV and I can’t find a report(s) with the data we would need. It might also be user error by me and not knowing all of the reports available.
The key metrics we would be looking for are by item # for usage/sales (6, 12, 18 months), last receipt date, and first sale date.
Do you know if there are reports already in NAV that have this information? If they aren’t together in one report, we can piece them together.
The main field I'm having the biggest issue with is "First Sale Date"
Thank you for your help.