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.

...

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
 

  • Attribute Values
  • Item Description
  • Item ID
  • Lot Owner
  • Production Batch
  • Site ID
  • Site Name
    • Warehouse Lot 

      • 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


    Identifies the total number of units entered on the Inventory Items tab  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 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

    		Saved Layouts
    Insert excerpt
    Column Layouts for Framework 3.0 - GlobalColumn Layouts for Framework 3.0 - Global
    nopaneltrue
    Search Options
    Insert excerpt
    Search Options - Inquiry Grid 3.0Search Options - Inquiry Grid 3.0
    nopaneltrue
    FieldsDescription
    Actual UnitsFieldsDescription
    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   This is not required and 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

    ...