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 Icons | Description |
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! 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). The bolded view is the default view, which will determine the view will automatically display in when opened. |
Help | Opens the online WIKI help page for the current page. 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. |
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". This icon is disabled when the Status is 'Closed'. |
Save | Saves the changes made to the record. 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
Fields | Description |
---|---|
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. Database Field: ERPx_IMProductionOrderHeader.ProductionOrderUOM |
Properties Tab
Fields | Description |
---|---|
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. 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 Icons | Description |
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. |
New | Adds new blank lines in the grid section to allow for data entry. |
Grid: Outputs Tab
Column Headers | Description |
---|---|
Checkbox | Used 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). 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:
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:
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:
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:
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 Headers | Description |
---|---|
Checkbox | Used 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). 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:
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:
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:
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:
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 |