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 itemsIn addition, the inquiry selection can be refined using the Inquiry Criteria fields. 

Software Version: 2024.XX.XX and newer

Page Header

Search 

Search OptionsDescription
Include

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:

Need new one for Recurring

Need new one for Scheduled

Saved Searches
Search

 

  • Attribute Values
  • Item Description
  • Item ID
  • Lot Owner
  • Production Batch
  • Site ID
  • Site Name
  • Warehouse Lot 
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 DateUsed 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 IconsDescription
Column Filter Show/Hide
Excel
Favorites
Group By Show/Hide
Help
Quick Column Filter
Refresh
Saved Layouts
Search Options

FieldsDescription
Actual Units

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.

Actual Weight

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.

Complete

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 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

Planned 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.

Planned 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.

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 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:

Need new one for Recurring

Need new one for Scheduled

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 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

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


Related Topics



Page Definitions



Technical Details