BeyondERP.Newsletter
Menu

Report page · Cost 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 pathCost management › Inquiries and reports › Predetermined cost 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 a BOM calculation for an item or costing version, or an order-specific calculation on a sales order or quotation, when you need to explain the result.
How oftenOn demand, after each BOM calculation you need to review.
What the output showsThe calculation details per item: component costs, operation costs and indirect costs that add up to the calculated cost, plus the calculated sales price. An unexpected total usually comes from a missing cost record that was filled by the fallback principle or a component with no cost price.

Source: Microsoft Learn

Steps from Microsoft

  1. Go to Cost management > Inquiries and reports > Predetermined cost reports > Calculation details for cost and price.
  2. In Records to include, filter on the calculation, item or costing version whose BOM calculation result you want to explain.
  3. Under View, turn on Configuration, Size, Color, Style and Site when the calculated item has product dimensions or is calculated per site.
  4. Read the lines from top to bottom: each component, routing operation and indirect cost contributes to the calculated cost, and the sales price follows from the profit setting.
  5. Compare the total with the item's pending cost or the order-specific result before you activate or transfer it.

Source: Microsoft Learn

Solution architect

4Design impact

Can it be undoneNothing to undo: The report only reads stored calculation details; it changes nothing. 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 itInventory accountant InventCostAccountantInventory accountant clerk InventCostCostClerkAccounting manager LedgerAccountingManagerProduction manager ProdProductionManagerGive 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