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: YYYY2020.MM06.DD 05 and newer

Table of Contents

type	flat

Page Header

Toolbar Icons

Description

Excel

Insert excerpt

	Excel - LV
	Excel - LV
nopanel	true

Grid Layout

Insert excerpt

	Grid Layout - Global
	Grid Layout - Global
nopanel	true

Help

Insert excerpt

	Help - Global
	Help - Global
nopanel	true

Inquiry Criteria

Insert excerpt

	Inquiry Criteria - Global
	Inquiry Criteria - Global
nopanel	true

Search: A text box that to specify a Production Order ID. This defaults as blank.
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.

Fields

Description

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

Actual 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 'Weight' 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). 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
nopanel	true

Database Field: ERPx_IMProductionOrderHeader.CreatedDate

Created By

Insert excerpt

	Created By
	Created By
nopanel	true

Database Field: ERPx_IMProductionOrderHeader.CreatedBy

Item

Insert excerpt

	Item ID & Item Description
	Item ID & Item Description
nopanel	true

This can be edited from the 'Item: Description' field on the Input tab or Output tab of the Production Order record view.

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

Line Type

Insert excerpt

	Line Type
	Line Type
nopanel	true

This 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.LineItemTypeEN

Planned End

Insert excerpt

	Planned End Date
	Planned End Date
nopanel	true

This can be edited 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 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 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
nopanel	true

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

	Transaction ID
	Transaction ID
nopanel	true

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

Database Field: ERPx_IMProductionOrderHeader.ProductionOrderID

Site

Insert excerpt

	site
	site
nopanel	true

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

Database Fields: ERPx_IMProductionOrderHeader.SiteSK

Status

Insert excerpt

	Status
	Status
nopanel	true

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

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

Insert excerpt

	Def - Status - Open
	Def - Status - Open
nopanel	true

Insert excerpt

	Def - Status - Released
	Def - Status - Released
nopanel	true

Insert excerpt

	Def - Status - Closed
	Def - Status - Closed
nopanel	true

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 - Units
	UOM - Units
nopanel	true

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 - Weight
	UOM - Weight
nopanel	true

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

Version	Old Version 9	New Version 10
Changes made by	Tom Williams	Emma Greenwood
Saved on	Jun 05, 2020	Jun 05, 2020

Versions Compared

Key

Page Header

Related Topics

Page Comparison

Versions Compared

Key

Page Header

Related Topics