BeyondERP.Newsletter
Menu

Report page · Inventory management

Inventory value statement with standard cost breakdowns

A report that shows the inventory value statement for a date interval, grouped and sorted as you choose, with column headings by cost group type and optional detail.

Business process
Maintain inventory levels
Menu item
output:InventCostValue
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 the inventory value statement for a date interval, grouped and sorted as you choose, with column headings by cost group type and optional detail.
What you do hereUse this report to review inventory value by item or another grouping, with a breakdown by cost group type.
Inventory value statement with standard cost breakdowns 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 statement with standard cost breakdowns
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 itWhen you review inventory value by cost group, for example at period end or after a standard cost update.
How oftenOn demand, usually at period end.
What the output showsAn inventory value statement for the period, grouped as chosen, with one column per cost group type and the beginning balance when included. Totals that look wrong usually come from the date interval, or from leaving Include beginning off.

Source: Microsoft Learn

Steps from Microsoft

  1. Go to Inventory management > Inquiries and reports > Inventory value reports > Inventory value statement with standard cost breakdowns.
  2. Select a Date interval code, or enter the From date and To date.
  3. Under Sorting and grouping, choose how to order the statement; Item is the default.
  4. In Column headings, keep Cost group type to split values by cost group type, set Detail, and switch Include beginning to Yes to include the beginning balance.
  5. Under View, switch on the dimensions to show, then run the report and review each line's value split by cost group type.

Source: Microsoft Learn

Solution architect

4Design impact

Can it be undoneNothing to undo: The statement only reads inventory transactions; it changes nothing. Microsoft Learn
Technical architect

5Technical

Menu itemoutput:InventCostValue 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:InventCostValue
Everyone

7Sources