BeyondERP.Newsletter
Menu

Page · Product information management

Formulas

A list page that shows the formulas, the subtype of bill of materials that is typically used for process manufacturing, with the Formula, Name, Site, Item group, Approved by and Approved columns.

Used by
Product designer, Product design manager, Inventory accountant and 7 more roles
Business process
Design formulas
Menu item
PmfFormulaTable
Main table
BOMTable
Data entity
PmfFormulaHeaderEntity
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 list page that shows the formulas, the subtype of bill of materials that is typically used for process manufacturing, with the Formula, Name, Site, Item group, Approved by and Approved columns.
What you do hereUse this page to create, copy and approve formulas. In addition to components and ingredients, a formula describes the co-products and by-products of the process.
ExampleFor example, you can create a new formula by copying an existing formula that has most of the ingredients you need and then adjusting the copied lines.
Formulas 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 processIntroduce products › Design formulas
Menu pathProduct information management › Bills of materials and formulas › Formulas
Related pagesBills of materials 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.

Steps from Microsoft

  1. Go to Product information management > Bills of materials and formulas > Formulas.
  2. Select New.
  3. In the Formula field, type a value, and in the Name field, type a meaningful name for the formula.
  4. In the Site and Item group fields, select values.
  5. Select Save.
  6. To copy lines from another formula, on the Action Pane select Formula, select Copy, select the Item number and Formula version, and then select OK.
  7. To approve the formula, on the Action Pane select Formula, select Approve formula, select a value in the Approved by field, and then select OK.

Source: Microsoft Learn

Test checklist

  1. Create a formula with ingredient lines and approve it.
  2. Create a formula version for the formula item, add a co-product, then approve and activate the version.
  3. Create a batch order for the formula item and estimate it.
  4. Check the ingredients and the co-product appear on the batch order.

Source: Microsoft Learn

Solution architect

4Design impact

Shared or per companyPer company: each legal entity has its own records. Microsoft data model
Can it be undoneHard to reverse: A formula can be approved and unapproved, but unapproving it also unapproves its formula versions, and a version can't be used in planning or production until it's approved again. Co-products and by-products are defined on the formula version. Microsoft Learn
Technical architect

5Technical

Menu itemPmfFormulaTable Checked in Dynamics 365
FormBOMTable Checked in Dynamics 365
TableBOMTableShown as “BILLS OF MATERIALS” in Record infoKey field: BOMIdChecked in Dynamics 365
Data entitiesPmfFormulaHeaderEntityFormula headers Microsoft data model PmfItemSpecificFormulaHeaderV2EntityFormula headers and versions V2 Microsoft data model BOMBillOfMaterialsHeaderEntityBill of materials headers Microsoft data model BOMItemSpecificBillOfMaterialsHeaderV2EntityBill of materials headers and versions V2 Microsoft data model
Who can open itPrivilegesMaintain formula table PmfFormulaTableMaintainView formula table PmfFormulaTableViewDutiesMaintain BOM calculation master BOMBillsOfMaterialsCalcMasterMaintainInquire into BOM calculations BOMBillsOfMaterialsCalcStatusInquireInquire into BOM master BOMBillsOfMaterialsMasterInquireMaintain BOM master BOMBillsOfMaterialsMasterMaintain
10 security rolesProduct designer BOMProductDesignerProduct design manager BOMProductDesignManagerInventory accountant InventCostAccountantInventory accountant clerk InventCostCostClerkAccounting manager LedgerAccountingManagerProduction manager ProdProductionManagerProduction supervisor ProdProductionSupervisorProduction planner ReqProductionPlannerProcess engineer RouteProcessEngineerProcess engineering manager RouteProcessEngineeringManager
Checked in Dynamics 365
Roles to set it up and use itTo set it up or change itProduct designer BOMProductDesignerProcess engineer RouteProcessEngineerTo use itProduct design manager BOMProductDesignManagerProcess engineering manager RouteProcessEngineeringManagerProduction supervisor ProdProductionSupervisorProduction manager ProdProductionManagerAccounting manager LedgerAccountingManagerGive people one of these roles. On this system, 10 roles can open this page.Checked in Dynamics 365
Actions on the pageFormula: Maintain, Configuration, Product changeChecked in Dynamics 365
Developer

6Developer

Open it by URLhttps://<your-environment>/?mi=PmfFormulaTable
Integrate withPmfFormulaHeaderEntity data entity Microsoft data model
Data migrationPmfFormulaHeaderEntity (Formula headers): loaded for each company.PmfItemSpecificFormulaHeaderV2Entity (Formula headers and versions V2): loaded for each company.Microsoft Learn
Table definitionBOMTable columns and relations Microsoft data model
Everyone

7Sources