The Production Order Item Inquiry displays line item detail from Open, Released and Closed Production Order transactions. From this page, users may view and generate an Excel file of Production Order transaction line items. In addition, the inquiry selection can be refined using the Inquiry Criteria fields.

For previous version help page please click here: Production Order Item 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 Units	Identifies the total number of units entered on the Inventory Items tab of all associated Production transactions. This is not required and remains blank until the Record Production button is clicked, a Production transaction is created, and line item units are added to the grid on the Inventory Items tab. This field can be edited by adding or editing the 'Units' field for a line item on the Inventory Items 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 Weight	Identifies the total weight entered on the Inventory Items tab of all associated Production transactions. This is not required remains blank until the Record Production button is clicked, a Production transaction is created, and line item weight is added to the grid on the Inventory Items tab. This field can be edited by adding or editing the 'Weight' field for a line item on the Inventory Items 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.
Completion Pct.	Identifies the percentage complete between the Units and the Actual Units (or Weight and the Actual Weight). This is not required. It is calculated as [Actual Units] / [Units] * 100 or [Actual Weight] / [Weight] * 100, depending on the Production Order transaction's Yield UOM. This field can be edited by adding or editing the 'Units' field or 'Weight' field for a line item 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.
Created	Database Field: ERPx_IMProductionOrderHeader.CreatedDate
Created By	Database Field: ERPx_IMProductionOrderHeader.CreatedBy
End	This can be edited from the 'End' field on the Home tab of the Production Order record view. Database Field: ERPx_IMProductionOrderHeader.ScheduledDateEnd
Item	This can be edited from the 'Item: Description' field on the Inventory Items tab of the Production Order record view. Database Fields: ERPx_IMItem.ItemID, ERPx_IMItem.ItemDescription, ERPx_IMProductionOrderDetail.ItemSK
Line Type	This can be edited from the 'Line Type' field for a line item on the Inventory Items tab of the Production Order record view. Database Field: ERPx_IMProductionOrderDetail.LineItemTypeEN
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
Production Batch	This is not required and can be edited from the 'Production Batch' field on the Inventory Items tab of the Production Order record view. Database Field: ERPx_IMProductionOrderDetail.ProductionBatchID
Site Name	This field comes from from the 'Site Name' 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. Database Field: ERPx_IMProductionOrderHeader.ScheduledDateStart
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 List View 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
Units	Identifies the number of units entered for the line item on the Inventory Items tab of the Production Order transaction. This is not required and can be edited by adding or editing the 'Units' 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.
Units UOM	This field can be edited from the 'Units UOM' field for a line item on the Inventory Items tab of the Production Order record view. Database Fields: ERPx_IMUOM.UOMName, ERPX_IMItem.UOMScheduleSK, ERPx_IMProductionOrderDetail.OrderedUnitsUOMSK
Warehouse Lot	This is not required and can be edited for Warehouse Lot tracked Sites from the 'Warehouse Lot' field on the Inventory Items tab of the Production Order record view. Database Field: ERPx_IMProductionOrderDetail.WarehouseLotID
Weight	Identifies the weight of the line item entered on the Inventory Items tab of the Production Order transaction. This is not required and can be edited by adding or editing the '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.
Weight UOM	This field can be edited from the 'Weight UOM' field for a line item on the Inventory Items tab of the Production Order record view. Database Fields: ERPx_IMUOM.UOMName, ERPX_IMItem.UOMScheduleSK, ERPx_IMProductionOrderDetail.OrderedWeightUOMSK

Production Order Item Inquiry (3.0)

Page Header

Search

Page Detail