BeyondERP.Newsletter
Menu

Inquiry page · Master planning

Item requirement statistics

An inquiry page that lists the item requirements, stated as planned orders, that the most recent master planning run calculated.

Used by
Chief executive officer, Production manager, Production planner
Business process
Report on and analyze trends
Menu item
ReqPoItemStatistic
Main table
ReqPO
Data entity
ReqDynamicPlanProductionOrderScheduleEntity
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 lists the item requirements, stated as planned orders, that the most recent master planning run calculated.
What you do hereUse this page to analyze long-term and short-term item requirements, for example by vendor group or item group, and use the results when you agree terms with vendors.
ExampleFor example, you group a plan's requirements by week to see how much of each item is needed in each week.
Item requirement statistics 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 business performance › Report on and analyze trends
Menu pathMaster planning › Inquiries and reports › Master planning › Item requirement statistics
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.

How to use it

  1. Go to Master planning > Inquiries and reports > Master planning > Item requirement statistics.
  2. In Plan, select the plan, such as MasterPlan.
  3. Under Item and Vendor, use Show by to total the requirements by item or item group and by vendor or vendor group.
  4. Enter the From date and To date, and choose the Period, such as Total.
  5. Choose the Summation, such as Requirement quantity, and select By planned order type to split the totals by order type.
  6. Review the Site, Warehouse and Requirement quantity columns on the Overview tab, or open the Graphics tab for a chart.

Source: Checked in Dynamics 365

Fields on the page

FieldWhat it means
Show byShows requirements by vendor or by item, at group or single level.Microsoft Learn
From date / To dateThe period to show; if left empty, all requirements are listed.Microsoft Learn
PlanThe master plan whose requirements are shown.Microsoft Learn
PeriodHow requirements are grouped, for example by week.Microsoft Learn
By planned order typeShows the planned order type behind each requirement.Microsoft Learn
SummationShows requirements as item quantity or as planned order cost amount.Microsoft Learn
Req. quantityThe planned order quantity, which can differ from the need because of order rules such as a minimum order quantity.Microsoft Learn
Solution architect

4Design impact

Shared or per companyPer company: each legal entity has its own records. Microsoft data model
Technical architect

5Technical

Menu itemReqPoItemStatistic Checked in Dynamics 365
FormReqPoItemStatistic Checked in Dynamics 365
TableReqPOShown as “PLANNED ORDER” in Record infoKey field: RefIdChecked in Dynamics 365
Data entitiesReqDynamicPlanProductionOrderScheduleEntityPlanned production orders schedule Microsoft data model
Who can open itPrivilegesView item requirement statistics ReqPoItemStatisticViewDutiesReview master scheduling performance ReqMasterSchedulingProcessPerfReviewInquire into master scheduling statistics ReqMasterSchedulingStatusInquireMaintain planned orders ReqPlannedOrdersMaintain
3 security rolesChief executive officer CompanyChiefExecutiveOfficerProduction manager ProdProductionManagerProduction planner ReqProductionPlanner
Checked in Dynamics 365
Roles to set it up and use itTo use itProduction planner ReqProductionPlannerProduction manager ProdProductionManagerChief executive officer CompanyChiefExecutiveOfficerGive people one of these roles. On this system, 3 roles can open this page.Checked in Dynamics 365
Actions on the page(Action Pane without tabs): Inventory, Planned order cost calculationChecked in Dynamics 365
Developer

6Developer

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

7Sources