BeyondERP.Newsletter
Menu

Inquiry page · Cost management

Inventory aging report storage

A list page that stores each run of the inventory aging report, so that you can view the results as a form or a chart and export them.

Used by
Maintenance clerk, Maintenance manager, Field Service Integration User and 13 more roles
Business process
Print inventory costing reports in Dynamics 365 Finance
Menu item
InventAgingStorage
Main table
InventAgingStorage
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 list page that stores each run of the inventory aging report, so that you can view the results as a form or a chart and export them.
What you do hereUse this page to generate, store and review inventory aging reports, which break down on-hand inventory into up to four aging periods as of a date that you choose.
ExampleFor example, the stored report suits companies with many lines of output, such as 50,000 items and 300 stores set up as warehouses, when aging is requested by item, site and warehouse.
Inventory aging report storage 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 aging report storage
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.

Steps from Microsoft

  1. Go to Cost management > Inquiries and reports > Inventory aging report storage.
  2. Select New to open the Inventory aging dialog.
  3. On the Parameters FastTab, enter a unique Name, set the As of date, choose which fields to include under View, and set the Unit of aging period and up to four aging periods.
  4. To limit the records in the report, expand the Records to include FastTab and add the filters you require.
  5. On the Run in the background FastTab, set the batch, scheduling and recurrence options.
  6. Select OK to run or schedule the report.
  7. When the batch job has completed, select the report in the list pane and select View details or View chart on the Action Pane.

Source: Microsoft Learn

Fields on the page

FieldWhat it meansTable column
As of dateThe date that the values of the report are based on. When it is left blank, the report uses the date on which it runs, which suits a repeating schedule.Microsoft Learn AsOnDate
Unit of aging periodHow the aging periods are defined: as a number of days before the As of date, as specific calendar dates, or as predefined date intervals.Microsoft Learn AgingPeriodUnit
Aging period 1 to Aging period 4Up to four aging periods, entered in the unit selected in the Unit of aging period field.Microsoft Learn
Solution architect

4Design impact

Shared or per companyPer company: each legal entity has its own records. Microsoft data model
Technical architect

5Technical

Menu itemInventAgingStorage Checked in Dynamics 365
FormInventAgingStorage Checked in Dynamics 365
TableInventAgingStorageShown as “INVENTAGINGSTORAGE” in Record infoChecked in Dynamics 365
Who can open itPrivilegesGenerate inventory aging report InventAgingGenerateDutiesInquire into inventory status InventStatusInquire
16 security rolesMaintenance clerk EntAssetMaintenanceClerkMaintenance manager EntAssetMaintenanceManagerField Service Integration User FieldServiceIntegrationUserInventory accountant InventCostAccountantInventory accountant clerk InventCostCostClerkMaterials manager InventMaterialsManagerQuality control manager InventQualityControlManagerAccounting manager LedgerAccountingManagerProduction manager ProdProductionManagerProduction supervisor ProdProductionSupervisorProject assistant ProjProjectClerkProject manager ProjProjectManagerRetail service RetailServiceRetail store manager RetailStoreManagerService delivery manager SMAServiceDeliveryManagerWarehouse manager WMSWarehouseManager
Checked in Dynamics 365
Roles to set it up and use itTo set it up or change itAccounting manager LedgerAccountingManagerInventory accountant InventCostAccountantInventory accountant clerk InventCostCostClerkProduction supervisor ProdProductionSupervisorProject manager ProjProjectManagerGive people one of these roles. On this system, 16 roles can open this page.Checked in Dynamics 365
Actions on the page(Action Pane without tabs): View details, View chartChecked in Dynamics 365
Developer

6Developer

Open it by URLhttps://<your-environment>/?mi=InventAgingStorage
Table definitionInventAgingStorage columns and relations Microsoft data model
Everyone

7Sources