BeyondERP.Newsletter
Menu

Report page · Inventory 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
Maintain inventory levels
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 processMaintain inventory levels
Menu pathInventory management › Inquiries and reports › Inventory value 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, when you reconcile inventory with the general ledger, or when you need on-hand values for a period.
How oftenMonthly for reconciliation, and on demand.
Batch settingsRun it in the background for long date ranges. For very many items, use Inventory value report storage, which always runs as a batch job and saves the result.
What the output showsInventory quantities and amounts for the period, with the subtotals and general ledger balances that the configuration includes. A gap between inventory and ledger often comes from filters on Records to include, or from a configuration whose Range is Transaction time, which can't be used to reconcile with the ledger.

Source: Microsoft Learn

Steps from Microsoft

  1. Go to Inventory management > Inquiries and reports > Inventory value reports > Inventory value.
  2. On the Parameters FastTab, enter a Name, and in ID select the inventory value report configuration that sets the report's columns and rows.
  3. Set the Date interval with a Date interval code, or enter the From date and To date.
  4. On Records to include, add filters only when needed. They apply to inventory transactions but not to the general ledger balance, so filtering can show a difference between inventory and the ledger.
  5. Run the report and compare the inventory amounts with the general ledger balances that the configuration shows.

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 inventory value report only reads transactions and balances; 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 itAccounting manager LedgerAccountingManagerInventory accountant clerk InventCostCostClerkInventory accountant InventCostAccountantGive 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