Item Age Composition - Value (report)
The Item Age Composition - Value report shows the value of on-hand inventory aged by receipt date.
You can configure the report's aging to generate three equal length periods on an ending date. The inventory's age is calculated for each period, as well as before and after the period. The report also shows total value of inventory.
The values represent the total cost of the remaining quantity for open inbound item ledger entries, which are usually a result of purchases, output, or positive adjustments. The posting date of each entry determines the bucket they're in.
To determine the age of inventory by warehouse, you can filter the report by location. You can also filter by item.
Use cases
Warehouse managers use the report to:
- Review the age of stock in your warehouse by value to identify unused or slow-moving inventory.
- Analyze inventory aging to identify which items are in high demand and which aren't.
- Plan promotions or markdowns to sell slow-moving inventory and improve sales.
Sales and marketing managers use the report to:
- Analyze inventory aging to identify which items are in high demand and which aren't.
- Review the age of stock in your warehouse by value to identify unused or slow-moving inventory.
- Plan promotions or markdowns to sell slow-moving inventory and improve sales.
Financial analysts use the report to:
- Calculate inventory turnover ratios and days in inventory to ensure effective inventory management.
Try the report
Try the report here: Item Age Composition - Value
Tip
If you hold down the CTRL key while you select the report link, the report opens on a new browser tab. In this way, you can stay on the current page while you explore the report on the other browser tab.
See also
Inventory and warehouse report overview
Ad hoc analysis of inventory data
Inventory analytics overview