Versions Compared

Version Old Version 3 New Version Current
Changes made by

Emma Greenwood

Emma Greenwood

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

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.XX.XX and newer

Table of Contents
typeflat

Page Header

...

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 

...

The lookup contains a list of all active Sites.

...

Page Detail

...

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
typeflat

Page Header

Search OptionsDescription
Include

Insert excerpt
Inq - Include
Inq - Include
nopaneltrue

  • 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

Insert excerpt
Inq - Transaction Class
Inq - Transaction Class
nopaneltrue
 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
Insert excerpt
Search Options for Framework 3.0 - Global
Search Options for Framework 3.0 - Global
nopaneltrue
Search

Insert excerpt
Search - Search Options
Search - Search Options
nopaneltrue
 

    • Production Order: [Transaction]
    • Production Name
Site

Insert excerpt
Inq - Site
Inq - Site
nopaneltrue
This is a multi-select standard lookup that is required to return results. It defaults to all Sites.

Insert excerpt
Def - Site
Def - Site
nopaneltrue

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


 This can be edited from the 'End' field on the Home tab of the Production Order record view.
Toolbar IconsDescription
Column Filter Show/Hide
Insert excerpt
Column Filter Show/Hide - Global
Column Filter Show/Hide - Global
nopaneltrue
Excel
Insert excerpt
Excel - LV 3.0
Excel - LV 3.0
nopaneltrue
Favorites
Insert excerpt
Favorites Add/Remove - Global
Favorites Add/Remove - Global
nopaneltrue
Group By Show/Hide
Insert excerpt
Group By Show/Hide - Global
Group By Show/Hide - Global
nopaneltrue
Help
Insert excerpt
Help - Global 3.0
Help - Global 3.0
nopaneltrue
Quick Column Filter
Insert excerpt
Quick Column Filter
Quick Column Filter
nopaneltrue
Refresh
Insert excerpt
Refresh - Global 3.0
Refresh - Global 3.0
nopaneltrue
Saved Layouts
Insert excerpt
Column Layouts for Framework 3.0 - Global
Column Layouts for Framework 3.0 - Global
nopaneltrue
Search Options

Insert excerpt
Search Options - Inquiry Grid 3.0
Search Options - Inquiry Grid 3.0
nopaneltrue

FieldsDescription
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 units are weight is added to the grid on the Inventory Items tab.  This This field can be edited by adding or editing the 'UnitsWeight' 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 tabfield 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 of the associated Production transactionOrder 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 or the associated Production transaction's record view.

This is a calculated field that is not stored in the database.

Created

Insert excerpt
Created
Created
nopaneltrue

Database Field: ERPx_IMProductionOrderHeader.CreatedDate

Created By

Insert excerpt
Created By
Created By
nopaneltrue

Database Field: ERPx_IMProductionOrderHeader.CreatedBy

End

Insert excerpt
Planned End Date
Planned End Date
nopaneltrue
 This can be edited from the 'End' field on the Home tab of the Production Order record view.

Database Field: ERPx_IMProductionOrderHeader.ScheduledDateEnd

Item

Insert excerpt
Item ID & Item Description
Item ID & Item Description
nopaneltrue
This can be edited from the 'Item: Description' field 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 Fields: ERPx_IMItem.ItemID, ERPx_IMItem.ItemDescription, ERPx_IMProductionOrderDetail.ItemSK

Line Type

Insert excerpt
Created
Line Type
Created
Line Type
nopaneltrue
 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_IMProductionOrderHeaderIMProductionOrderDetail.CreatedDateLineItemTypeEN

Created ByOrder

Insert excerpt
Planned End DatePlanned End Date
nopaneltrue
Insert excerpt

Created ByCreated Bynopaneltrue

Database Field: ERPx_IMProductionOrderHeader.CreatedBy

End

Transaction ID
Transaction ID
nopaneltrue
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.

Insert excerpt
Def - Transaction ID
Def - Transaction ID
nopaneltrue

Database Field: ERPx_IMProductionOrderHeader.ScheduledDateEndProductionOrderID

ItemProduction Batch

Item ID & Item Description

Insert excerpt
Item ID & Item Description
Production Batch
Production Batch
nopaneltrue
 This  This is not required and can be edited from the 'Item: DescriptionProduction Batch' field on the the Inventory Items tab of the Production Order record view.

Database Fields: ERPx_IMItem.ItemID, ERPx_IMItem.ItemDescription, ERPx_IMProductionOrderDetail.ItemSK

Line Type

Line Type

Insert excerpt
Line Type
Def - Production Batch
Def - Production Batch
nopaneltrue
 This can be edited from the 'Line Type' field for a line item on the Inventory Items tab of the Production Order record view.

Insert excerpt
Def - Inventory Lot
Def - Inventory Lot
nopaneltrue

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 ProductionBatchID

Site NameProd. Order

Insert excerpt
Site Name
Site Name
nopaneltrue
This field comes from from the 'Site Name' field on the Home 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.

Insert excerptTransaction IDTransaction IDnopaneltrueClicking 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., but is not editable after the transaction has been Saved.

Insert excerpt
Def - Site
Def - Site
nopaneltrue

Database Fields: ERPx_IMProductionOrderHeader.SiteSK

Start

Insert excerpt
Planned Start Date
Planned Start Date
nopaneltrue
 This can be edited from the 'Start' field on the Home tab of the Production Order record view.

Database Field: ERPx_IMProductionOrderHeader.ScheduledDateStart

Status

Insert excerpt
Status
Status
nopaneltrue
This field can be edited from the 'Status' field on the Home tab of the Production Order record view. 

Insert excerpt
Def - Status
Def - Status
nopaneltrue
The Statuses that apply to transactions in this List View include:

Insert excerpt
Def - Status - Recurring
Def - Status - Recurring
nopaneltrue

Insert excerpt
Def - Status - New
Def - Status - New
nopaneltrue

Insert excerpt
Def -
Transaction ID
Status - Scheduled
Def -
Transaction ID
Status - Scheduled
nopaneltrue

Database Field: ERPx_IMProductionOrderHeader.ProductionOrderID

Site Name

Insert excerpt
Def - Status - Released
Def - Status - Released
nopaneltrue

Insert excerpt
Site NameSite NameDef - Status - In Process (Inventory)
Def - Status - In Process (Inventory)
nopaneltrue
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.

Insert excerpt
Def -
Site
Status - Closed
Def -
SitenopaneltrueDatabase Fields
Status - Closed
nopaneltrue

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

Start Insert excerptPlanned Start DatePlanned Start Datenopaneltrue This can be edited from the 'Start' field on the Home tab of the Production Order record view.

Database Field: ERPx_IMProductionOrderHeader.ScheduledDateStart

Status Insert excerptStatusStatusnopaneltrue This field can be edited from the 'Status' field on the Home tab of 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.

  Insert excerptDef - StatusDef - Statusnopaneltrue The Statuses that apply to transactions in this List View include: Insert excerptDef - Status - RecurringDef - Status - Recurringnopaneltrue

This is a calculated field and not stored in the database.

Units UOM

Insert excerpt
Def
UOM -
Status - New
Units
Def
UOM -
Status - New
Units
nopaneltrue
 Insert excerptDef - Status - ScheduledDef - Status - Schedulednopaneltrue 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

Def - Status - Released

Insert excerpt
Def - Status - Released
Warehouse Lot
Warehouse Lot
nopaneltrue
 Insert excerptDef - Status - In Process (Inventory)Def - Status - In Process (Inventory)nopaneltrue 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. 

Insert excerpt
Def -
Status - Closed
Warehouse Lot
Def -
Status - Closed
Warehouse Lot
nopaneltrue

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

Insert excerpt
UOM
Def -
Units
Inventory Lot
UOM
Def -
Units
Inventory Lot
nopaneltrue
 This field can be edited from the 'Units UOM

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

 of the Production Order record view.

Database Fields: ERPx_IMUOM.UOMName, ERPX_IMItem.UOMScheduleSK, ERPx_IMProductionOrderDetail.OrderedUnitsUOMSK

This is a calculated field and not stored in the database.

Weight UOM

Insert excerpt
UOM - Weight
UOM - Weight
nopaneltrue
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

...