BeyondERP.Newsletter
Menu

Report page · Inventory management

Inventory aging

A report that sorts on-hand quantity and inventory value for a selected item or item group into several aging period buckets.

Business process
Maintain inventory levels
Menu item
output:InventAging
Show what matters for
PAGE GUIDEWhat the page does and how to use it7 sections. Choose a role to highlight what matters to you.
Everyone

1What it is and why

What it isA report that sorts on-hand quantity and inventory value for a selected item or item group into several aging period buckets.
What you do hereUse this report to see how old your inventory is and what it is worth in each period, as of a chosen date.
ExampleFor example, a report run as of May 9 with monthly buckets shows how much of an item's on-hand quantity and value falls in each month.
Inventory aging page in Dynamics 365
The page in Dynamics 365. page title tab to open what to set or check
Functional consultant · Solution architect

2Where it fits

Business processMaintain inventory levels
Menu pathInventory management › Inquiries and reports › Physical inventory reports › Inventory aging
Related pagesInventory aging report storage Microsoft Learn
End user · Functional consultant

3How to do it

About the examples: Examples and screenshots in this guide use BEAT, a demo company in a Dynamics 365 test environment. Use your own company's codes and values instead of copying them.

When to run it

When to run itAfter inventory close for the month, or whenever you need to see how long stock has been on hand as of a date.
How oftenMonthly after inventory close, and on demand for analysis.
Batch settingsFor many items and warehouses, Microsoft recommends the Inventory aging report storage version, which saves each run and lets you export it.
What the output showsPer item and dimension: On-hand quantity, On-hand value, Inventory value quantity, Inventory value, Average unit cost, and a quantity and amount for each aging period. Issues are deducted first in, first out regardless of the item's inventory model, so bucket amounts can differ from the costing view; values change after inventory close.

Source: Microsoft Learn

Steps from Microsoft

  1. Go to Inventory management > Inquiries and reports > Physical inventory reports > Inventory aging.
  2. Enter the As of date. For final values, use a date in a period that inventory close has already settled, because closing updates the inventory value and average unit cost.
  3. Under View, set Item group and Item number, and choose Yes or No for each dimension. Showing Warehouse splits a site into one row per warehouse, while the value columns stay at the financial dimension level.
  4. Under Aging period, select the Unit of aging period and enter Aging period 1 to Aging period 4 to size each bucket.
  5. Run the report and read the buckets: each holds the quantity received in that period that is still on hand, valued at the average unit cost.

Source: Microsoft Learn

Solution architect

4Design impact

Can it be undoneNothing to undo: The aging report only reads transactions; it changes nothing. Microsoft Learn
If you change it laterRun the report after inventory closing to get final values; closing updates the inventory value and average unit cost shown. Microsoft Learn
Technical architect

5Technical

Menu itemoutput:InventAging Checked in Dynamics 365
FormSysOperationTemplateForm Checked in Dynamics 365
Roles to set it up and use itTo use itQuality control manager InventQualityControlManagerWarehouse manager WMSWarehouseManagerMaterials manager InventMaterialsManagerProduction supervisor ProdProductionSupervisorAccounting manager LedgerAccountingManagerGive people one of these roles. On this system, 16 roles can run this page.Checked in Dynamics 365
Developer

6Developer

Open it by URLhttps://<your-environment>/?mi=output:InventAging
Everyone

7Sources