BeyondERP.Newsletter
Menu

Job page · Production control

BOM price calculation

A periodic dialog where you run bill of materials (BOM) calculations that roll up the cost, and optionally the suggested sales price, of manufactured items into a costing version.

Business process
Maintain product costs
Menu item
action:ProdBOMCalc
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 periodic dialog where you run bill of materials (BOM) calculations that roll up the cost, and optionally the suggested sales price, of manufactured items into a costing version.
What you do hereUse this page to calculate the cost of manufactured items and create item cost records in a costing version, and to calculate suggested sales prices for them.
ExampleFor example, after correcting the cost of a purchased item you calculate the cost of every manufactured item whose BOM version contains that item as a component.
BOM price calculation 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 pathProduction control › Periodic tasks › Update costs › BOM price calculation
Set up firstCosting versions Microsoft Learn BOM calculation groups Microsoft Learn
Used next byItem price Microsoft Learn
Related pagesCosting version setup Microsoft Learn Default production flow 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 itWhen the cost and suggested sales price of production orders must be recalculated, for example after cost or profit setting changes.
How oftenOn demand, or as a recurring batch with Late selection when orders are added continuously.
Batch settingsSchedule it in the background with Late selection when many orders are calculated.
What the output showsCalculated cost and suggested sales price for each selected order, based on its components, routing operations and indirect costs with the profit percentages of the chosen profit setting. A sales price that looks off usually points to the profit-setting percentages on the cost groups.

Source: Microsoft Learn

Steps from Microsoft

  1. Go to Production control > Periodic tasks > Update costs > BOM price calculation.
  2. Select Select to choose the production orders to calculate, or Default values to reset the dialog.
  3. On the General tab, set the Date and the Profit-setting; the profit setting picks which set of profit percentages (Standard, Profit 1, Profit 2 or Profit 3) is used for the suggested sales price.
  4. Choose whether References are calculated as well, and set Late selection to Yes when the calculation runs as a recurring batch so the orders are selected at run time.
  5. Open the calculated orders and review the calculated cost and sales price on their price calculation.

Source: Microsoft Learn

Fields on the page

FieldWhat it means
Costing versionThe costing version that receives the calculated cost records; it also sets the policies the calculation must follow.Microsoft Learn
BOM versionThe BOM version to calculate from; the active version is used by default but an approved version can be chosen.Microsoft Learn
Calculation quantityThe quantity the calculation is based on; the item's standard order quantity by default.Microsoft Learn
Calculation dateThe date the calculation applies to; a future date decides which pending cost records are used.Microsoft Learn
Explosion modeHow far down the BOM the calculation explodes; single-level, multilevel, make-to-order or by BOM line type.Microsoft Learn
Profit settingThe set of profit percentages used when a sales price is calculated.Microsoft Learn
Fallback principleWhere to find a cost when the costing version has none: nowhere, the active cost, or another costing version.Microsoft Learn
Solution architect

4Design impact

Can it be undoneYes, by running it again: Correct the BOM, route or profit setting and run the calculation again to replace the result. Microsoft Learn
If you change it laterUpdates the calculated cost and sales price of the selected production orders; it posts nothing to inventory or the ledger. Microsoft Learn
Technical architect

5Technical

Menu itemaction:ProdBOMCalc Checked in Dynamics 365
FormProdParmBOMCalc Checked in Dynamics 365
Roles to set it up and use itTo use itProduction supervisor ProdProductionSupervisorGive people one of these roles. On this system, 1 role can run this page.Checked in Dynamics 365
Developer

6Developer

Open it by URLhttps://<your-environment>/?mi=action:ProdBOMCalc
Everyone

7Sources