The Aging analysis report shows the length of time that inventory has been in a particular warehouse. The report assumes first in-first out inventory management.
Inventory Planner maintains a stock audit trail, where each intake increases the value of new stock in the corresponding time window. In order to compute the age of a product for the aging analysis, Inventory Planner walks through the historical stock backwards, subtracting intakes from the current stock until it reaches zero.
Since the aging report is computed based on historical stock, it won't populate with information immediately after connecting your store to Inventory Planner.
To access the aging analysis report, click on Reports in the left menu, then Aging analysis.
Filtering the Aging analysis report
As with other reports, you can use the dropdown menus on the top left-hand side to filter the Year on Year report by warehouse and dimension such as categories, vendors, products, variants, etc.
The columns on the Aging analysis report are groups of time periods. The values in each column correspond to the stock whose age falls into that group. For example, if the report lists 10 units in the 31-60 days column, there are 10 units which are between 31 and 60 days old.
The groups are:
Current (total)
0 - 30 days
31 - 60 days
61 - 90 days
91 - 180 days
181 - 365 days
> 365 days
Aging analysis metrics
The metrics available on the Aging analysis report are:
Metric | Description |
Stock | The number of units |
Stock cost | The cost of the units of stock |
Stock retail | The retail value of the units of stock |