BeyondERP.Newsletter
Menu

Report page · Cost 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
Print inventory costing reports in Dynamics 365 Finance
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 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 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 itAt period end for standard cost items, when you need the inventory value split by cost group type.
How oftenMonthly, at period end.
What the output showsInventory value per grouping for the period, broken down into columns by cost group type, with optional opening balance and detail. A value in an unexpected cost group usually means an item or cost category is linked to the wrong cost group.

Source: Microsoft Learn

Steps from Microsoft

  1. Go to Cost management > Inquiries and reports > Inventory accounting - status reports > Inventory value statement with standard cost breakdowns.
  2. Select a Date interval code, or enter the From date and To date of the statement.
  3. In Sorting and grouping, choose how lines are grouped, for example by Item, and in Column headings keep Cost group type to split the value into material, labor and indirect cost.
  4. Set Detail, and switch Include beginning to Yes when the statement should start from the opening balance of the period.
  5. Under View, turn on the dimensions you need, run it, and check that the cost group columns add up to the total value per item.

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

7Sources