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.
Software Version: 2024.XX.XX and newer
| Table of Contents | ||
|---|---|---|
|
Page Header
Search
...
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.
...
The lookup contains a list of all active Sites.
...
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.
...
- Attribute Values
- Item Description
- Item ID
- Lot Owner
- Production Batch
- Site ID
- Site Name
- Warehouse Lot
...
Page Detail
...
Identifies the total number of units entered on the Inputs tab or Outputs 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 in the Inputs tab or Outputs tab. This field can be edited by adding or editing the 'Units' field for a line item on the Inputs tab or Outputs 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.
...
Identifies the total weight entered on the Inputs tab or Outputs 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 in the Inputs tab or Outputs tab. This field can be edited by adding or editing the 'Weight' field for a line item on the Inputs tab or Outputs 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.
...
Identifies the percentage complete between the Planned Units and the Actual Units (or Planned Weight and the Actual Weight). This is not required. It is calculated as [Actual Units] / [Planned Units] * 100 or [Actual Weight] / [Planned 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 Inputs tab or Outputs 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.
...
Database Field: ERPx_IMProductionOrderHeader.CreatedDate
...
Database Field: ERPx_IMProductionOrderHeader.CreatedBy
...
Database Fields: ERPx_IMItem.ItemID, ERPx_IMItem.ItemDescription, ERPx_IMProductionOrderDetail.ItemSK
...
Database Field: ERPx_IMProductionOrderDetail.LineItemTypeEN
...
Database Field: ERPx_IMProductionOrderHeader.ScheduledDateEnd
...
Identifies the number of units entered for the line item on the Inputs tab or Outputs 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 Inputs tab or Outputs tab of the Production Order record view.
This is a calculated field and not stored in the database.
...
Identifies the weight of the line item entered on the Input tab or Output 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 Input tab or Output tab of the Production Order record view.
This is a calculated field and not stored in the database.
...
Database Field: ERPx_IMProductionOrderHeader.ScheduledDateStart
...
Database Field: ERPx_IMProductionOrderHeader.ProductionOrderID
...
Database Fields: ERPx_IMProductionOrderHeader.SiteSK
...
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
...
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
| Table of Contents | ||
|---|---|---|
|
Page Header
Search
| Search Options | Description | ||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Include |
This is a multi-select standard lookup that is required to return results. It defaults to 'Closed'. | ||||||||||||||||
| Order Class |
The lookup contains a list of all the active Transaction Classes for Production Orders. | ||||||||||||||||
| Saved Searches |
| ||||||||||||||||
| Search |
| ||||||||||||||||
| Site |
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 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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 |
Database Field: ERPx_IMProductionOrderHeader.ScheduledDateEnd | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| Item |
Database Fields: ERPx_IMItem.ItemID, ERPx_IMItem.ItemDescription, ERPx_IMProductionOrderDetail.ItemSK | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| Line Type |
Database Field: ERPx_IMProductionOrderDetail.LineItemTypeEN | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| Order |
Database Field: ERPx_IMProductionOrderHeader.ProductionOrderID | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| Production Batch |
Database Field: ERPx_IMProductionOrderDetail.ProductionBatchID | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| Site Name |
Database Fields: ERPx_IMProductionOrderHeader.SiteSK | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| Start |
Database Field: ERPx_IMProductionOrderHeader.ScheduledDateStart | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| Status |
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 |
Database Fields: ERPx_IMUOM.UOMName, ERPX_IMItem.UOMScheduleSK, ERPx_IMProductionOrderDetail.OrderedUnitsUOMSK | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| Warehouse Lot |
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 ofof the Production Order record view. Database Fields: ERPx_IMUOM.UOMName, ERPX_IMItem.UOMScheduleSK, ERPx_IMProductionOrderDetail.OrderedUnitsUOMSKThis is a calculated field and not stored in the database. | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| Weight UOM |
Database Fields: ERPx_IMUOM.UOMName, ERPX_IMItem.UOMScheduleSK, ERPx_IMProductionOrderDetail.OrderedWeightUOMSK |
Related Topics
...