The Item Age Composition by Quantity and Value report shows current remaining inventory quantities and values aged by posting 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 report uses remaining quantities on open item ledger entries. Each entry's posting date determines its age bucket. Values are calculated from the remaining quantities and costs, with a separate calculation for average-cost items. The ending date defines the age buckets, not a historical snapshot of remaining quantities.
To determine the age of inventory by warehouse, you can filter the report by location. You can also filter by item.
Note
This report is a replacement of the obsolete report Item Age Composition - Quantity.
Available layouts
INTRODUCED IN: Business Central 2026 release wave 1.
The report includes an Excel layout with worksheets designed for print and for analysis.
You can export the layout from the Report Layouts page, edit it in Excel to cater for your needs, and import it back to Business Central. Learn more in Creating your own report layouts.
Use cases
Review the age of stock in your warehouse by value to identify unused or slow-moving inventory.
Warehouse managers use the report to:
- Review the age of stock in your warehouse by value to identify unused or slow-moving inventory.
- Review the quantities and values in each age bucket. Inventory age alone doesn't measure demand.
- Plan promotions or markdowns to sell slow-moving inventory and improve sales.
Sales and marketing managers use the report to:
- Identify older inventory to review alongside sales and demand information.
- 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 by Quantity and Value
Tip
If you hold down the Ctrl key while you select the report link, the report opens on a new browser tab. The new tab lets you stay on the current page while you explore the report on the other browser tab.
Related information
Inventory and warehouse report overview
Ad hoc analysis of inventory data
Inventory analytics overview