BeyondERP.Newsletter
Menu

Report page · Cost management

Variance analysis statement

A report that prints inventory variances, such as revaluation variances, for a date interval that you select.

Business process
Analyze product cost variances in Dynamics 365 Supply Chain Management
Menu item
output:InventCostVariances
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 prints inventory variances, such as revaluation variances, for a date interval that you select.
What you do hereUse this report to analyse variances, sorted and grouped as you choose, with column headings by cost group type and optional detail by inventory dimension.
ExampleFor example, after a standard cost conversion, you can use this report to view the inventory revaluation variances for the converted items.
Variance analysis statement 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 product performance › Monitor product performance › Analyze product cost variances in Dynamics 365 Supply Chain Management
Menu pathCost management › Inquiries and reports › Inventory accounting - analysis reports › Variance analysis statement
Related pagesStandard cost transactions Microsoft Learn Standard cost conversions 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 itAfter a standard cost conversion or a revaluation of standard cost items, to analyze the revaluation variances.
How oftenOn demand after conversions and cost activations, and at period end for standard cost items.
What the output showsVariances such as inventory revaluation variances for the period, sorted and grouped as chosen, with columns by cost group type. A large revaluation variance usually means the new standard cost differs strongly from the old inventory value.

Source: Microsoft Learn

Steps from Microsoft

  1. Go to Cost management > Inquiries and reports > Inventory accounting - analysis reports > Variance analysis statement.
  2. Select a Date interval code, or enter a From date and a To date; after a standard cost conversion, include the conversion date.
  3. Select the Sorting and grouping, for example by item, and the Column headings, for example Cost group type.
  4. Set Detail and Level to choose between totals and detail lines per variance.
  5. Under VIEW, turn on Configuration, Size, Color, Style, Site and Warehouse as needed, run it, and read the revaluation variances of the items you converted or revalued.

Source: Microsoft Learn

Solution architect

4Design impact

Can it be undoneNothing to undo: The report only reads standard cost transactions; it changes nothing. Microsoft Learn
Technical architect

5Technical

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

7Sources