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: 2021.05.21 and newer

[ 1 Page Header ] [ 1.1 Search ] [ 2 Page Detail ] [ 2.1 Related Topics ] [ 2.1.1 Page Definitions ] [ 2.1.2 Technical Details ]

Page Header

Search

Search Options	Description

Search Options	Description
Planned Start From	Used to select the Planned Start date. All transactions occurring on or after the specified date will be included. This is a date picker that is not required to return results. It defaults to one month prior to the current date.
Planned Start To	Used to select the Planned Start date. All transactions occurring on or before the specified date will be included. This is a date picker that is not required to return results. It defaults as blank.
Production Order Site	This is a multi-select standard lookup that is required to return results. It defaults to all Sites. The lookup contains a list of all active Sites.
Production Order Status	Used to select one or more Statuses. This is a multi-select standard lookup that is required to return results. It defaults to all Statuses. The Statuses that apply to transactions in this Inquiry include:
Saved Searches

Page Detail

Toolbar Icons	Description

Toolbar Icons	Description
Column Filter Show/Hide
Excel
Favorites
Group By Show/Hide
Help
Quick Column Filter
Refresh
Saved Layouts
Search Options
Fields	Description
Actual Input	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	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 %	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	Database Field: ERPx_IMProductionOrderHeader.CreatedDate
Created By	Database Field: ERPx_IMProductionOrderHeader.CreatedBy
Output Complete %	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	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	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	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	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 %	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	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. 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. The Statuses that apply to transactions in this Inquiry include: 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	This field is never editable. Database Fields: ERPx_IMTransactionClass.TransactionClassID, ERPx_IMProductionOrderHeader.TransactionClassSK
UOM	This field can be edited from the 'Production Order UOM' field on the Properties tab of the Production Order record view. Database Field: ERPx_IMProductionOrderHeader.ProductionOrderUOM