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.

For previous version help page please click here: Production Order Inquiry

Software Version: 2024.03.29 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
Include	Open - this includes statuses 'New', 'Released', 'Scheduled', and 'In Process'. Recurring Closed This is a multi-select standard lookup that is required to return results. It defaults to 'Closed'.
Order Class	This is a multi-select standard lookup that is required to return results. It defaults to all production order classes. The lookup contains a list of all the active Transaction Classes for Production Orders.
Saved Searches
Search	Production Order: [Transaction] Production Name
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.
Start Date	Used to select the Start date of the Production Order. All transactions occurring on or after the specified date will be included. This is a date range picker that is not required to return results. It defaults to one month prior to the current date.

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.
Actual Yield Pct.	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 Inventory Items tab of the associated Production transaction's record view. This is a calculated field and not stored in the database.
Created	Database Field: ERPx_IMProductionOrderHeader.CreatedDate
Created By	Database Field: ERPx_IMProductionOrderHeader.CreatedBy
Completion Pct.	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 with a line type of Output on the Inventory Items 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.
End	This field can be edited from the 'End' field on the Home tab of the Production Order record view. Database Field: ERPx_IMProductionOrderHeader.ScheduledDateEnd
End Time	Displays the time the Production ended. This field can be edited from the 'End Time' property on the Properties tab of the Production Order Record View. Database Field: ERPx_IMProductionOrderHeader.EndTime
Last Updated
Last Updated By
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'. It is required and can never be edited. Database Field: ERPx_IMProductionOrderHeader.ProductionOrderID
Planned Input	This field can only be changed by changing the 'Units' or 'Weight' field for a line item with a line type of Input on the Inventory Items 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 with a line type of Output on the Inventory Items 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 Yield Pct.	This field is expressed as a percentage and can only be changed by changing the 'Units' or 'Weight' field for a line item on the Inventory Items 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.
Production Name	Identifies the name of the Production plan, for example this could be a particular day and shift. This field can be edited from the 'Production Name' field on the Home Tab of the Production Order Record View. Database Field: ERPx_IMProductionOrderHeader.ProductionName
Production Order Class	This is never editable. Database Fields: ERPx_IMTransactionClass.TransactionClassID, ERPx_IMProductionOrderHeader.TransactionClassSK
Reference	This field can be edited from the 'Reference' field on the Home Tab of the Production Order Record View. Database Field: ERPx_IMProductionOrderHeader.Reference
Site Name	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
Start	This can be edited from the 'Start' field on the Home tab of the Production Order Record View. Note: This is not editable when the transaction is in a status of 'In Process' or 'Closed'. Database Field: ERPx_IMProductionOrderHeader.ScheduledDateStart
Start Time	Displays the time the Production began. This can be edited from the 'Start Time' property on the Properties tab of the Production Order Record View. Database Field: ERPx_IMProductionOrderHeader.StartTime
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: Production Orders in a status of 'Recurring' cannot be used to record Production. Production transactions created from the Record Production button will always be created in a status of 'New'. Database Field: ERPx_IMProductionOrderHeader.StatusEN
Yield UOM	This field comes from the 'Yield UOM' field on the Home tab of the Production Order Record View and . Database Field: ERPx_IMProductionOrderHeader.ProductionOrderUOM

Production Order Inquiry (3.0)

Page Header

Search

Page Detail