Manufacturing Reporting
Manufacturing Reporting is an M3 Experience Designer Application that streamlines reporting and monitoring of manufacturing operations. It is designed for operators. The application consolidates multiple M3 programs into a single application. Users can filter by work center, report material issues, and monitor backflush materials. The users can also report operations and receipts, and view transaction history. The application supports conditional styling and integrates with H5, which enables quick access to related actions.
User story
A user, who serves as an operator, needs a single and navigable application that consolidates multiple M3 manufacturing programs to efficiently report and monitor manufacturing operations without switching between different systems.
M3 Business Engine configuration
M3 Business Engine (BE) configurations are required for the Manufacturing Reporting application to function properly. You must have the center data set up in 'Work Center Schedule. Open' (PMS230) to display data in the application.
See specific configurations per component in Components
Application authorization
| Function or API | Transaction | Information Category | View |
|---|---|---|---|
| LISTMI | ListDataAsCSV | M3_LIST_MWOMAT | M3_01_01 |
| LISTMI | ListDataAsCSV | M3_LIST_MWOPTR | M3_01_01 |
| LISTMI | ListDataAsCSV | M3_LIST_MGLINE | M3_01_01 |
| LISTMI | ListDataAsCSV | M3_LIST_MWOOPE | M3_01_01 |
| MHS850MI | AddDO | ||
| MMS060MI | SearchItemLoc | ||
| PMS050MI | RptReceipt | ||
| PMS060MI | RptIssue | ||
| PMS070MI | RptOperation | ||
| PMS100MI | Get | ||
| PMS100MI | GetOperation | ||
| PMS100MI | LstMaterials | ||
| PMS100MI | LstOperations |
Manufacturing reporting application components and functions
Application Header
The Manufacturing Reporting application header displays information about which manufacturing order number, product, and facility the user has selected in the Work Center Schedule data grid.
'Work Center Schedule'
- Work Center Schedule: This grid shows manufacturing order operations, and data is loaded when the application opens.
- Operations: This grid displays all operations related to the selected order when you select a line.
- Bill of Material: This grid loads the bill of materials.
'Report Material'
- 'Report Material': This tab displays a data grid with bill of material data when you select a schedule line. The tab displays lines with issue method 2, requisition. When you select a material line, the stock balance and pending material request data grids load. A chart showing the reported material also loads at that time.
When you report a material, you can either specify all information manually or select a line in the stock balance tab to have the location and lot number filled in the dialog.
You can select the button to open a dialog that creates a replenishment order for the selected line. You must have a record in 'Stock Msg Partner. Open' (MMS865) for this process to work, with these setups:- Partner= WS
- Message type= WMS
- Message direction= I
- 'Backflush Monitor': This tab displays a data grid with bill of material data when you select a schedule line. The tab displays lines with issue methods 3 through 6. When you select a bill of material line, the stock balance and pending material request data grids load.
'Report Operation'
The 'Report Operation' tab contains a form that displays operation data when a schedule line is selected. You can report operations using the button available on the form. Additionally, a chart displaying the reported quantity is loaded simultaneously when you select the operation data. The reporting type used is manual reporting through PMS070MI.
'Report Receipt'
The 'Report receipt' tab contains a form that displays receipt data when a schedule line is selected. You can report receipts using the button available on the form. Additionally, a chart displaying the ordered and received quantities is loaded simultaneously when you select the receipt data. When a receipt is reported, PMS050MI is used.
'Transaction History'
The 'Transaction history' tab contains a data grid that displays historical operation reporting for the selected manufacturing order (MO).
Components
| Component | Component details |
|---|---|
| Application header | Component ID: appHeader
Purpose: Displays the main application header with navigation and title M3BE data used: 'Manufacturing Order. Open' (PMS100/101) Data services used: Get_ManufacturingOrderFromWC Comment: Displays data when a schedule line is selected |
| Work Center Schedule data grid | Component ID: DataGrid_WorkCenterSchedule
Purpose: Shows the manufacturing work center schedule M3BE data used: 'Work Center Schedule. Open' (PMS230) Data services used: ListMI_WorkCenterScheduele Comment: You must activate the MWOOPE table for search in the M3 Function Search Administration. |
| Bill Of Material data grid | Component ID: DataGrid_BoMStart
Purpose: Displays the bill of material lines M3BE data used: 'Manufact Order. Open Lines' (PMS101) Data services used: List_Materials Comment: n/a |
| Operations data grid | Component ID: DataGrid_OperationsStart
Purpose: Lists operations related to the selected work center schedule M3BE data used: 'Manufact Order. Open Lines' (PMS101) Data services used: List_Operation Comment: n/a |
| Bill Of Material data grid | Component ID: DataGrid_MaterialRequisitions
Purpose: Displays material requisitions related to the bill of materials M3BE data used: 'Manufact Order. Open Lines' (PMS101) Data services used: LISTMI_MaterialsRequisitions Comment: You must activate the MWOMAT table for search in the M3 Function Search Administration. Only the records with issue method 2 are in the list. |
| Report Material chart | Component ID: Chart_ReportedMaterial
Purpose: Visualizes reported materials in a chart M3BE data used: 'Manufact Order. Open Lines' (PMS101) Data services used: Chart_MaterialsRequisitions Comment: You must activate the MWOMAT table for search in the M3 Function Search Administration. |
| Stock Balance data grid | Component ID: DataGrid_StockBalanceReqMtrl
Purpose: Shows stock balance related to material requisitions M3BE data used: 'Balance Identity. Open Toolbox' (MWS068) Data services used: List_StockRequisitions Comment: You must activate the MITBAL and MITLOC tables for search in the M3 Function Search Administration. |
| Pending Material Requests data grid | Pending Material Requests data grid Component ID: DataGrid_PendingMtrReqRequisitions
Purpose: Lists pending material requests M3BE data used: 'Req/Distr Order. Open Line Toolbox' (MWS301) Data services used: LISTMI_PendingMoveRequisition Comment: You must activate the MGLINE table for search in the M3 Function Search Administration. |
| Backflush Material data grid | Component ID: DataGrid_BackflushMaterial
Purpose: Displays backflush materials for reporting M3BE data used: 'Manufact Order. Open Lines' (PMS101) Data services used: LISTMI_MaterialsBackflush Comment: You must activate the MWOMAT table for search in the M3 Function Search Administration. Only records with issue method 3 to 6 are in the list. |
| Report Material chart | Component ID: Chart_ReportedMaterialBackflush
Purpose: Shows backflush reported material in a chart M3BE data used: 'Manufact Order. Open Lines' (PMS101) Data services used: Chart_MaterialsBackflush Comment: You must activate the MWOMAT table for search in the M3 Function Search Administration. |
| Stock Balance data grid | Component ID: DataGrid_StockBackflush
Purpose: Displays stock balances for backflush materials M3BE data used: 'Balance Identity. Open Toolbox' (MWS068) Data services used: List_StockBackflush Comment: You must activate the MITBAL and MITLOC tables for search in the M3 Function Search Administration. |
| Pending Material Requests data grid | Component ID: DataGrid_PendingMtrReqBackflush
Purpose: Displays pending material requests for backflush. M3BE data used: 'Req/Distr Order. Open Line Toolbox' (MWS301) Data services used: LISTMI_PendingMoveBackflush Comment: You must activate the MGLINE table for search in the M3 Function Search Administration. |
| Report Operation form | Component ID: Form_ReportOperation
Purpose: Displays reporting of operations M3BE data used: 'Manufact Order. Open Lines' (PMS101) Data services used: Get_Operation Comment: n/a |
| Reported Quantity chart | Component ID: Chart_ReportOperation
Purpose: Shows reported operations in a chart M3BE data used: 'Manufact Order. Open Lines' (PMS101) Data services used: Get_Operation Comment: n/a |
| Report Receipt form | Component ID: Form_ReportPutAway
Purpose: Handles reporting of manufacturing receipts M3BE data used: 'Manufacturing Order. Open' (PMS100) Data services used: Get_ManufacturingOrderFromWC Comment: n/a |
| Manufacturing Order Receipt chart | Component ID: Chart_MOProgress
Purpose: Shows received manufacturing orders in a chart M3BE data used: 'Manufacturing Order. Open' (PMS100) Data services used: Get_ManufacturingOrderFromWC Comment: n/a |
| TH Operation Reporting MO data grid | Component ID: DataGrid_THOperationReportingMO
Purpose: Lists transaction history for manufacturing operations M3BE data used: 'MO Operation. Display Transactions' (PMS095) Data services used: LISTMI_OperationTransMO Comment: n/a |
Dialogs
| Dialog ID | API program | Purpose |
|---|---|---|
| Dialog_ReportMateriaIssue | PMS060MI/RptIssue | A dialog for reporting material issues. |
| Dialog_ReportOperation | PMS070MI/RptOperation | A dialog for reporting manufacturing operations. |
| Dialog_ReportPutAway | PMS050MI/RptReceipt | A dialog for reporting manufacturing receipts. |
| Dialog_RequestMaterialRequisition | MHS850MI/AddDO | A dialog for requesting material requisitions. |
| Dialog_RequestMaterialBackflush | MHS850MI/AddDO | A dialog for requesting backflush material requisitions. |
Conditional styles
| Component | Condition name | Target field | Condition | Styling |
|---|---|---|---|---|
| Work center schedule data grid | Condition_J1I1R7 | VOSTDT | VOSTDT earlier than today and VOWOST<80 | Icon: alert
Icon color: #DA1217- red Text color: #DA1217- red |
| Work center schedule data grid | Condition_XLYDBQ | VOWOST | VOWOST=40 | Background color: #CBEFDC- light green
Text color: #1C6142- dark green |
| Work center schedule data grid | Condition_J1I1R7 | VOFIDT | VOFIDT earlier than today and VOWOST<80 | Icon: alert
Icon color: #DA1217- red Text color: #DA1217- red |
| Operations data grid | Condition_KXNGQX | FIDT | FIDT earlier than today and WOST!=90 | Icon: alert
Icon color: #DA1217- red Text color: #DA1217- red |
| Operations data grid | Condition_K39JIE | WOST | WOST=90 | Background color: #CBEFDC- light green
Text color: #1C6142- dark green Icon: check Icon color: #1C6142- dark green |
| Work Center Schedule Bill Of Material data grid | Condition_RESFCO | WMST | WMST=99 | Background color: #CBEFDC- light green
Text color: #1C6142- dark green Icon: check Icon color: #1C6142- dark green |
| Report Material Bill of Material data grid | Condition_UL7QHE | VMRPQA | VMWMST<99 | Background color: #BEDCFA- light blue
Text color: #0054B1- dark blue Icon: alert Icon color: #0066D4- blue |
| Report Material Bill of Material data grid | Condition_APIJMT | VMRPQA | VMRPQA>=VMREQA | Background color: #CBEFDC- light green
Text color: #1C6142- dark green Icon: check Icon color: #1C6142- dark green |
| Backflush Monitor Bill of Material data grid | Condition_UVG99D | VMRPQA | VMRPQA | Background color: #CBEFDC- light green
Text color: #1C6142- dark green Icon: check Icon color: #1C6142- dark green |
| Backflush Monitor Bill of Material data grid | Condition_UVG99D | VMRPQA | VMWMST!=99 | Background color: #BEDCFA- light blue
Text color: #0054B1- dark blue Icon: alert Icon color: #0066D4- blue |
| Report Receipt form | Condition_UVG99D | FIDT | FIDT earlier than today and WHST<90 | Background color: #FBE7E8- light red
Text color: #A30D11- dark red |