Discussions
Aged Inventory Report
There is already a SuiteAnswers that says that there is an enhancement request to make an Inventory Aging report as standard. SO for now, I'm thinking I need to use a Saved Search or Report
What we want to see is the following columns:
Item Location On Hand at 30/6/2020 Current Year Last Year Year Before
A 50 50 0 0
B 500 0 500 0
C 100 90 10
Item A, all stock purchased in the current financial year
Item B has 500 on hand all of which has been in stock since year before. Sales of this item may have been 2,000 units and we've used 2,000 of the year before stock but still 500 pieces remain.