Versions Compared

Key

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

Production Orders are used to issue specific quantity of inputs and/or output quantities of inventory items within a certain time frame. These allow multiple production items to be associated to Production Orders. This page will display input, output and yield percentages and allow users to view/record actuals against the plan. Inventory is not affected when the plan is entered, only when actuals are recorded.

To view the help page for the NorthScope 2.0 Production Order Record View, please click here: Production Order Record View

Software Version: 2024.03.29 and newer

...

Page Header

Header Toolbar

Toolbar IconsDescription
Delete
Insert excerpt
Delete - RV Header 3.0
Delete - RV Header 3.0
nopaneltrue
(lightbulb) If the selected Production Order transaction(s) have associated Production transactions, then the user will be unable to delete the Production Order transaction(s).
Help
Insert excerpt
Help - Global 3.0
Help - Global 3.0
nopaneltrue
More Actions

Insert excerpt
More Actions - Global 3.0
More Actions - Global 3.0
nopaneltrue

  • LV: Item Balances: Opens the Item Balances Inquiry
  • LV: Lot Balances: Opens the Lot Balances Inquiry
  • Record Production: Saves the Production Order and opens the newly created Production transaction from the transaction class specified in the 'Related Production Transaction Class' on the Production Order Transaction Class record view.  The newly created Production transaction will include all lines from the Production Order's Input and Output tabs. The quantities (Units and Weight) on the Production transaction will be defaulted as "0.00".

(lightbulb) This button is disabled when the Status is 'Closed'.

New

Insert excerpt
New - Multi-Select Trans Type - Global 3.0
New - Multi-Select Trans Type - Global 3.0
nopaneltrue
The drop-down displays all active Production Order type transaction classes configured in the system. Selecting a transaction class, opens a new blank transaction record for data entry. 

Notes

Insert excerpt
Notes - Global 3.0
Notes - Global 3.0
nopaneltrue
Three Note Types (Internal, Production Instructions and Attachment) will be displayed for Production Order transactions.

Production Order Note Types will not be copied onto a Production transaction when a transaction is created from a Production Order.

Print 
Insert excerpt
Print - LV 3.0
Print - LV 3.0
nopaneltrue
Save

Insert excerpt
Save - RV Header
Save - RV Header
nopaneltrue
 For a new Production Order, clicking Save will also assign the Production Order ID, by combining the 'Document Prefix' with the 'Next Document Number' from the Production Order transaction class. The 'Next Document Number' field will be incremented by one.

Save & Close
Insert excerpt
Save & Close - RV Header 3.0
Save & Close - RV Header 3.0
nopaneltrue

Home Tab 

FieldsDescription
Actual Input

Insert excerpt
Actual Input
Actual Input
nopaneltrue
 This is a non-editable text box that is not required and defaults as "0.00". This field remains blank until the Record Production button is clicked, a Production transaction is created, and line item(s) are added to the grid of the Inventory Items tab with a Line Type of Input. This field is only editable by adding or editing the 'Units' field or 'Weight' field for an Input line item on the Inventory Items tab of the associated Production transaction. 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 is a non-editable text box that is not required and defaults as "0.00". This field remains blank until the Record Production button is clicked, a Production transaction is created, and line item(s) are added to the grid of the Inventory Items tab with a Line Type of Output. This field is only editable by adding or editing the 'Units' field or 'Weight' field for an Output line item on the Inventory Items tab of the associated Production transaction. 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 Yield Pct.

Insert excerpt
Actual Yield Percentage
Actual Yield Percentage
nopaneltrue
This is a non-editable text box that is not required and defaults as "0.00". This field remains blank until the Record Production button is clicked, a Production transaction is created, and line item(s) are added to the grid that are set to 'Include in Yield' on the Inventory Items tab. This field is calculated as [Actual Output] / [Actual Input] * 100. This field is only editable by adding or editing the 'Units' field or 'Weight' field for a line item on the Inventory Items tab that are set to Include in Yield on the associated Production transaction. 

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

Allow Inv. Subs.

Identifies whether non-Production Order Inventory line items can be manually added to a Production transaction associated with the corresponding Production Order. This is a single-select standard lookup that is required. It defaults from the 'Allow Substitutes' field on the Production Order Transaction Class record view. This field is editable until the transaction is in a status of 'In Process' or 'Closed'.  

The lookup contains all the values in the IMProductionOrderAllowSubstitutes Enumeration Class. 

Database Field: ERPx_IMProductionOrderHeader.AllowSubstitutesEN

Completion Pct.

Insert excerpt
Output Complete Percentage
Output Complete Percentage
nopaneltrue
This is a non-editable text box that is not required. It defaults as "0.00"and is calculated as [Actual Output] / [Planned Output] * 100 formatted to 2 decimals. This field is only editable by adding or editing the 'Units' field or 'Weight' field for an Output line item on the Inventory Items tab of the Production Order transaction or the associated Production transaction.

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

End

Insert excerpt
Planned End Date
Planned End Date
nopaneltrue
This is a date picker that is not required. It defaults to blank and is editable until the transaction is in a status of Closed. If entered, it should be on or after the 'Start' date. Else, the message "[ProductionOrderID]: The selected date range is invalid." will be displayed on Save.

Database Field: ERPx_IMProductionOrderHeader.ScheduledDateEnd

Planned Input

Insert excerpt
Planned Input
Planned Input
nopaneltrue
 This is a non-editable text box that is not required and defaults as "0.00". This field is only editable changing the 'Units' or 'Weight' for one or more line items with a Line Type of Input on the Inventory Items tab. 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 Yield UOM, 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 is a non-editable text box that is not required and defaults as "0.00". This field is only editable by changing the 'Units' or 'Weight' for one or more line items with a Line Type of Output on the Inventory Items tab. 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 Yield UOM, then the line item will not be included in the input, output and yield calculations. 

Planned Yield Pct.

Insert excerpt
Planned Yield Percentage
Planned Yield Percentage
nopaneltrue
 This is a non-editable text box that is not required and defaults as "0.00". This field is only editable by changing the 'Units' or 'Weight' for one or more line items set to Include in Yield on the Inventory Items tab. 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 Yield UOM, then the line item will not be included in the input, output and yield calculations.

Production Name

Identifies the name of the Production plan, for example this could be a particular day and shift.   This is an editable text box that defaults to blank and is not required.  If entered, it must be <= 200 characters and does not need to be unique.  This is editable until the transaction is in a status of Closed. 

Database Field: ERPx_IMProductionOrderHeader.ProductionName

Reference

Insert excerpt
Reference
Reference
nopaneltrue
 This is an editable text box that defaults to blank and is not required.  If entered, it must be <= 100 characters and does not need to be unique.   This is editable until the transaction is in a status of Closed.

Database Field: ERPx_IMProductionOrderHeader.Reference

Site Name

Insert excerpt
Site Name
Site Name
nopaneltrue
This is a single-select standard lookup that is required. If missing, the message "[ProductionOrderID]: Site is required." will be displayed on Save. It defaults as blank and is not editable after initial Save. The selected Site will be used as the Site of the Production transaction once the production order is recorded.

Insert excerpt
Def - Site
Def - Site
nopaneltrue

The lookup contains a list of all the 'Active' Inventory Sites.

Database Fields: ERPx_IMProductionOrderHeader.SiteSK

Start

Insert excerpt
Planned Start Date
Planned Start Date
nopaneltrue
 This is a date picker that is required. If missing, the message "[ProductionOrderID]: Start is required." will be displayed on Save. It defaults to blank and is editable while in a status of 'Recurring', 'New', 'Scheduled' or 'Released'.  When entered it must be on or before the 'End' field, else, the message "ProductionOrderID]: The selected date range is invalid." will be displayed on Save.

Database Field: ERPx_IMProductionOrderHeader.ScheduledDateStart

Status

Insert excerpt
Status
Status
nopaneltrue
 This is a single-select standard lookup that defaults to 'New' and is required. This is always editable until the transaction is in a Status of 'Closed'. If the transaction is associated with a Production transaction(s), the Status may not be saved as 'Closed" until all associated Production transactions have been posted. Else, the message "[ProductionOrderID]: Production Order [ProductionOrderID] cannot be closed because Production Transaction(s) [Production ID] are not posted." will be displayed on Save.

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 - Status - Scheduled
Def - Status - Scheduled
nopaneltrue

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

Insert excerpt
Def - Status - In Process (Inventory)
Def - Status - In Process (Inventory)
nopaneltrue

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

The lookup contains all the values in the IMProductionOrderStatus Enumeration Class. 

Note: Production Orders in a status of 'Recurring' cannot be used to record Production. Production transactions created from the Record Production button will always be created in a status of 'New'. 

Database Field: ERPx_IMProductionOrderHeader.StatusEN

Yield UOM

Insert excerpt
Yield UOM
Yield UOM
nopaneltrue
This is an editable text box that is required. It defaults from the corresponding Transaction Class Yield UOM, else it is blank and if missing when the Status is saved as Approved or greater, the message "[ProductionOrderID]: Yield UOM is required." will be displayed on Save. 

The lookup contains the current assigned value and a list of all the 'Active' /wiki/spaces/HELP/pages/3642097677.

Database Field: ERPx_IMProductionOrderHeader.ProductionOrderUOM

Properties Tab 

FieldsDescription
Group: 1
Production Order

Insert excerpt
Transaction ID
Transaction ID
nopaneltrue
 This is a non-editable text box that is required.  It defaults from the transaction number assigned after the record is initially saved. This is never editable. 

Database Field: ERPx_IMProductionOrderHeader.ProductionOrderID

Production Order Class

Insert excerpt
Transaction Class
Transaction Class
nopaneltrue
This is a non-editable text box that is required and defaults to the Production Order Transaction Class that was selected/specified when creating the transaction. This field is never editable.

Database Fields: ERPx_IMTransactionClass.TransactionClassID, ERPx_IMProductionOrderHeader.TransactionClassSK

Start Time

Identifies the time the Production began.  This is an editable text box that is not required.  It defaults to blank and is always editable. If entered, it must be <= 20 characters.  This value will default to a Production transaction.

Database Field: ERPx_IMProductionOrderHeader.StartTime

End Time

Identifies the time the Production ended.  This is an editable text box that is not required.  It defaults to blank and is always editable. If entered, it must be <= 20 characters. This value may be less than the Start Time for productions that may span multiple days.   This value will default to a Production transaction.

Database Field: ERPx_IMProductionOrderHeader.EndTime

Group: 2
Created By

Insert excerpt
Created By
Created By
nopaneltrue
This is a required field.

Database Field: ERPx_IMProductionOrderHeader.CreatedBy

Created Date

Insert excerpt
Created
Created
nopaneltrue
This is a required field.

Database Field: ERPx_IMProductionOrderHeader.CreatedDate

Last Updated

Insert excerpt
Last Updated
Last Updated
nopaneltrue
This is a required field.

Database Field: ERPx_IMProductionOrderHeader.LastUpdated

Last Updated By

Insert excerpt
Last Updated By
Last Updated By
nopaneltrue
This is a required field.

Database Field: ERPx_IMProductionOrderHeader.LastUser


...

Page Detail

Inventory Items Grid Toolbar

Toolbar IconsDescription
Add Input
Insert excerpt
Add Output - RV Grid 3.0
Add Output - RV Grid 3.0
nopaneltrue
Add Output
Insert excerpt
Add Input - RV Grid 3.0
Add Input - RV Grid 3.0
nopaneltrue
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
Group By Show/Hide
Insert excerpt
Group By Show/Hide - Global
Group By Show/Hide - Global
nopaneltrue
Mass Update

Insert excerpt
Mass Update - Global 3.0
Mass Update - Global 3.0
nopaneltrue

  • Production Batch - This may only be updated if the Item is Lot tracked.
  • Warehouse Lot - This may only be updated if the Site is warehouse lot tracked.
  • Owner 
More Actions

Insert excerpt
More Actions - Global 3.0
More Actions - Global 3.0
nopaneltrue

  • LV: Warehouse Lot: Opens the Warehouse Lot List View, in a new tab, filtered for the selected record's Warehouse Lot, if applicable, else the message else the message "No Warehouse Lot exists for this item." will be displayed when clicked. 
  • RV: BOM: Opens the BOM Record View for the selected item if the item comes from a BOM record, else the message "No BOM exists for this item." will be displayed when clicked. 
  • RV: Item: Open the Item Record View for the selected item.
  • RV: Production Batch: Open the Production Batch Record View for the selected line item, if applicable, else the message else the message "No Production Batch exists for this item." will be displayed when clicked. 
Quick Column Filter
Insert excerpt
Quick Column Filter
Quick Column Filter
nopaneltrue
Remove Items

Insert excerpt
Remove Items - RV Grid 3.0
Remove Items - RV Grid 3.0
nopaneltrue

Items that have Production recorded against them cannot be deleted, the message "[Item ID] could not be deleted because it has had Production recorded against it." will be displayed on Save.

Saved Layouts
Insert excerpt
Column Layouts for Framework 3.0 - Global
Column Layouts for Framework 3.0 - Global
nopaneltrue


Grid: Inventory Items Tab

Column HeadersDescription
Checkbox
Insert excerpt
Checkbox
Checkbox
nopaneltrue
BOM ID

Identifies the unique ID of the BOM record associated with the line item. This is automatically assigned when an open BOM record exists for the Item and Site combination of the Production Order.  It is not required and is never editable. 

Database Fields: ERPx_IMBOM.BOMID, ERPx_IMProductionOrderDetail.BOMSK

BOM Qty Override

Identifies whether the 'Units' or 'Weight' of an Input line item with a Line Source of 'BOM' was manually updated or not.  This is a Yes/No field where 'Yes' means the user updated the default value of either the 'Units' or 'Weight' and No (which is displayed as blank) means the default value(s) has not been updated. 

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

BOM Units

Identifies the Units quantity from the associated BOM record.  This is only applicable to items that are assigned to a BOM.  If the user updates the 'Units' value for an Output line item (associated with the BOM), the BOM Units and all the corresponding Input items will be updated based on the difference.  For example, If the 'Units' value for the Output line item is 100 Cases when loaded from the BOM record and the user updates the 'Units' value to 90 Cases, all the input line(s) quantities from the BOM will be updated to 90% of the original quantity (for example, an input line item value of 50 Cases would now be updated to 45 Cases). 

Note: The BOM Units on an Input line are always calculated from the Output BOM Item's percentage. If a user updates the 'Units' value for an Input line associated with the BOM record, the BOM Units will not be updated based on this. 

Database Field: ERPx_IMProductionOrderDetail.BOMUnits

BOM Weight

Identifies the Weight from the associated BOM record.  This is only applicable to items that are assigned to a BOM.  If the user updates the 'Weight' value for an Output line item (associated with the BOM), the BOM Weight and all the corresponding Input items will be updated based on the difference.  For example, If the 'Weight' value for the Output line item is 1000lbs when loaded from the BOM record and the user updates the 'Weight' value to 900lbs, all the input line(s) quantities from the BOM will be updated to 90% of the original quantity (for example, an input line item value of 500lbs would now be updated to 450lbs). 

Note: The BOM Weight on an Input line are always calculated from the Output BOM Item's percentage. If a user updates the 'Weight' value for an Input line associated with the BOM record, the BOM Weight will not be updated based on this. 

Database Field: ERPx_IMProductionOrderDetail.BOMWeight

Include in Yield

Identifies whether the line item is included in the yield calculation or not.  This is a Yes/No lookup that is required.  It defaults based on the following:

  • For line items with a Line Source of Manual it defaults to "Yes". 
  • For line items with a Line Source of BOM it defaults to the value set on the corresponding BOM record. 

It is editable until the Production Order is in a status of Closed.

Database Fields: ERPx_IMBOMItem.IncludeInYield, ERPx_IMProductionOrderDetail.IncludeInYield

Item: Description

Insert excerpt
Item ID & Item Description
Item ID & Item Description
nopaneltrue
 This is a single-select standard lookup that is allows the user to select the item for which to include in the transaction. This is a required field. This field defaults to blank and is editable until the transaction is Saved.

The lookup contains a list of all the 'Active' inventory-tracked items configured in the Items Master File (Inventory > Items). 

(lightbulb) Selecting the Item will default the Units UOM and Weight UOM fields based on the Item properties.

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

Line Reference

Identifies a reference for a line item.  This is an editable text box that defaults to blank and is not required.  If entered, it must be <=100 characters and does not need to be unique.   This is always editable, even after the record is Closed.  This value will default to the Production Transaction Line Reference value for the corresponding item(s). 

Database Field: ERPx_IMProductionOrderDetail.Reference

Line Source

A non-editable textbox that displays where the corresponding line item originates from. This is required and never editable. The available options include:

  1. Manual: The line item was manually added by a user.
  2. BOM: The line item was auto-added from a BOM record. 

This lookup contains all the values in the IMProductionLineSource Enumeration Class where Enumeration Value = 1,2.

Database Field: ERPx_IMProductionOrderDetail.IMProductionLineSourceEN

Line Type

Insert excerpt
Line Type
Line Type
nopaneltrue
This is a single-select standard lookup that is required. It defaults based on the toolbar button that was clicked to add a new line.  If 'Add Output' button was clicked it defaults to "Output", and if 'Add Input' button was clicked it defaults to 'Input'.  It is only editable prior to the initial Save, then it is disabled. 

This lookup contains all the values in the IMLineItemType Enumeration Class where Enumeration Value = 1,2.

Database Field: ERPx_IMProductionOrderDetail.LineItemTypeEN

Ln.

Insert excerpt
Ln. - RV Items Grid
Ln. - RV Items Grid
nopaneltrue
 This is an editable text box that defaults to the next available base-10 number per Line Type. It is required, and is editable while the transaction is in a Status of "New". To re-sequence the line items, edit one or more lines with a new positive number that would put the line item where you want it sorted, and click the Save button. On save, the line items will be resorted per Line Type, and the Ln. values will be re-set to base-10 values.

For example, if you had three Input line items 10, 20, and 30 and you wanted the last one (Ln. 30) to be second, you could edit the value to any number between 10 and 20 (i.e., 15) and on save the lines would be sorted in the new sequence (10, 15, and 30) and then all Ln.'s would be re-set to base 10 numbers (10, 20, 30).

Note: Since the Ln. values are per Line Type, it is possible to have duplicate Ln. values across the types. 

Database Fields: ERPx_IMProductionOrderDetail.ItemSort, ERPx_IMProductionOrderDetail.ItemSortOverride

Owner

Insert excerpt
Owner - Item
Owner - Item
nopaneltrue
 This is a single select standard lookup that is required. It defaults to the Inventory Preference value for 'Default Owner' and is always editable until the Production Order is in a status of Closed. 

Insert excerpt
Def - Owner
Def - Owner
nopaneltrue

The lookup contains the current assigned value and a list of all the Lot Owners.

Database Fields: ERPx_IMLotOwner.OwnerName, ERPx_IMProductionOrderDetail.OwnerSK

Production Batch

Insert excerpt
Production Batch
Production Batch
nopaneltrue
 This is a text box that is not required. This field is enabled for items where the 'Lot Tracked' field is set to "Yes". This field is disabled for items where the 'Lot Tracked' field is set to "No". If enabled, this field is always editable while the transaction is in a status of 'Open' or 'Released'. The value entered in this field will auto-populate on the associated line item on a recorded production transaction.

Insert excerpt
Def - Production Batch
Def - Production Batch
nopaneltrue

Insert excerpt
Def - Inventory Lot
Def - Inventory Lot
nopaneltrue

Database Field: ERPx_IMProductionOrderDetail.ProductionBatchID

Scheduled Qty

Identifies the line item's quantity converted to the Item's Cost UOM.  This is a non editable text box that is required if a Cost UOM exists on the Item and the UOM is on the Item's schedule.  It is auto calculated after an item is added with Units/Weight values and is saved.  For example, if a line item has a Cost UOM of kg and the line item's quantity is entered in Lbs, the Scheduled Qty value will display the line item's quantity in kg. 

Database Field: ERPx_IMProductionOrderDetail.ScheduledQuantity

Unit UOM

Insert excerpt
UOM - Units
UOM - Units
nopaneltrue
 This is a single-select standard lookup that is required if the item is managed by 'Units Only' or by 'Units and Weight'. Before an item is selected, this field will default as blank and the lookup will not include any values. Once an item is selected, this field will default from the 'Inventory Unit UOM' field set up on the 'Properties' tab of the Item record view. This field will be disabled if the item is managed by 'Weight Only'. This field can always be edited until the transaction is in a status of 'Closed'.

The lookup contains the current assigned value and a list of all 'Active' Unit UOMs on the selected Item's UOM Schedule.

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

Units

Identifies the number of units for the line item. This is a numeric text box that is required if the item is managed by 'Units Only' or by 'Units and Weight'. It defaults to "0.00" and is only enabled if the selected item is managed by 'Units Only' or by 'Units and Weight'. If enabled, this field can always be edited while the transaction is in a status of 'Open' or 'Released'. If enabled, this field must be a positive number, else the message “[ProductionOrderID]: Item [Item ID] must be saved with positive Unit and Weight quantities” or “[ProductionOrderID]: Item [Item ID] must be saved with positive Units quantity.” will be displayed on Save. The number of decimal places displayed will be based on the 'Unit Decimals' field on the Item record view. Additionally, a footer total will be displayed for this field.

If this field is editable, the following will be enforced:

  • For an item that is fixed weight and requires whole units:

    • When Units are entered: the value will be rounded up to the nearest integer then the weight will automatically be calculated based on the Units integer value.

  • For an item that is fixed weight and does not require whole units:

    • When Units are entered: the weight will automatically be calculated based on the Units value. The Units value does not have to be an integer.

  • For an item that is variable weight and requires whole units:

    • When Units go from empty to a value: the value will be rounded up to the nearest integer then the weight will automatically be calculated based on the Units integer value.

    • When Units go from one value to another: the value will be rounded up to the nearest integer but the weight will NOT be recalculated.

Database Fields: ERPx_IMProductionOrderDetail.OrderedUnits, ERPx_IMProductionOrderDetail.BOMUnits

Warehouse Lot

Insert excerpt
Warehouse Lot
Warehouse Lot
nopaneltrue
 This is a text box that is not required. This field is enabled for Sites where the 'Warehouse Lot Tracked' field is set to "Yes - Allow multiple items in single lots" or "Yes - Limit Warehouse Lots to single items". This field is disabled for Sites where the 'Warehouse Lot Tracked' field is set to "No". If enabled, this field is always editable until the transaction is in a status of 'Closed'. The value entered in this field will auto-populate on the associated line item on a recorded production transaction.

Insert excerpt
Def - Warehouse Lot
Def - Warehouse Lot
nopaneltrue

Insert excerpt
Def - Inventory Lot
Def - Inventory Lot
nopaneltrue

Database Field: ERPx_IMProductionOrderDetail.WarehouseLotID

Weight

Identifies the weight for the line item. This is a numeric text box that is required if the item is managed by 'Weight Only' or by 'Units and Weight'. It defaults to "0.00" and is only enabled if the selected item is managed by 'Weight Only' or 'Units and Weight'. If enabled, this field can always be edited while the transaction is in a status of 'Open' or 'Released'. If enabled, this field must be a positive number, else the message “Request 1 [ProductionOrderID]: Item [Item ID] must be saved with positive Unit and Weight quantities” or “Request 1 [ProductionOrderID]: Item [Item ID] must be saved with positive Weight quantity" will be displayed on Save. The number of decimal places displayed will be based on the 'Weight Decimals' field on the Item record view. Additionally, a footer total will be displayed for this field.

If this field is editable, the following will be enforced:

  • For an item that is fixed weight and requires whole units:

    • When Weight is entered: the value will be rounded up to the nearest weight that results in a whole unit then the units will automatically be calculated based on the Weight value.

  • For an item that is fixed weight and does not require whole units:

    • When Weight is entered: the Units will automatically be calculated based on the Weight value. The Weight value does not have to result in an integer Units value.However, because the Units and Weight values round to two decimal places, if the rounded Units value produced by the weight value does not convert to equal the weight value, the weight value will automatically update to equal the converted value of the units since the item is a fixed weight item.

  • For an item that is variable weight and requires whole units:

    • When Weight goes from empty to a value: the value will be rounded up to the nearest weight that results in a whole unit then the units will automatically be calculated based on the Weight value.

    • When Weight goes from one value to another: the units will NOT be recalculated.

Database Fields: ERPx_IMProductionOrderDetail.OrderedWeight, ERPx_IMProductionOrderDetail.BOMWeight

Weight UOM

Insert excerpt
UOM - Weight
UOM - Weight
nopaneltrue
 This is a single-select standard lookup that is required if the item is managed by 'Weight Only' or by 'Units and Weight'. Before an item is selected, this field will default as blank and the lookup will not include any values. Once an item is selected, this field will default from the 'Inventory Weight UOM' field set up on the 'Properties' tab of the Item record view. This field will be disabled if the item is managed by 'Units Only'. This field can always be edited until the transaction is in a status of 'Closed'. 

The lookup contains the current assigned value and a list of all 'Active' Weight UOMs on the selected Item's UOM Schedule.

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

Yield Quantity

Identifies the conversion of the quantity of the line item to the Production Order Yield UOM quantity.  This is a system assigned non-editable field that is not required.  It only applies to line items where the 'Include in Yield' is set to 'Yes' and the Item's UOM Schedule includes the Yield UOM specified on the Production Order transaction, else it is blank. 

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

Cost Items Grid Toolbar

Toolbar IconsDescription
Add Items
Insert excerpt
Add Item - RV Grid 3.0
Add Item - RV Grid 3.0
nopaneltrue
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
Group By Show/Hide
Insert excerpt
Group By Show/Hide - Global
Group By Show/Hide - Global
nopaneltrue
Quick Column Filter
Insert excerpt
Quick Column Filter
Quick Column Filter
nopaneltrue
Remove Items

Insert excerpt
Remove Items - RV Grid 3.0
Remove Items - RV Grid 3.0
nopaneltrue

Cost Items that are associated with a BOM record cannot be deleted, the message "[Cost Item ID] could not be deleted because it was added from a BOM." will be displayed on Save.

Saved Layouts
Insert excerpt
Column Layouts for Framework 3.0 - Global
Column Layouts for Framework 3.0 - Global
nopaneltrue

Grid: Cost Items Tab

Column HeadersDescription
Checkbox
Insert excerpt
Checkbox
Checkbox
nopaneltrue
BOM ID

Identifies the unique ID of the BOM record.  This is a non-editable text box that is automatically assigned when an open BOM record exists with a Cost Item(s) for the BOM Item and Site combination.  It is not required and is never editable. 

Database Fields: ERPx_IMBOM.BOMID, ERPx_IMProductionOrderDetail.BOMSK, ERPx_IMProductionOrderCostItem.BOMSK

Cost

Displays the calculated extended amount of the Cost item. This is a numeric text box that is calculated as: [Cost Rate] * [Quantity].  This is never editable.

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

Cost Item

Identifies the Cost Item displayed as [Cost Item ID]: [Cost Item Description]. This is a text box that allows the user to select the item to include in the transaction. This is a required field. This field defaults to blank and is editable until the transaction is Saved.

Database Fields: ERPx_IMCostItem.CostItemID: CostItemDescription, ERPx_IMBOMCostItem.BOMCostItemSK, ERPx_IMProductionOrderCostItem.CostItemSK

Cost Rate

Identifies the rate of the Cost Item.  This is a numeric text box that defaults to the Cost Rate specified on the Cost Item master file when the Line Source is Manual and from the Current Rate based on the effective date of the Cost Item from the BOM record when the Line Source is BOM. 

Database Fields: ERPx_IMCostItem.Rate,  IMProductionOrderCostItem.Rate

Cost UOM

Identifies the Unit of Measure of the Cost Item. This defaults from the Cost Item selected and is never editable from this record.  It can be edited from the Cost Items List View at any time.  

Database Fields: ERPx_IMUOM.UOMID, ERPx_IMBOMCostItem.UOMSK, IMProductionOrderCostItem.UOMSK

Line Reference

Identifies the reference for the cost item.  This is an editable text box that defaults to blank and is not required.  If entered, it must be <=100 characters and does not need to be unique.   This is always editable, even after the record is Closed. 

Database Fields: IMProductionOrderCostItem.Reference

Line Source

A non-editable textbox that displays where the corresponding line item originates from. This is required and never editable. The available options include:

  1. Manual: The line item was manually added by a user.
  2. BOM: The line item was auto-added from a BOM record. 

This lookup contains all the values in the IMProductionLineSource Enumeration Class where Enumeration Value = 1,2.

Database Field: ERPx_IMProductionOrderCostItem.IMProductionLineSourceEN

Ln.

Insert excerpt
Ln. - RV Items Grid
Ln. - RV Items Grid
nopaneltrue
 This is an editable text box that defaults to the next available base-10 number. It is required, and is editable while the transaction is in a Status of "New". To re-sequence the line items, edit one or more lines with a new positive number that would put the line item where you want it sorted, and click the Save button. On save, the line items will be resorted, and the Ln. values will be re-set to base-10 values.

For example, if you had line items 10, 20, and 30 and you wanted the last one (Ln. 30) to be second, you could edit the value to any number between 10 and 20 (i.e., 15) and on save the lines would be sorted in the new sequence (10, 15, and 30) and then all Ln.'s would be re-set to base 10 numbers (10, 20, 30).

Database Field: ERPx_IMProductionOrderCostItem.LineNumber

Quantity

Identifies the quantity of the line item. This is a numeric textbox that defaults to blank, is required and is editable while the record is in New Status.  The value entered must be >=0  else the message "Cost Item [CostItemID] Quantity must be greater than or equal to 0." will be displayed on Save. 

Database Fields: ERPx_IMBOMCostItem.Quantity, IMProductionOrderCostItem.Quantity


...