The Production Order Inquiry displays Open, Released and Closed Production Order transactions. From this page, users may view and generate an Excel file of historical Production Order transactions. In addition, the inquiry selection can be refined using the Inquiry Criteria fields.
Software Version: 2020.06.05 and newer
...
| Toolbar Icons | Description |
|---|
| Excel | | Insert excerpt |
|---|
| Excel - LV |
|---|
| Excel - LV |
|---|
| nopanel | true |
|---|
|
|
| Grid Layout | | Insert excerpt |
|---|
| Grid Layout - Global |
|---|
| Grid Layout - Global |
|---|
| nopanel | true |
|---|
|
|
| Help | | Insert excerpt |
|---|
| Help - Global |
|---|
| Help - Global |
|---|
| nopanel | true |
|---|
|
|
| Inquiry Criteria | | Insert excerpt |
|---|
| Inquiry Criteria - Global |
|---|
| Inquiry Criteria - Global |
|---|
| nopanel | true |
|---|
|
- Planned Start From: A date picker to specify the 'Planned Start' From date. This defaults to [Current Date] - 30 days. If entered, this must be in a valid date format. A blank assumes all dates.
- Planned Start To: A date picker to specify the 'Planned Start' To date. This defaults to blank. If entered, this must be in a valid date format. A blank assumes all dates.
- Production Order Status: A multi-select standard lookup to specify one or more Statuses. This defaults to "All items checked". Options include: Open, Released and Closed.
- Production Order Site: A multi-select standard lookup to specify one or more Sites. This defaults to "All items checked". Options include list of all the 'Active' Inventory Sites.
|
| Fields | Description |
| Actual Input | | Insert excerpt |
|---|
| Actual Input |
|---|
| Actual Input |
|---|
| nopanel | true |
|---|
|
This field can be edited by adding or editing the 'Units' or 'Weight' field for a line item in the Input tab of the associated Production transaction's record view. Since the user may record production multiple times, there may be more than one Production transaction associated with a Production Order transaction. This is a calculated field and not stored in the database.
|
| Actual Output | | Insert excerpt |
|---|
| Actual Output |
|---|
| Actual Output |
|---|
| nopanel | true |
|---|
|
This field can be edited by adding or editing the 'Units' or 'Weight' field for a line item in the Output tab of the associated Production transaction's record view. Since the user may record production multiple times, there may be more than one Production transaction associated with a Production Order transaction. This is a calculated field and not stored in the database.
Note: Items with a line type of "By-Product" will not be included output and yield calculations. |
| Actual Yield % | | Insert excerpt |
|---|
| Actual Yield Percentage |
|---|
| Actual Yield Percentage |
|---|
| nopanel | true |
|---|
|
This field is expressed as a percentage, calculated as [Actual Output] / [Actual Input] * 100. This field can only be changed by adding or editing the 'Units' or 'Weight' field for a line item in the Input tab or Output tab of the associated Production transaction's record view. This is a calculated field and not stored in the database.
Note: Items with a line type of "By-Product" will not be included output and yield calculations. |
| Created | | Insert excerpt |
|---|
| Created |
|---|
| Created |
|---|
| nopanel | true |
|---|
|
Database Field: ERPx_IMProductionOrderHeader.CreatedDate |
| Created By | | Insert excerpt |
|---|
| Created By |
|---|
| Created By |
|---|
| nopanel | true |
|---|
|
Database Field: ERPx_IMProductionOrderHeader.CreatedBy |
| Output Complete % | | Insert excerpt |
|---|
| Output Complete Percentage |
|---|
| Output Complete Percentage |
|---|
| nopanel | true |
|---|
|
This field is calculated as [Actual Output] / [Planned Output] * 100. This field can only be changed by editing the 'Units' or 'Weight' for a line item in the Output tab of the Production Order transaction's record view or the associated Production transaction's record view. This is a calculated field that is not stored in the database.
|
| Planned End | | Insert excerpt |
|---|
| Planned End Date |
|---|
| Planned End Date |
|---|
| nopanel | true |
|---|
|
This field can be edited from the 'Planned End' field on the Home tab of the Production Order record view.
Database Field: ERPx_IMProductionOrderHeader.ScheduledDateEnd |
| Planned Input | | Insert excerpt |
|---|
| Planned Input |
|---|
| Planned Input |
|---|
| nopanel | true |
|---|
|
This field can only be changed by changing the 'Units' or 'Weight' field for a line item in the Input tab of the Production Order record view. This is a calculated field and not stored in the database.
Note: If the UOM of a line item is not the same as, or does not have a UOM conversion to the UOM in the Production Order header, then the line item will not be included in the input, output and yield calculations. |
| Planned Output | | Insert excerpt |
|---|
| Planned Output |
|---|
| Planned Output |
|---|
| nopanel | true |
|---|
|
This field can only be changed by changing the 'Units' or 'Weight' field for a line item in the Output tab of the Production Order record view. This is a calculated field and not stored in the database.
Note: If the UOM of a line item is not the same as, or does not have a UOM conversion to the UOM in the Production Order header, then the line item will not be included in the input, output and yield calculations. Additionally, items with a line type of "By-Product" will not be included output and yield calculations.
|
| Planned Start | | Insert excerpt |
|---|
| Planned Start Date |
|---|
| Planned Start Date |
|---|
| nopanel | true |
|---|
|
This field can be edited from the 'Planned Start' field on the Home tab of the Production Order record view.
Database Field: ERPx_IMProductionOrderHeader.ScheduledDateStart |
| Planned Yield % | | Insert excerpt |
|---|
| Planned Yield Percentage |
|---|
| Planned Yield Percentage |
|---|
| nopanel | true |
|---|
|
This field is expressed as a percentage and can only be changed by changing the 'Units' or 'Weight' field for a line item in the Input tab or Output tab of the Production Order record view. This is a calculated field and not stored in the database.
Note: If the UOM of a line item is not the same as, and does not have a UOM conversion to, the UOM in the Production Order header, then the line item will not be included in the input, output and yield calculations. Additionally, items with a line type of "By-Product" will not be included output and yield calculations.
|
| Prod. Order | | Insert excerpt |
|---|
| Transaction ID |
|---|
| Transaction ID |
|---|
| nopanel | true |
|---|
|
Clicking on the link opens the Production Order record view for the selected record. This is a system assigned number that comes from the 'Transaction Class' and is never editable.
Database Field: ERPx_IMProductionOrderHeader.ProductionOrderID |
| Site | This field comes from from the 'Site' field on the Home tab of the Production Order record view, but is not editable after the transaction has been Saved. | Insert excerpt |
|---|
| Def - Site |
|---|
| Def - Site |
|---|
| nopanel | true |
|---|
|
Database Fields: ERPx_IMProductionOrderHeader.SiteSK |
| Status | This field can be edited from the 'Status' field on the Home tab of the Production Order record view. | Insert excerpt |
|---|
| Def - Status |
|---|
| Def - Status |
|---|
| nopanel | true |
|---|
|
The Statuses that apply to transactions in this List View include: | Insert excerpt |
|---|
| Def - Status - Open |
|---|
| Def - Status - Open |
|---|
| nopanel | true |
|---|
|
| Insert excerpt |
|---|
| Def - Status - Released |
|---|
| Def - Status - Released |
|---|
| nopanel | true |
|---|
|
| Insert excerpt |
|---|
| Def - Status - Closed |
|---|
| Def - Status - Closed |
|---|
| nopanel | true |
|---|
|
Note: The Status will not have an impact when the Record Production button is clicked (Production transactions created from the Record Production button will always be created as New). Database Field: ERPx_IMProductionOrderHeader.StatusEN |
| Transaction Class | | Insert excerpt |
|---|
| Transaction Class |
|---|
| Transaction Class |
|---|
| nopanel | true |
|---|
|
This field is never editable. | Insert excerpt |
|---|
| Def - Transaction Class |
|---|
| Def - Transaction Class |
|---|
| nopanel | true |
|---|
|
Database Fields: ERPx_IMTransactionClass.TransactionClassID, ERPx_IMProductionOrderHeader.TransactionClassSK |
| UOM | | Insert excerpt |
|---|
| UOM - Production Order |
|---|
| UOM - Production Order |
|---|
| nopanel | true |
|---|
|
This field can be edited from the 'Production Order UOM' field on the Properties tab of the Production Order record view.
| Insert excerpt |
|---|
| Def - UOM |
|---|
| Def - UOM |
|---|
| nopanel | true |
|---|
|
Database Field: ERPx_IMProductionOrderHeader.ProductionOrderUOM |
...