BeyondERP.Newsletter
Menu

Report page · Cost 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
Print inventory costing reports in Dynamics 365 Finance
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 processAnalyze financial performance › Analyze costs › Print inventory costing reports in Dynamics 365 Finance
Menu pathCost management › Inquiries and reports › Inventory accounting - analysis 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 itAt period end after inventory closing, when you review slow-moving stock or obsolescence provisions.
How oftenMonthly or quarterly, at period end.
What the output showsOn-hand quantity and value per item and dimension, split into the aging buckets, with inventory value and average unit cost. Values per warehouse reuse the site's average cost when warehouse isn't a financial dimension; for many items use Inventory aging report storage instead.

Source: Microsoft Learn

Steps from Microsoft

  1. Go to Cost management > Inquiries and reports > Inventory accounting - analysis reports > Inventory aging.
  2. Enter the As of date. Run inventory closing for the period first if you need final values.
  3. Under View, set Item group and Item number, and choose Yes or No for each dimension such as Site, Warehouse, Batch number or Inventory status.
  4. Under Aging period, select the Unit of aging period and enter Aging period 1 to Aging period 4 to build the buckets, for example monthly.
  5. Read each bucket: quantities are assigned first in, first out from the receipts, and amounts use the average unit cost of the financial dimension.

Source: Microsoft Learn

Solution architect

4Design impact

Can it be undoneNothing to undo: The 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 itInventory accountant InventCostAccountantInventory accountant clerk InventCostCostClerkAccounting manager LedgerAccountingManagerProduction manager ProdProductionManagerProduction supervisor ProdProductionSupervisorGive 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