Obsolete Inventory Report?
I am in need of an Obsolete Inventory Report which would show the last transaction date of item numbers with on hand quantity > 0. I need to be able to filter by Doc Type, because I only care about inventory that has been issued, sold, made, or received within a certain time range (or last transaction older than 6 months, 1 year, 2 years ago).
Currently, I have developed this report using ReportsNow but it is driven off the F4111 Item Ledger file which has millions of transactions records to look through. My report takes a long time to run, and will only take longer as the business ages (more transactions, more data).