The Inventory Aging report shows how old your stock is. Old stock means money tied up in products that aren't selling.
How to open it
Go to Reports, then Inventory, then Inventory Aging Report.
Pick a date.
Click Interval. Fill in Interval (for example 30) and Through (for example 90). Anything older than Through goes in the last column.
Click Run Report.
What the columns mean
Item: the product.
Current Stock: units you had on the date you picked.
Avg days in stock: the average age of those units. For example, 45 means your units have been in stock for 45 days on average.
Total Value: what those units cost you.
Age columns: 1 column for each age group, such as 0 to 30 days and 30 to 60 days, plus a last column for anything older than Through (like 90+). Each shows Qty and Value.
Filter the report
Use Filter to look at certain products or categories. Change the interval to see different age groups.
Frequently asked questions
Does Avg days in stock tell me how fast an item sells?
No. It shows how long the units you still have have been sitting. A high number means old stock.
Why is an item missing?
An item is left out if it's inactive, if it isn't an Inventory or Assembly item, if a filter hides it, or if you're a user who can only see the items assigned to you. Items with no stock still show, with 0.