BeyondERP.Newsletter
Menu

Inquiry page · Production control

Master manufacturing record

An inquiry page that assembles the master manufacturing record (MMR) for an item: every approved BOM or formula version and route version, the quality associations that generate quality orders, and the inventory batch attributes with their target values and ranges.

Used by
Product designer, Materials manager, Quality control manager and 4 more roles
Business process
Analyze production quality results
Menu item
QMSMasterMfgRecord
Main table
InventTable
Data entity
EcoResReleasedProductV2Entity
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 isAn inquiry page that assembles the master manufacturing record (MMR) for an item: every approved BOM or formula version and route version, the quality associations that generate quality orders, and the inventory batch attributes with their target values and ranges.
What you do hereUse this page to show, for an item and optionally a site, date and quantity, all the approved ways the item may be produced and all the characteristics that may be measured on it or its ingredients.
ExampleFor example, before a regulatory inspection a quality manager runs the MMR query for a formula item to list the approved formula and route versions and the quality tests tied to them.
Master manufacturing record 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 production operations › Analyze production quality results
Menu pathProduction control › Inquiries and reports › Electronic batch records › Master manufacturing record
Set up firstProduction control parameters (Electronic batch record tab) Microsoft Learn BOM versions / Formula versions (approved) Microsoft Learn Quality associations Microsoft Learn
Used next byBatch production record Microsoft Learn
Related pagesTest groups (test plan instructions) 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 Production control > Inquiries and reports > Electronic batch records > Master manufacturing record.
  2. Select the Item number.
  3. Optionally select a Site, a from Date and a from Quantity to narrow the versions.
  4. Review the General, BOM/formula versions, Route versions, Quality associations and Inventory batch attributes FastTabs.
  5. Select Details on a quality association to open it.

Source: Microsoft Learn

Fields on the page

FieldWhat it means
Item numberThe item to report on; only BOM, formula and planning items are offered.Microsoft Learn
SiteLimits the versions shown to one site.Microsoft Learn
DateA from date used to filter the formula or BOM versions.Microsoft Learn
QuantityA from quantity used to filter the formula or BOM versions.Microsoft Learn
Quality associations (FastTab)All quality association relations for the item, with a Details button to open each.Microsoft Learn
Inventory batch attributes (FastTab)The batch attributes defined for the item.Microsoft Learn
Solution architect

4Design impact

Shared or per companyPer company: each legal entity has its own records. Microsoft data model
If you change it laterThe query is read-only, but because it lists only approved versions, removing or adding approval on a BOM, formula or route changes what the MMR shows. Microsoft Learn
Technical architect

5Technical

Menu itemQMSMasterMfgRecord Checked in Dynamics 365
FormQMSMasterMfgRecord Checked in Dynamics 365
TableInventTableShown as “ITEMS” in Record infoKey field: ItemIdChecked in Dynamics 365
Data entitiesEcoResReleasedProductV2EntityReleased products V2 Microsoft data model DimAttributeInventTableEntityItems Microsoft data model RetailButtonGridProductSearchDataSetItems Microsoft data model RetailInventTableEntityItems Microsoft data model
Who can open itPrivilegesView electronic batch records QMSElectronicBatchRecordViewDutiesInquire into electronic batch records QMSElectronicBatchRecordInquire
7 security rolesProduct designer BOMProductDesignerMaterials manager InventMaterialsManagerQuality control manager InventQualityControlManagerShop supervisor JmgShopSupervisorProduction manager ProdProductionManagerProduction planner ReqProductionPlannerProcess engineer RouteProcessEngineer
Checked in Dynamics 365
Roles to set it up and use itTo use itProduction manager ProdProductionManagerShop supervisor JmgShopSupervisorProduction planner ReqProductionPlannerProcess engineer RouteProcessEngineerMaterials manager InventMaterialsManagerGive people one of these roles. On this system, 7 roles can open this page.Checked in Dynamics 365
Actions on the page(Action Pane without tabs): Display dimensionsChecked in Dynamics 365
Developer

6Developer

Open it by URLhttps://<your-environment>/?mi=QMSMasterMfgRecord
Integrate withEcoResReleasedProductV2Entity data entity Microsoft data model
Table definitionInventTable columns and relations Microsoft data model
Everyone

7Sources