Item Age Composition - Quantity (report)

The Item Age Composition - Quantity report shows current remaining inventory quantities 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 the total inventory.

The values represent remaining quantities on open item ledger entries. Each entry's posting date determines its age bucket. 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 obsolete and will be removed in a later release. Please start using the replacement Item Age Composition by Quantity and Value (Excel)

Use cases

Review the age of stock in your warehouse by quantity to identify unused or slow moving inventory.

Inventory and warehouse managers use the report to:

  • Review the age of stock in their inventory or warehouse by quantity to identify unused or slow-moving inventory.
  • Identify older remaining inventory that needs review before you reorder.
  • Review older inventory. To check expiration dates, use the Item Expiration - Quantity report.

Purchasing managers use the report to:

  • Review the age of remaining inventory when planning purchases. The report doesn't measure demand.
  • Review the age of stock in their inventory or warehouse by quantity to identify unused or slow-moving inventory.
  • Negotiate better pricing with suppliers for slow-moving inventory.

Financial analysts use the report to:

  • Review the age distribution of current inventory quantities.
  • Calculate inventory turnover ratios and days in inventory to ensure effective inventory management.

Try the report

Try the report here: Item Age Composition - Quantity

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.

Alternative reports

There are several other ways to analyze your inventory. Learn more in the following articles:

Inventory and warehouse report overview
Ad hoc analysis of inventory data
Inventory analytics overview

Find free e-learning modules for Business Central here