BeyondERP.Newsletter
Menu

Report page · Product information management

Calculation details for cost and price

A report that prints the details of cost and price calculations, with options for the product and storage dimensions to show.

Business process
Maintain product costs
Menu item
output:BOMCalcTrans
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 the details of cost and price calculations, with options for the product and storage dimensions to show.
What you do hereUse this report to review the results of cost and sales price calculations for items, broken down by the dimensions you select.
Calculation details for cost and price 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 processManage active products › Maintain product costs
Menu pathProduct information management › Inquiries and reports › Calculation details for cost and price
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 you run a BOM cost or sales price calculation, to review how the result was built up.
How oftenOn demand, after each cost or price calculation that needs review.
Batch settingsUse a background run only when you print many calculations at once.
What the output showsThe calculation lines behind a cost or sales price calculation: each component and operation with quantity, cost and resulting price, by the dimensions you chose. A total that looks wrong usually comes from a missing cost price on a component or the wrong BOM or route version.

Source: Microsoft Learn

Steps from Microsoft

  1. Go to Product information management > Inquiries and reports > Calculation details for cost and price.
  2. Under View, select the Configuration, Size, Color, Style and Site dimensions that the calculation results should be split by.
  3. In Records to include, filter on the item, the calculation date or the costing version whose calculation you want to review.
  4. Run the report and compare the material and operation costs with the BOM and route that the calculation used.

Source: Microsoft Learn

Solution architect

4Design impact

Can it be undoneNothing to undo: The report reads calculation results and doesn't change any cost or price. Microsoft Learn
Technical architect

5Technical

Menu itemoutput:BOMCalcTrans Checked in Dynamics 365
FormSysOperationTemplateForm Checked in Dynamics 365
Roles to set it up and use itTo use itProduction manager ProdProductionManagerAccounting manager LedgerAccountingManagerInventory accountant InventCostAccountantInventory accountant clerk InventCostCostClerkGive people one of these roles. On this system, 4 roles can run this page.Checked in Dynamics 365
Developer

6Developer

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

7Sources