Production Order Record View

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.

Software Version: 2021.07.05 and newer

Page Header

Header Toolbar

Toolbar IconsDescription
Delete
Deletes the transaction or master file record. When clicked, users will be prompted with: "Are you sure you want to delete this record?". Click "OK" to confirm, or "Cancel" to return without deleting. 

WARNING: Records cannot be recovered once they are deleted!

(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).
Grid Layout
Opens the Saved Grid Layout menu that allows the user to select another saved layout, create a new layout, save changes to a layout, or assign a saved layout as the default for the page. Once changes are made to a grid, such as columns are added or removed, the user can click the Saved Grid Layout icon and save the changes to the grid layout and name the new layout. The new layout can also be set as the default, instead of the System View. This is useful for creating specific views to separate master files or transaction types (i.e. Invoice specific vs. Credit Memo specific).

(lightbulb) The bolded view is the default view, which will determine the view will automatically display in when opened. 

HelpOpens the online WIKI help page for the current page. 

(lightbulb) This icon is only visible on pages that are documented in the online help.

New

Allows the user to create a new master file record or transaction by opening a blank record view page. This icon is always enabled.  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

Opens the Notes dialog, filtered for the appropriate Note Type(s). From here, users can add, review, or edit Notes associated with the record. This icon is always enabled. Two Note Types (Internal, Production Instructions) 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 Opens the Print dialog, showing any applicable printable reports to be printed, downloaded, and/or emailed. 
Record Production

Saves the Production order and opens the Record Production popup, allowing users to specify the Production Transaction Class and Production Date. The 'Production Transaction Class' field defaults from the 'Related Production Transaction Class' on the Production Order Transaction Class record view. Users have the ability to change this to any 'Active' Production Transaction Class. The 'Production Date' defaults to the current date. Users can click the Process button create a Production transaction from the Production Order transaction. Users will be prompted with the TransactionID that was generated and can navigate directly to the Production record view or remain on the Production Order 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 icon is disabled when the Status is 'Closed'.

Save

Saves the changes made to the record. 

(lightbulb) It is only necessary to click the Save button when a change is detected on the page. When a change has been made, a ‘ + ‘ character is displayed prior to the page name in the page title bar (light blue bar in the upper left corner of the page). Clicking Save reloads the page.

 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.

Home Tab 

FieldsDescription
Actual Input

Identifies the total number of inputs, based on the UOM of the Production Order transaction, entered on the Input tab of all associated Production transactions. 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 in the Input tab. This field is only editable by adding or editing the 'Units' field or 'Weight' field for a line item in the Input 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

Identifies the total number of outputs, based on the UOM of the Production Order transaction, entered on the Output tab of all associated Production transactions. 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 in the Output tab. This field is only editable by adding or editing the 'Units' field or 'Weight' field for a line item in the Output 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.

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

Actual Yield %

Identifies the yield percentage of the actual product used. 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 in the Input 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 in the Input tab or Output tab of the associated Production 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.

Complete %

Calculates the percentage complete between the Planned Output and the Actual Output. 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. This field is only editable by adding or editing the 'Units' field or 'Weight' field for a line item in the Output tab of the Production Order transaction or the associated Production transaction. This is a calculated field that is not stored in the database.

Order ID

Identifies the unique Transaction ID for each transaction. This is an editable text box that is required.   It defaults to "(Use Next #)" which is a system assigned number that comes from the 'Transaction Class', or users can enter their own alphanumeric ID up to 50 characters long.  Duplicate ID's are not allowed and the message "Duplicate Production Order IDs are not allowed" will be displayed on Save. 

Database Field: ERPx_IMProductionOrderHeader.ProductionOrderID

Planned End

Identifies the scheduled completion date of the Production Order. This is a date picker that is not required. It defaults to blank and is always editable. If entered, it should be on or after the 'Planned Start' field. Else, the message "Request 1 [ProductionOrderID]: The selected date range is invalid." will be displayed on Save.

Database Field: ERPx_IMProductionOrderHeader.ScheduledDateEnd

Planned Input

Calculates the sum of all the Input line items, converted to the UOM of the Production Order. 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 in the Inputs or Outputs 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 UOM in the Production Order header, then the line item will not be included in the input, output and yield calculations.

Planned Output

Calculates the sum of all the Output line items, converted to the UOM of the Production Order. 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 in the Inputs or Outputs 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 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

Identifies the scheduled start date of the Production Order. This is a date picker that is required. If missing, the message "Request 1 [ProductionOrderID]: Planned Start is required." will be displayed on Save. It defaults to blank and is always editable. If entered, it should be on or before the 'Planned End' field. Else, the message "Request 1 [ProductionOrderID]: The selected date range is invalid." will be displayed on Save.

Database Field: ERPx_IMProductionOrderHeader.ScheduledDateStart

Planned Yield %

Identifies the yield percentage based on the Input and Output items assigned to the Production Order. It is calculated as [Planned Output] / [Planned Input] * 100. 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 in the Inputs or Outputs 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 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.

Site

Error rendering macro 'excerpt-include' : No link could be created for 'site'.
This is a single-select standard lookup that is required. If missing, the message "Request 1 [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.

Sites represent Plants, Warehouses, Distribution Centers, or virtual objects that are used to store and/or maintain perpetual inventory balances.

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

Database Fields: ERPx_IMProductionOrderHeader.SiteSK

Status

Identifies the Status of the transaction. This is a single-select standard lookup that defaults as 'Open' and is required. This is always editable while the transaction is in a Status of 'Open'. The Status may not be saved as 'Closed" until all associated Production transactions have been posted. Else, the message "Request 1 [ProductionOrderID]: Production Order [ProductionOrderID] can not be closed because Production Transaction(s) [Production ID] are not posted." will be displayed on Save.

Status is used to identify where a transaction, Purchase Order, Price List, BOM, or Master File record is in its life cycle. Records start in a Status of 'New' and progress sequentially through additional statuses until they are 'Posted' or 'Closed'. The list of potential Statuses changes depending on the transaction type.  The Statuses that apply to transactions in this List View include:

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

Released: This status is used to signify that the transaction is ready to be released to production. While in the Status of 'Released', all editable fields are open for edit.

Closed: Used to indicate that the record is no longer open to be used on other transactions. Closed records are only visible from inquiries, not list views.

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

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

UOM

Identifies the unit of measure that will be used to calculate the Yield %. All line item quantities will be converted to this UOM to calculate yield.
This is a non-editable text box that is required. It defaults from the 'Production Order UOM' field on the 'Properties' tab of the transaction. If missing, the message "Request 1 [ProductionOrderID]: Production Order UOM is required. This field may be updated from the "Properties" tab" will be displayed on Save. This field is only editable from the 'Properties' tab.

Database Field: ERPx_IMProductionOrderHeader.ProductionOrderUOM

Properties Tab 

FieldsDescription
Allow Substitutes

Identifies whether items can be substituted on the transaction. 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 always editable.

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

Database Field: ERPx_IMProductionOrderHeader.AllowSubstitutesEN

Created By

Identifies the name of the user that created the record. It is formatted to be the "logged-in" users [User First Name] + [User Last Name]. This is a system assigned value and is never editable by a user. This is a required field.

Database Field: ERPx_IMProductionOrderHeader.CreatedBy

Created Date

Identifies the Created Date & Time of the record, formatted from the users 'Date Format' preference. This is a system assigned value and is never editable by a user. This is a required field.

Database Field: ERPx_IMProductionOrderHeader.CreatedDate

Last Updated

Identifies the Last Updated Date & Time of the Transaction, formatted from the users 'Date Format' preference. This is a system assigned value and is never editable by a user.This is a required field.

Database Field: ERPx_IMProductionOrderHeader.LastUpdated

Last Updated By

Identifies the name of the user that last updated the Transaction. It is formatted to be the "logged-in" users [User First Name] + [User Last Name]. This is a system assigned value and is never editable by a user.This is a required field.

Database Field: ERPx_IMProductionOrderHeader.LastUser

Production Order UOM

Identifies the unit of measure that will be used to calculate the Yield %. All line item quantities will be converted to this UOM to calculate yield.
This is single-select standard lookup that is required. It defaults from the 'Production Order UOM' field on the Production Order Transaction Class record view. If missing, the message "Request 1 [ProductionOrderID]: Production Order UOM is required. This field may be updated from the "Properties" tab" will be displayed on Save. This field is always editable.

The lookup contains the current assigned value and a list of all the 'Active' Units of Measure.

Database Field: ERPx_IMProductionOrderHeader.ProductionOrderUOM

Transaction Class

The unique identifier of the Transaction Class. This is a non-editable text box that is required. It is assigned on New. This field is never editable.

Database Fields: ERPx_IMTransactionClass.TransactionClassID, ERPx_IMProductionOrderHeader.TransactionClassSK

Page Detail

Items Grid

Toolbar IconsDescription
Delete

Deletes the selected line(s) from the transaction or master file. This icon is only enabled for transactions with a Status of 'New'.

Excel

Exports the contents of the grid to an Excel file that will automatically download. The contents that export are those that are visible to the user. Therefore, if the user has filtered the view only the filtered contents will be exported. 

NewAdds new blank lines in the grid section to allow for data entry.

Grid: Outputs Tab

Column HeadersDescription
CheckboxUsed to select one or more records to perform an action, such as Mass Update, More Actions, or Delete.
Item: Description

Identifies the Item, displayed as Item ID: Item Description.  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 Type

Identifies the type of the line item. This is a single-select standard lookup that is required. It defaults to "Output" and is always editable while the transaction is in a status of 'Open' or 'Released'.

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

Database Field: ERPx_IMProductionOrderDetail.LineItemTypeEN

Owner

Identifies a the Lot Owner for a line item. This is a single select standard lookup that is required. It defaults to the Inventory Preference value for 'Default Owner' and is always editable while the transaction is in a status of 'Open' or 'Released'.

Owners are used to identify who owns the inventory. Additional Owners are typically added for companies that do custom processing and need to keep that inventory separate from their own. Owner is one of the 5 components that make up a unique Inventory Lot and it is required on all Inventory Lots.

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

Identifies the Production Batch ID of the Lot. 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.

A Production Batch is the identifier that contains all the Traceability information (Production Batch Properties and Attributes) for Lot Tracked Items. This number stays attached to the product, even if it is transferred to another Site. Production Batch is one of the 5 components that make up a unique Inventory Lot and it is required when entering a transaction line for a Lot Tracked Item. This value will be blank and/or disabled for all non-Lot Tracked items on screens that include a Production Batch field.

An Inventory Lot is the most granular level that item balances (quantities of Units and/or Weight) are stored within NorthScope. Inventory Lots are created for all Inventory Items assigned an Item Type of “Inventory', regardless of whether the Item is Lot Tracked (i.e., balances are maintained by Production Batch) or the Site containing the product is 'Warehouse Lot' tracked or not. 

An Inventory Lot is unique by combination of:

  • Item: The Item ID (required for all Inventory Lots)
  • SiteThe Site/Warehouse that contains the inventory (required for all Inventory Lots)
  • Production BatchThe date code or other traceability reference that stays with product and never changes. It is required for Items with a 'Lot Tracked' property of "Yes" and will be blank for Items with a 'Lot Tracked' property of "No"
  • Warehouse LotThe identifier or location within a Site/Warehouse, this is most typically used for 3rd party distribution sites. It is required for 'Inventory Lots' in a Warehouse Lot tracked Site and will be blank for 'Inventory Lots' in a non Warehouse Lot tracked Site. This has nothing to do with whether the Item is 'Lot Tracked' or not. 
  • Owner: Identifies who owns the product. This is required for all Inventory Lots.

Database Field: ERPx_IMProductionOrderDetail.ProductionBatchID

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 “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 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 Field: ERPx_IMProductionOrderDetail.OrderedUnits

Units UOM

Identifies the unit of measure that the units are stored in (Box, Bag, Case, Each, Tote, etc.) for a line item or on the transaction. 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 while the transaction is in a status of 'Open' or 'Released'.

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

Warehouse Lot

Identifies the Warehouse Lot to which the selected item or inventory lot belongs. 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 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.

A Warehouse Lot (aka Storage Lot) is used by 3rd party distribution sites to identify a unique quantity of product they are storing. Unlike a Production Batch number that never changes, Warehouse Lots will change as product is transferred to other Sites and/or transferred into exiting Warehouse Lots within the same Site. The 'Warehouse Lot' is one of the 5 components that make up a unique Inventory Lot and it is required when entering a transaction line on a transaction for a Warehouse Lot Tracked Site. This value will be blank and/or disabled for all non-Warehouse Lot Tracked Sites on screens that include a Warehouse Lot field.

An Inventory Lot is the most granular level that item balances (quantities of Units and/or Weight) are stored within NorthScope. Inventory Lots are created for all Inventory Items assigned an Item Type of “Inventory', regardless of whether the Item is Lot Tracked (i.e., balances are maintained by Production Batch) or the Site containing the product is 'Warehouse Lot' tracked or not. 

An Inventory Lot is unique by combination of:

  • Item: The Item ID (required for all Inventory Lots)
  • SiteThe Site/Warehouse that contains the inventory (required for all Inventory Lots)
  • Production BatchThe date code or other traceability reference that stays with product and never changes. It is required for Items with a 'Lot Tracked' property of "Yes" and will be blank for Items with a 'Lot Tracked' property of "No"
  • Warehouse LotThe identifier or location within a Site/Warehouse, this is most typically used for 3rd party distribution sites. It is required for 'Inventory Lots' in a Warehouse Lot tracked Site and will be blank for 'Inventory Lots' in a non Warehouse Lot tracked Site. This has nothing to do with whether the Item is 'Lot Tracked' or not. 
  • Owner: Identifies who owns the product. This is required for all Inventory Lots.

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 Field: ERPx_IMProductionOrderDetail.OrderedWeight

Weight UOM

Identifies the unit of measure that the weight is stored in (Lbs, Kg, Oz, Ton, etc.) for a line item or on the transaction. 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 while the transaction is in a status of 'Open' or 'Released'.

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

Grid: Inputs Tab

Column HeadersDescription
CheckboxUsed to select one or more records to perform an action, such as Mass Update, More Actions, or Delete.
Item: Description

Identifies the Item, displayed as Item ID: Item Description.  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 Type

Identifies the type of the line item. This is a single-select standard lookup that is required. It defaults to "Input" and is always editable while the transaction is in a status of 'Open' or 'Released'.

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

Database Field: ERPx_IMProductionOrderDetail.LineItemTypeEN

Owner

Identifies a the Lot Owner for a line item. This is a single select standard lookup that is required. It defaults to the Inventory Preference value for 'Default Owner' and is always editable while the transaction is in a status of 'Open' or 'Released'.

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

Owners are used to identify who owns the inventory. Additional Owners are typically added for companies that do custom processing and need to keep that inventory separate from their own. Owner is one of the 5 components that make up a unique Inventory Lot and it is required on all Inventory Lots.

Database Fields: ERPx_IMLotOwner.OwnerName, ERPx_IMProductionOrderDetail.OwnerSK

Production Batch

Identifies the Production Batch ID of the Lot. 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.

A Production Batch is the identifier that contains all the Traceability information (Production Batch Properties and Attributes) for Lot Tracked Items. This number stays attached to the product, even if it is transferred to another Site. Production Batch is one of the 5 components that make up a unique Inventory Lot and it is required when entering a transaction line for a Lot Tracked Item. This value will be blank and/or disabled for all non-Lot Tracked items on screens that include a Production Batch field.

An Inventory Lot is the most granular level that item balances (quantities of Units and/or Weight) are stored within NorthScope. Inventory Lots are created for all Inventory Items assigned an Item Type of “Inventory', regardless of whether the Item is Lot Tracked (i.e., balances are maintained by Production Batch) or the Site containing the product is 'Warehouse Lot' tracked or not. 

An Inventory Lot is unique by combination of:

  • Item: The Item ID (required for all Inventory Lots)
  • SiteThe Site/Warehouse that contains the inventory (required for all Inventory Lots)
  • Production BatchThe date code or other traceability reference that stays with product and never changes. It is required for Items with a 'Lot Tracked' property of "Yes" and will be blank for Items with a 'Lot Tracked' property of "No"
  • Warehouse LotThe identifier or location within a Site/Warehouse, this is most typically used for 3rd party distribution sites. It is required for 'Inventory Lots' in a Warehouse Lot tracked Site and will be blank for 'Inventory Lots' in a non Warehouse Lot tracked Site. This has nothing to do with whether the Item is 'Lot Tracked' or not. 
  • Owner: Identifies who owns the product. This is required for all Inventory Lots.

Database Field: ERPx_IMProductionOrderDetail.ProductionBatchID

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 “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 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 Field: ERPx_IMProductionOrderDetail.OrderedUnits

Units UOM

Identifies the unit of measure that the units are stored in (Box, Bag, Case, Each, Tote, etc.) for a line item or on the transaction. 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 while the transaction is in a status of 'Open' or 'Released'.

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

Warehouse Lot

Identifies the Warehouse Lot to which the selected item or inventory lot belongs. 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 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.

A Warehouse Lot (aka Storage Lot) is used by 3rd party distribution sites to identify a unique quantity of product they are storing. Unlike a Production Batch number that never changes, Warehouse Lots will change as product is transferred to other Sites and/or transferred into exiting Warehouse Lots within the same Site. The 'Warehouse Lot' is one of the 5 components that make up a unique Inventory Lot and it is required when entering a transaction line on a transaction for a Warehouse Lot Tracked Site. This value will be blank and/or disabled for all non-Warehouse Lot Tracked Sites on screens that include a Warehouse Lot field.

An Inventory Lot is the most granular level that item balances (quantities of Units and/or Weight) are stored within NorthScope. Inventory Lots are created for all Inventory Items assigned an Item Type of “Inventory', regardless of whether the Item is Lot Tracked (i.e., balances are maintained by Production Batch) or the Site containing the product is 'Warehouse Lot' tracked or not. 

An Inventory Lot is unique by combination of:

  • Item: The Item ID (required for all Inventory Lots)
  • SiteThe Site/Warehouse that contains the inventory (required for all Inventory Lots)
  • Production BatchThe date code or other traceability reference that stays with product and never changes. It is required for Items with a 'Lot Tracked' property of "Yes" and will be blank for Items with a 'Lot Tracked' property of "No"
  • Warehouse LotThe identifier or location within a Site/Warehouse, this is most typically used for 3rd party distribution sites. It is required for 'Inventory Lots' in a Warehouse Lot tracked Site and will be blank for 'Inventory Lots' in a non Warehouse Lot tracked Site. This has nothing to do with whether the Item is 'Lot Tracked' or not. 
  • Owner: Identifies who owns the product. This is required for all Inventory Lots.

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 Field: ERPx_IMProductionOrderDetail.OrderedWeight

Weight UOM

Identifies the unit of measure that the weight is stored in (Lbs, Kg, Oz, Ton, etc.) for a line item or on the transaction. 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 while the transaction is in a status of 'Open' or 'Released'.

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

Related Topics



 Page Definitions

Page Definitions


 Technical Details

Technical Details