Versions Compared

Key

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

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

Software VersionVersion: 2020.0611.05 13 and newer

Table of Contents
typeflat

Page Header

Search OptionsDescription
Planned Start From

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.

Planned Start ToUsed to select the Planned Start date. All transactions occurring on or before the specified date will be included.  This is a date picker that is not required to return results. It defaults as blank.
Production Order 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.

Production Order Status

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.

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

Insert excerpt
Def - Status - Open
Def - Status - Open
nopaneltrue

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

Insert excerpt
Def - Status - Closed
Def - Status - Closed
nopaneltrue

Saved Search Options
Insert excerpt
Search Options for Framework 3.0 - Global
Search Options for Framework 3.0 - Global
nopaneltrue


Page Detail


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
Grid LayoutFavorites
Insert excerpt
Grid Layout
Favorites Add/Remove - Global
Grid Layout
Favorites Add/Remove - Global
nopaneltrue
HelpGroup By Show/Hide
Insert excerpt
Help
Group By Show/Hide - Global
Help
Group By Show/Hide - Global
nopaneltrue
Inquiry CriteriaHelp
Insert excerpt
Inquiry Criteria
Help - Global 3.0
Inquiry Criteria
Help - Global 3.0
nopaneltrue
  • Planned Start From: A date picker to specify the 'Planned Start' From date. This defaults to [Current Date] - 30 days. If entered, this must be in a valid date format. A blank assumes all dates.
  • Planned Start To: A date picker to specify the 'Planned Start' To date. This defaults to blank. If entered, this must be in a valid date format. A blank assumes all dates.
  • Production Order Status: A multi-select standard lookup to specify one or more Statuses. This defaults to "All items checked". Options include: Open, Released and Closed.
  • Production Order Site: A multi-select standard lookup to specify one or more Sites. This defaults to "All items checked". Options include list of all the 'Active' Inventory Sites.
    Quick Filter
    Insert excerpt
    Quick Filter
    Quick Filter
    nopaneltrue
    Refresh
    Insert excerpt
    Refresh - Global 3.0
    Refresh - Global 3.0
    nopaneltrue
    Saved Column Layouts
    Insert excerpt
    Column Layouts for Framework 3.0 - Global
    Column Layouts for Framework 3.0 - Global
    nopaneltrue
    FieldsDescription
    Actual Input

    Insert excerpt
    Actual Input
    Actual Input
    nopaneltrue
     This field can be edited by adding or editing the 'Units' or 'Weight' field for a line item in the Input 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 Output

    Insert excerpt
    Actual Output
    Actual Output
    nopaneltrue
      This field can be edited by adding or editing the 'Units' or 'Weight' field for a line item in the Output 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.

    Note: Items with a line type of "By-Product" will not be included output and yield calculations.

    Actual Yield %

    Insert excerpt
    Actual Yield Percentage
    Actual Yield Percentage
    nopaneltrue
    This field is expressed as a percentage, calculated as [Actual Output] / [Actual Input] * 100. This field can only be changed by adding or editing the 'Units' or 'Weight' field for a line item in the Input tab or Output tab of the associated Production transaction's record view. This is a calculated field and not stored in the database.

    Note: Items with a line type of "By-Product" will not be included output and yield calculations.

    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

    Output Complete %

    Insert excerpt
    Output Complete Percentage
    Output Complete Percentage
    nopaneltrue
    This field is calculated as [Actual Output] / [Planned Output] * 100. This field can only be changed by editing the 'Units' or 'Weight' for a line item in the Output 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.

    Planned End

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

    Database Field: ERPx_IMProductionOrderHeader.ScheduledDateEnd

    Planned Input

    Insert excerpt
    Planned Input
    Planned Input
    nopaneltrue
     This field can only be changed by changing the 'Units' or 'Weight' field for a line item in the Input tab of the Production Order record view. This is a calculated field and not stored in the database.

    Note: If the UOM of a line item is not the same as, or does not have a UOM conversion to the UOM in the Production Order header, then the line item will not be included in the input, output and yield calculations.

    Planned Output

    Insert excerpt
    Planned Output
    Planned Output
    nopaneltrue
     This field can only be changed by changing the 'Units' or 'Weight' field for a line item in the Output tab of the Production Order record view. This is a calculated field and not stored in the database.

    Note: If the UOM of a line item is not the same as, or does not have a UOM conversion to the UOM in the Production Order header, then the line item will not be included in the input, output and yield calculations. Additionally, items with a line type of "By-Product" will not be included output and yield calculations.

    Planned Start

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

    Database Field: ERPx_IMProductionOrderHeader.ScheduledDateStart

    Planned Yield %

    Insert excerpt
    Planned Yield Percentage
    Planned Yield Percentage
    nopaneltrue
     This field is expressed as a percentage and can only be changed by changing the 'Units' or 'Weight' field for a line item in the Input tab or Output tab of the Production Order record view. This is a calculated field and not stored in the database.

    Note: If the UOM of a line item is not the same as, and does not have a UOM conversion to, the UOM in the Production Order header, then the line item will not be included in the input, output and yield calculations. Additionally, items with a line type of "By-Product" will not be included output and yield calculations.

    Prod. Order

    Insert excerpt
    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.

    Database Field: ERPx_IMProductionOrderHeader.ProductionOrderID

    Site

    Insert excerpt
    site
    site
    nopaneltrue
     This field comes from from the 'Site' 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
    Def - Site
    nopaneltrue

    Database Fields: ERPx_IMProductionOrderHeader.SiteSK

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

    Insert excerpt
    Def - Status - Open
    Def - Status - Open
    nopaneltrue

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

    Insert excerpt
    Def - Status - Closed
    Def - 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.StatusEN

    Transaction Class

    Insert excerpt
    Transaction Class
    Transaction Class
    nopaneltrue
    This field is never editable.

    Insert excerpt
    Def - Transaction Class
    Def - Transaction Class
    nopaneltrue

    Database Fields: ERPx_IMTransactionClass.TransactionClassID, ERPx_IMProductionOrderHeader.TransactionClassSK

    UOM

    Insert excerpt
    UOM - Production Order
    UOM - Production Order
    nopaneltrue
    This field can be edited from the 'Production Order UOM' field on the Properties tab of the Production Order record view.

    Insert excerpt
    Def - UOM
    Def - UOM
    nopaneltrue

    Database Field: ERPx_IMProductionOrderHeader.ProductionOrderUOM


    ...