BeyondERP.Newsletter
Menu

Report page · Cost management

Inventory value

A report that shows inventory quantities and values for a date range, using an inventory value report configuration you select.

Business process
Print inventory costing reports in Dynamics 365 Finance
Menu item
output:InventValue
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 shows inventory quantities and values for a date range, using an inventory value report configuration you select.
What you do hereUse this report to view inventory value on screen, including subtotals and general ledger balances, to support reconciliation with the ledger.
ExampleFor example, after a standard cost conversion you can run this report up to one day before the conversion date to check the values of the converted items.
Inventory value 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 - status reports › Inventory value
Set up firstInventory value report configurations Microsoft Learn
Related pagesInventory value report storage Microsoft Learn Potential conflicts - inventory and general ledger 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 close, to reconcile inventory with the general ledger.
How oftenMonthly at period end, and on demand during reconciliation.
Batch settingsRun it in the background for many items; for very large outputs use Inventory value report storage instead.
What the output showsPhysical and financial quantities and amounts per the configuration's dimensions, with subtotals and, if set up, ledger balances for comparison. Only dimensions enabled for financial inventory show values. Exclude Physical Amount Not Posted when you reconcile, or the totals won't match the ledger.

Source: Microsoft Learn

Steps from Microsoft

  1. Go to Cost management > Inquiries and reports > Inventory accounting - status reports > Inventory value.
  2. On the Parameters FastTab, enter a unique Name for the run.
  3. In ID, select the inventory value report configuration; it decides the columns (inventory, WIP, COGS, ledger balances) and rows the report shows.
  4. Set the date interval with a Date interval code or with From date and To date. Filters in Records to include apply to inventory transactions only, not to the ledger balance.
  5. Compare the inventory amounts with the general ledger account balances printed by the configuration, and investigate any difference.

Source: Microsoft Learn

Fields on the page

FieldWhat it means
IDThe inventory value report configuration that sets the report's columns and rows.Microsoft Learn
Date intervalThe period the report covers, set by a date interval code or by from and to dates.Microsoft Learn
Solution architect

4Design impact

Can it be undoneNothing to undo: The report only reads inventory and ledger data and doesn't store results; it changes nothing. Microsoft Learn
If you change it laterThe report can only show inventory dimensions that are enabled for financial inventory. Microsoft Learn
Technical architect

5Technical

Menu itemoutput:InventValue 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 LedgerAccountingManagerGive people one of these roles. On this system, 3 roles can run this page.Checked in Dynamics 365
Developer

6Developer

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

7Sources