The purpose of this page is to both search for and allocate inventory lots to sales Orders and Quotes in a single step. This page is most useful when you are entering an order interactively with a custom and/or selling out of existing inventory. Allocated Lots are added to the Sales transaction as either a new transaction line or as an update to an existing line. Users can view order progress by clicking on the 'Order Summary' tab.
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)
- Site: The Site/Warehouse that contains the inventory (required for all Inventory Lots)
- Production Batch: The 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 Lot: The 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.
This page also contains columns for each attribute setup for 'Items' and 'Production Batches'. Additionally, this record view also contains columns for each Lot Certification with a certification 'Type' of "Item & Site". Because these are user defined, they are not included in the default view but can be added a saved column layout. Item attributes, Production Batch attributes and Lot Certifications are not included in the help documentation.
Software Version: 2021.06.04 and newer
Page Header
Filters Tab - Search
Search Options | Description |
---|---|
Include | Used to specify the type of balances or items/lots to include. This is a multi-select standard lookup that is required to return results. It defaults to "Lots with Available Balance". The options available include:
This lookup contains the values in the IncludeInLotBalance Enumeration Class. |
Item | Used to select one or more Items. This is a multi-select standard lookup that is not required to return results. It defaults as blank. Item IDs are the unique identifier for Items. The lookup contains a list of all Items in the Items master file. |
Item Class | Used to select one or more Item Classes. This is a multi-select standard lookup that is not required to return results. It defaults as blank. Item Classes are used to identify default values that will be applied to new Inventory Items and to group Items together for reporting purposes. The lookup contains a list of all Item Classes. |
Lot Owner | Used to select one or more inventory Owners. This is a multi-select standard lookup that is not required to return results. It defaults as blank. 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 a list of all Lot Owners. |
Search | A non-required text box that defaults to blank and is used to search across multiple fields. When the page is 'Refreshed', the data returned will be limited by what was included in the Search box (in addition to any other Search Options). Refer to this FAQ for advanced search options. The Search field can be used to search across the following fields:
|
Order Summary Tab
Fields | Description |
---|---|
Is Sub Item | Displays whether the item is a substitute item and the item description of the item which it was substituted for. This is a non-editable text box that is not required. It defaults a blank. This field is never editable and is not stored in the database. |
Item | Identifies the Item, displayed as Item ID: Item Description. This is a non-editable text box that is required. It defaults from the saved item(s) on the sales transaction. This field can be edited from the 'Item Description' field on the 'Properties' tab of the Item Record View. Item IDs are the unique identifier for Items. Database Fields: ERPx_IMItem.ItemID:ItemDescription, ERPx_SOOrderItem.OrderItemSK |
Ord. Units | Displays the number of units ordered for the line item. This is a non-editable text box that is not required. It defaults as the item unit quantity saved on the transaction, else it defaults to "0.00". This field also defaults to "0.00" if the item's "Manage Item By' property is set to "Weight Only". This field is editable from the 'Ord. Units' column for the associated item on the Sales Order Record View while the status of the transaction is less than Shipped. Database Field: ERPx_SOOrderItem.OrderedUnits |
Ord. Weight | Displays the weight ordered for the line item. This is a non-editable text box that is not required. It defaults as the item weight saved on the transaction, else it defaults to "0.00". This field also defaults to "0.00" if the item's "Manage Item By' property is set to "Units Only". This field is editable from the 'Ord. Weight' column for the associated item on the Sales Order Record View while the status of the transaction is less than Shipped. Database Field: ERPx_SOOrderItem.OrderedWeight |
Ship By | Identifies the date the shipment containing the item is scheduled to leave the Site, formatted from the users 'Date Format' preference. This is a non-editable text box that is required for the transaction to be saved in a status of 'Shipped' or greater. This field defaults from the 'Ship By' field for the associated Item on the Items grid on the Sales Order Record View. It can be edited from the 'Ship By' field on the 'Shipments' tab of the Sales Order Record View. Database Fields: ERPx_SOOrderItem.ScheduledShipDate, ERPx_LMLoadHeader.ScheduledShipDate |
Site | Identifies the unique Site ID (warehouse ID) of the Site the transaction, shipment, item, or lot is associated with. This is a non-editable text box that is required. It defaults from the 'Site' field on the Items grid on the Sales Order Record View. It can be edited from the 'Site' field on the 'Shipments' tab of the Sales Order Record View. Sites represent Plants, Warehouses, Distribution Centers, or virtual objects that are used to store and/or maintain perpetual inventory balances. Database Fields: ERPx_MFSite.SiteID, ERPx_LMLoadHeader.SiteSk |
Units | Displays the allocated units to be added or subtracted from the Available balance for the line item. This is a non-editable text box that is not required. It defaults as the unity quantity allocation fro the item saved on the transaction, else it defaults to "0.00". This field also defaults to "0.00" if the item's "Manage Item By' property is set to "Weight Only". This field is editable from the 'Alloc. Units' column for the associated inventory lot on the Find Lots Record View or the 'Units' column for the associated item on the Allocate Sales Transaction Item Record View for the transaction while the status of the transaction is less than Approved. Database Field: ERPx_SOOrderHeader.AllocatedUnits |
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 non-editable text box that is required. It defaults from the 'Sales Order Unit UOM' field on the 'Properties' tab of the Item Record View. It can be edited from the 'Units UOM' field on the Items grid on the Sales Order Record View while the status of the transaction is less than Shipped. A UOM is a quantity used as a standard of measurement. It identifies how much makes up "1" of the measurement. Examples include Bag, Box, Each, Kg, Lb, ext. Database Fields: ERPx_IMUOM.UOMName, ERPx_SOOrderItem.UnitUOMSK |
Weight | Displays the allocated weight to be added or subtracted from the Available balance for the line item. This is a non-editable text box that is not required. It defaults as the weight allocation for the item saved on the transaction, else it defaults to "0.00". This field also defaults to "0.00" if the item's "Manage Item By' property is set to "Units Only". This field is editable from the 'Alloc. Weight' column for the associated inventory lot on the Find Lots Record View or the 'Weight' column for the associated item on the Allocate Sales Transaction Item Record View for the transaction while the status of the transaction is less than Approved. Database Field: ERPx_SOOrderHeader.AllocatedWeight |
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 non-editable text box that is required. It defaults from the 'Sales Order Weight UOM' field on the 'Properties' tab of the Item Record View. It can be edited from the 'Weight UOM' field on the Items grid on the Sales Order Record View while the status of the transaction is less than Shipped. A UOM is a quantity used as a standard of measurement. It identifies how much makes up "1" of the measurement. Examples include Bag, Box, Each, Kg, Lb, ext. Database Fields: ERPx_IMUOM.UOMName, ERPx_SOOrderItem.WeightUOMSK |
Page Details
Toolbar Icons | Description |
---|---|
Add New Line | Takes all item(s) where users have entered allocated units or allocated weight and adds new line item(s) to the transaction, regardless of the existence of an identical item already on the transaction. If the checkbox next to the inventory lot is checked, but no allocated units or allocated weight was entered, then the inventory lot's full available quantities will be allocated. The 'Ord. Units' and 'Ord. Weight' fields will automatically populate from the 'Alloc. Units' and 'Alloc. Weight' fields. Additionally, the 'Price' field will default to "0.00". Note: Users may enter either positive or negative allocations. |
Allocate Existing Line | Replaces any existing allocations and updates the line item with the new allocation amounts, assuming the item and site combination already exists on the transaction. However, if the allocation amounts entered on the Find Lots page for the inventory lot do not match an existing order item and site combination, a new line item will be added to the transaction. If the checkbox next to the inventory lot is checked, but no allocated units or allocated weight was entered, then the inventory lot's full available quantities will be allocated. The 'Ord. Units' and 'Ord. Weight' fields will not be updated when allocations are made to existing line items. Note: Users may enter either positive or negative allocations. |
Column Filter Show/Hide | Toggles between displaying and hiding a filter row in the grid under the column headers. The filter row will be displayed by default if the Quick Column Filter is also implemented in the page. When enabled, this will allow users to type in text to filter by a specific column. |
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, or excluded columns, only the contents in the grid will be exported. |
Group By Show/Hide | Toggles between displaying and hiding a row in the grid above the column headers to enable grouping by one or more column(s). Once displayed, users may drag and drop column headers to group by a specific column. Once the grid is grouped by a column(s), a subtotal footer row will display in the grouping for columns that have a page footer total. |
Help | Opens the online WIKI help page for the current page. |
Quick Column Filter | Used to filter across all columns in the grid. When the user types text into the Quick Column Filter text box, the grid's Filter Row will be automatically hidden. The text in the Quick Column Filter text box automatically replaces any existing Filter Row filters. The results of the data immediately refresh as you enter text. |
Refresh | Re-queries the contents of the grid/page based on the Search Options or the default values for grids that do not support Search Options. This ONLY re-queries the contents of columns that are currently visible, if you add a new column the contents will be empty until you click 'Refresh' again. |
Saved Layouts | Displays the column layout lookup and related icons. This tool allows users to select a previously saved layout, create a new layout, save changes to a layout, forget/delete a layout and/or assign a saved layout as the default for the page. Once changes are made to the layout, such as columns are added or removed, the user can click the Save Layout icon and save the changes to the column layout. The visibility of the Filter Row is also saved with a saved layout. The new layout can also be set as the default. This is useful for creating specific views to separate master files or transaction types (i.e. Invoice specific vs. Credit Memo specific). Default layouts can be removed by clicking the 'Set as Default' button again when the current default layout is selected. Please note that existing saved grid layouts will display the Filter Row as hidden by default. |
Search Options | Toggles between displaying and hiding the Search Options portion of the page. |
View | Displays a drop down menu of options. When an option is selected, it opens in a separate tab. The list of options includes:
|
Fields | Description |
Alloc Units | Displays the number of units allocated for the item on the transaction. This is a numeric textbox that is sometimes required. This field is required and editable only if the item is managed by Units Only or Units or Weight. It defaults as blank may be either a positive or a negative number. This field will allow the user to enter the number of decimals set for the selected item on the 'Unit Decimals' property on the 'Properties' tab of the Item Record View. This field is not stored in the database. If this field is editable, the following will be enforced:
If the 'Stop over allocating for lot tracked items based on' preference is set to "Available and On Hand" on the Preferences page and the allocated Units will draw the inventory lot negative, the message "Allocation for units or weight greater than the available or on hand quantity of a lot tracked item is not allowed" will be displayed when the Add New Line button or Allocated Existing Line button is clicked. Similarly, if the 'Stop over allocating for lot tracked items based on' preference is set to "Available Only" on the Preferences page and the allocated Units will draw the inventory lot negative, the message "Allocation for units or weight greater than the available quantity of a lot tracked item is not allowed" will be displayed when the Add New Line button or Allocated Existing Line button is clicked. Similar error messages will be displayed when the 'Stop over allocating for non lot tracked items based on' preference is set to "Available Only" or "Available and On Hand". |
Alloc Weight | Displays the weight quantity allocated for the item on the transaction. This is a numeric textbox that is sometimes required. This field is required and editable only if the item is managed by Weight Only or Units or Weight. It defaults as blank may be either a positive or a negative number. This field will allow the user to enter the number of decimals set for the selected item on the 'Unit Decimals' property on the 'Properties' tab of the Item Record View. This field is not stored in the database. If this field is editable, the following will be enforced:
If the 'Stop over allocating for lot tracked items based on' preference is set to "Available and On Hand" on the Preferences page and the allocated Units will draw the inventory lot negative, the message "Allocation for units or weight greater than the available or on hand quantity of a lot tracked item is not allowed" will be displayed when the Add New Line button or Allocated Existing Line button is clicked. Similarly, if the 'Stop over allocating for lot tracked items based on' preference is set to "Available Only" on the Preferences page and the allocated Units will draw the inventory lot negative, the message "Allocation for units or weight greater than the available quantity of a lot tracked item is not allowed" will be displayed when the Add New Line button or Allocated Existing Line button is clicked. Similar error messages will be displayed when the 'Stop over allocating for non lot tracked items based on' preference is set to "Available Only" or "Available and On Hand". |
Batch | Identifies the Production Batch ID of the Lot. This is a non-editable text box that is only required if the item's 'Lot Tracked' property is set to "Yes". This value defaults from the 'Production Batch' value specified on the Inventory transaction that created the inventory lot. This can be edited from the 'Production Batch' field on the Properties tab of the Production Batch record view. 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. Database Field: ERPx_IMProductionLot.ProductionLotID |
Item | Identifies the Item, displayed as Item ID: Item Description. This is a non-editable text box that is required. This comes from and can be edited from the 'Item Description' field on the Properties tab of the Item record view. Item IDs are the unique identifier for Items. Database Field: ERPx_IMItem.ItemID:ItemDescription |
Owner | Identifies the Lot Owner of the Inventory Lot. This is a non-editable text box that is required. This defaults from the 'Owner' value specified on the Inventory transaction that created the inventory lot. This is not editable once the transaction has been Saved. 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 Field: ERPx_IMLotOwner.OwnerName |
Site | Identifies the name of the Site the inventory lot is associated with. This is a non-editable text box that is required. This can be updated from the 'Site' field on the 'Home' tab of the Inventory transaction that created the inventory lot. This is not editable after the transaction has been Saved. Sites represent Plants, Warehouses, Distribution Centers, or virtual objects that are used to store and/or maintain perpetual inventory balances. Database Fields: ERPx_MFSite.SiteID, ERPx_MFSite.SiteName, ERPx_SOOrderHeader.SiteSK |
Units | Displays the available units of the item or lot at the corresponding site. This is a non-editable text box that is required. This value may be updated when a transaction with the inventory lot is Posted with unit quantities. This is a calculated field and not stored in the database. |
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 non-editable text box that is sometimes required.This field is required only if the item is managed by Units Only or Units or Weight.This field defaults from and can be edited from the 'Inventory Unit UOM' property on the 'Properties' tab of the Item Record View. A UOM is a quantity used as a standard of measurement. It identifies how much makes up "1" of the measurement. Examples include Bag, Box, Each, Kg, Lb, ext. Database Fields: ERPx_IMUOM.UOMName, ERPx_SOOrderItem.UnitUOMSK |
Weight | This field displays the available weight of the item or lot at the corresponding site. This is a non-editable text box that is required. This value may be updated when a transaction with the inventory lot is Posted with weight quantities.This is a calculated field and not stored in the database. |
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 non-editable text box that is sometimes required. This field is required only if the item is managed by Weight Only or Units or Weight. This field defaults from and can be edited from the 'Inventory Weight UOM' property on the 'Properties' tab of the Item record view. A UOM is a quantity used as a standard of measurement. It identifies how much makes up "1" of the measurement. Examples include Bag, Box, Each, Kg, Lb, ext. Database Fields: ERPx_IMUOM.UOMName, ERPx_SOOrderItem.WeightUOMSK |
WLot | Identifies the Warehouse Lot to which the selected item or inventory lot belongs. This is a non-editable text box that is only required if the item's Site is Warehouse Lot Tracked. This value defaults from the 'Warehouse Lot' value specified on the Inventory transaction that created the Inventory Lot. This can be edited from the 'Warehouse Lot' field on the Warehouse Lots list view. 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. Database Field: ERPx_IMWarehouseLot.WarehouseLotID |