Discussions
SuiteWorld brings thousands of innovators, builders, and leaders together to learn, connect, and shape what’s next. This October, explore how to build a stronger foundation for growth through inspiring keynotes, major product reveals, hands-on sessions, and unforgettable moments—all in one place for our biggest event of the year. Join us
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.