Versions Compared

Version Old Version 2 New Version Current
Changes made by

Janice Dannenberg (Unlicensed)

Janice Dannenberg (Unlicensed)

Saved on

Key

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

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

Software Version: YYYY.MM.DD and newer

Table of Contents
typeflat

Page Header

...

  • Search: A text box that to specify a Production Order ID. This defaults as blank.
  • Production Order Start Date From / Through: A date picker to specify the 'Planned Start' date field. This defaults to [Current Date] - 1 month. If entered, this must be in a valid date format. A blank assumes all dates.
  • Production Order End Date From / Through: A date picker to specify the 'Planned End' date field. 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.

...

Identifies the total number of units entered on the Input tab and Output tab of all associated Production transactions. This field 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 Input tab or Output tab. This field can be edited by adding or editing the 'Units' field for a line item on the Input tab or 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.

...

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

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 
Saved Searches
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
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 Input tab or Output 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

weight is

units are added to the grid in the Input tab or Output tab. This field can be edited by adding or editing the '

Weight

Units' field for a line item on the Input tab or 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.

Complete

Identifies the percentage complete between the Planned Units and the Actual Units (or Planned Weight and the Actual Weight). It is calculated as [Actual Units] / [Planned Units] * 100 or [
Actual
Weight] / [Planned Weight] * 100, depending on the Production Order transaction's UOM
Weight

Identifies the total weight entered on the Input tab or Output 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 Input tab or Output tab. This field can be edited by adding or editing the

'Units' field or

'Weight' field for a line item on the Input tab or Output tab of the associated Production

Order transaction

transaction's record view

or 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

that is

and not stored in

the database.Created Insert excerptCreatedCreatednopaneltrue

Database Field: ERPx_IMProductionOrderHeader.CreatedDate

Created By Insert excerptCreated ByCreated Bynopaneltrue

Database Field: ERPx_IMProductionOrderHeader.CreatedBy

Item Insert excerptItemItemnopaneltrue This field can be edited from the 'Item: Description' field

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 UOM. This field can be edited by adding or editing the 'Units' field or 'Weight' field for a line item on the Input tab or 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.

Created

Insert excerpt
Created
Created
nopaneltrue

Database

Fields

Field: ERPx_

IMItem.ItemID, ERPx_IMItem.ItemDescription, ERPx_IMProductionOrderDetail.ItemSKLine TypeLine Type

IMProductionOrderHeader.CreatedDate

Created By

Insert excerpt

Line Type

Created By
Created By
nopaneltrue

This field can be edited from the 'Line Type' field for a line item on the Input tab or Output tab of the Production Order record view.


Database Field: ERPx_

IMProductionOrderDetail

IMProductionOrderHeader.

LineItemTypeEN

CreatedBy

Planned EndPlanned End Date
Item

Insert excerpt

Planned End Date

Item ID & Item Description
Item ID & Item Description
nopaneltrue

 This field

This can be edited from the '

Planned End

Item: Description' field on the

Home

Input tab or Output tab of the Production Order record view.

Database

Field:

Fields: ERPx_IMItem.ItemID, ERPx_IMItem.ItemDescription, ERPx_

IMProductionOrderHeader

IMProductionOrderDetail.

ScheduledDateEnd

ItemSK

Planned UnitsPlanned Input
Line Type

Insert excerpt

Planned Input

Line Type
Line Type
nopaneltrue

 This field

This can be edited

by adding or editing

from the '

Units

Line Type' field for a line item on the Input

tab

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.

Planned Weight

.

Database Field: ERPx_IMProductionOrderDetail.LineItemTypeEN

Planned End

Insert excerpt
Planned

Output

End Date
Planned

Output

End Date
nopaneltrue
 This

field

can be edited

by adding or editing the 'Weight' field for a

from the 'Planned End' field on the Home tab of the Production Order record view.

Database Field: ERPx_IMProductionOrderHeader.ScheduledDateEnd

Planned Units

Identifies the number of units entered for the line item on the Input tab or

Output

Output tab of the Production Order

record view

transaction.

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.

Planned Start Insert excerptPlanned Start DatePlanned Start Datenopaneltrue 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

Prod. Order 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. Insert excerptDef - Transaction IDDef - Transaction IDnopaneltrue

 This is not required and can be edited by adding or editing the 'Units' 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.

Planned Weight

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.

Planned Start

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

Database Field: ERPx_IMProductionOrderHeader.

ProductionOrderID

ScheduledDateStart

Site
Prod. Order

Insert excerpt

sitesitenopaneltrue This field can be edited from the 'Site' field on the Home tab of

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 -

Site

Transaction ID
Def -

Site

Transaction ID
nopaneltrue

Database

Fields

Field: ERPx_IMProductionOrderHeader.

SiteSK

ProductionOrderID

Status
Site

Insert excerpt

Status

site

Status

site
nopaneltrue
This field comes from from the '

Status

Site' field on the Home tab of the Production Order record view

. This field is always editable

, but is not editable after the transaction has been Saved.

Insert excerpt
Def -

Status

Site
Def -

Status

Site
nopaneltrue

The Statuses that apply to transactions in this List View include:

Open: This is the default Status for all new Production Order transactions. While in the Status of 'Open', all editable fields are open for edit.

Released: Users may set this status when the Production Order transaction is ready to be released to production. While in the Status of 'Released', all editable fields are open for edit.

Closed: Users may set this status once the associated Production transaction has been set to a status of "Ready to Post". Else, the message "Production Order [Prod Order ID] can not be closed because Production Transaction(s) [List of Production Transaction IDs] are not posted." will be displayed on Save.

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

Units UOM

Insert excerpt
UOM

Identifies the unit of measure that the units are stored in (boxes, Bags, Cases, Totes, etc.) for a line item. This

- Units
UOM - Units
nopaneltrue
 This field can be edited from the 'Units UOM' field for a line item on the Input tab or Output tab of the Production Order record view.

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

Weight UOM

Insert excerpt
UOM

Identifies the unit of measure that the weight is stored in (Lbs, Kg, Oz, Ton, etc.) for the line item.

- Weight
UOM - Weight
nopaneltrue
This field can be edited from the 'Weight UOM' field for a line item on the Input tab or Output tab of the Production Order record view.

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


Related Topics



Expand
titlePage Definitions

Page Definitions



Expand
titleTechnical Details

Technical Details