Discussions
Join us for complimentary one-day events around the world and step into a future fueled by AI and limitless potential. Explore new breakthroughs, sharpen your skills, and connect with experts who are shaping what’s next. Experience bold keynotes, interactive learning, and connections that span the global NetSuite community. Discover what's next at SuiteConnect Tour 2026.
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.