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 "Products with Any Balance". The options available include:

• Products with Any Balance - Returns all Items with a non zero amount for the following columns: On Hand, On Hold, Committed Positive, Committed Negative, Quoted Negative, Allocated Positive, Allocated Negative, Available.
• Products with Available Balance - Returns all Items with an Available Balance (a non zero positive or negative available balance)
• Products with No Balance - Returns only items with no On Hand and no Available Balances

This lookup contains the values in the IncludeInItemBalance Enumeration Class.

Used to select one or more Items. This is a multi-select lookup that defaults to blank and is not required. If one or more Items are selected, the data returned will only include the selected Items. If blank, then no Items will be excluded. 

Identifies the Item, displayed as Item ID: Item Description.

The lookup contains a list of all Items in the Items master file.

Used to select one or more Item Classes. This is a multi-select lookup that defaults to blank and is not required. If one or more Item Classes are selected, the data returned will only include the selected Item Classes. If blank, then no Item Classes will be excluded. 

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.

Used to select one or more inventory Owners. This is a multi-select lookup that defaults as blank and is not required. If one or more Owners are selected, the data returned will only include the selected Owners. If blank, then no Owners will be excluded.

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

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: 

• Attr: [Attribute Value] (columns are not displayed by default in the grid, but may still be searched on)
  
• Item: [Item ID] or [Item Description]
  
• Owner: [Lot Owner] (column is not displayed by default in the grid, but may still be searched on)
• Batch: [Production Batch] (column is not visible in the grid, but may still be searched on)
• Site: [Site ID] or [Site Name]
  
• WLot: [Warehouse Lot] (column is not visible in the grid, but may still be searched on)

Used to select one or more Sites. This is a multi-select lookup that defaults to blank and is not required. If one or more Sites are selected, the data returned will only include the selected Sites. If blank, then no Sites will be excluded. 

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

 Displays a drop down menu of related actions. The list of options includes:

• IQ: Item History: Opens the Transaction History - Item Inquiry and displays the history of posted transactions at the item level for the selected item(s). The date range defaults to the past 30 days and if a beginning balance exists outside of the date range, a row will display the beginning balance quantity.
• IQ: Lot History: Opens the Transaction History - Lot Inquiry and displays the history of posted transactions at the inventory lot level for the selected item(s). The date range defaults to the past 30 days and if a beginning balance exists outside of the date range, a row will display the beginning balance quantity.
• LV: Commitments and Allocations: Opens the Commitments and Allocations Inquiry and displays the quantities on unposted transactions for the selected item(s).
• LV: Lot Balance: Opens the Lot Balances List View and displays the inventory lot level balances for the selected item.
• RV: Item: Opens the Item Master File Record View for the selected item.

 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.

Displays the Actual Cost assigned to the item or lot. If an item has multiple lots with different costs, the most recent cost will be displayed. 

The Actual Cost reflects the cost that will post to the General Ledger for Items with a 'Costing Method' of "Active". For some items this may be set from a default or "standard" cost rate and for other items this may reflect that actual amount paid to purchase or incurred to produce the product. For each individual LotSK, this is calculated as the [Actual Base Cost Rate] + sum of all the [Actual Cost Layer Rates]. 

Database Field: ERPx_IMItem.CurrentCost

Displays the allocated quantity to be added to the Available balance for an Inventory Lot or Item. This is a calculated field and not stored in the database.

The Allocated (+) balance is the quantity, that has been allocated, on an open transaction containing incoming product. The Allocated (+) balance increases the Available balance. Unlike Committed (+) which represents "requested" balances, Allocated (+) represents "assigned" balances. For example, a Customer may order 15 Cases and only be shipped 10. The 10 Cases would signify what was actually shipped. The Allocated (+) balance is comprised of:

• Inventory transactions where the quantity of a Lot Tracked line item where the item has been saved with a Production Batch and/or Warehouse Lot (if the Site is Warehouse Lot tracked). For example, if 10 Cases were entered on a Receipt line item and either the Production Batch or Warehouse Lot was assigned, the Allocated (+) balance for that transaction would be 10.
• Production Orders where the quantity of an Output line item has been saved without a Production Batch and/or Warehouse Lot (if the Site is Warehouse Lot tracked). For example, if 10 Cases were entered on the transaction and either the Production Batch or Warehouse Lot was unassigned, the Allocated (+) balance for that transaction would be 10.
• Sales Returns where the line item has an allocated quantity.

Note: each of the Inventory Transactions can be conditionally included/excluded from the Allocated balances based on the "Include open ### transactions in Available balances" Inventory Preference. If the preference are set to "Yes", they will be included in Allocated balances and used to update the Available balances, if they are set to "No", they will not be included in Allocated so they will not update Available balances.

Additionally, for Production Order Outputs, these can be conditionally included/excluded from the Allocated balances based on the "First status to include Production Order Outputs in Available balances" Inventory Preference. If the transaction is set to a status equal to or greater than the Preference value, and is not in a status of Closed and not set to "Do Not Include", it will be included in Allocated balances and used to update the Available balances, otherwise if the status is set to a value less than the Preference value, it will not be included in Allocated so they will not update Available balances. 

Displays the available balance of an item or Inventory Lot, stated in terms of the Item's "Reporting UOM". If the Item' Reporting UOM is "Lbs" then this would represent the Available Lbs. If the Item' Reporting UOM is "Case" then this would represent the Available Cases. This can be edited when units or weight for an item on an inventory transaction has been entered or units or weight for an item on a sales order has been committed or allocated. This is a calculated field and not stored in the database. The Available balance is calculated as:

[On Hand] - [On Hold (-)] + [Committed (+)] - [Committed (-)] + [Allocated (+)]- [Allocated (-)] - [Quoted (-)]

Note: Each of the Inventory Transactions and Sales Quote transactions can be conditionally included/excluded from the Available balances based on the "Include open ### transactions in Available balances" Inventory Preference. If the preference is set to "Yes", Inventory Transactions will be included in Committed and Allocated balances, and Quotes will be included in the Quoted balances and used to update the Available balances. If they are set to "No", they will not be included in Committed, Allocated and Quoted balances, so they will not update Available balances.

Additionally, for Production Order Outputs/Inputs and unreceived Purchase Order quantities, these can be conditionally included/excluded from the Available balances based on the "First status to include ##### in Available balances" Inventory Preferences. If the transaction is set to a status equal to or greater than the Preference value, and is not in a status of Closed and not set to "Do Not Include", they will be used to update the Available balances, otherwise if the status is set to a value less than the Preference value, they will not be used to update Available balances.

Displays the requested quantity to be added to the Available balance for an Inventory Lot or Item. This is a calculated field and not stored in the database.

The Committed (+) balance is the ordered (requested) quantity, that has not yet been allocated, on an open transaction containing incoming product. The Committed (+) balance increases the Available balance. The Committed (+) balance is comprised of:

• Inventory transactions where the quantity of a line item has been saved without a Production Batch and/or Warehouse Lot (if the Site is Warehouse Lot tracked). For example, if 10 Cases were entered on a Receipt line item and either the Production Batch or Warehouse Lot was unassigned, the Committed (+) balance for that transaction would be 10.
• Open Production Orders where the quantity of an Output line item has been saved without a Production Batch and/or Warehouse Lot (if the Site is Warehouse Lot tracked). For example, if 10 Cases were entered on the transaction and either the Production Batch or Warehouse Lot was unassigned, the Committed (+) balance for that transaction would be 10.
• Open Purchase Orders where the quantity of an inventory item has been saved and not yet received (on a Posted Receipt transaction). For example, if the inventory item on the Purchase Order is for 100lbs and has not yet been received, the Committed (+) balance for that item would be 100lbs.  If a Receipt is then Posted with 60lbs of that item, the Committed (+) balance would be 40lbs. 
• Sales Returns: Items on Sales Order Shipments, where the Requested Returned quantity is greater than the Allocated quantity. When this occurs, it is calculated as [Requested] - [Allocated]. For example, if 15 Cases were being returned and 3 have been allocated, the Committed (+) balance would be 12. Note, this amount cannot be negative. For example, if there were 5 Cases requested for return and 7 Allocated, the Committed (+) balance would be 0 not -2.

Note: Each of the Inventory Transactions can be conditionally included/excluded from the Committed balances based on the "Include open ### transactions in Available balances" Inventory Preference. If the preference are set to "Yes", they will be included in Committed balances and used to update the Available balances, if they are set to "No", they will not be included in Committed so they will not update Available balances.

Additionally, for Production Order Outputs and unreceived Purchase Order quantities, these can be conditionally included/excluded from the Committed balances based on the "First status to include ##### in Available balances" Inventory Preferences. If the transaction is set to a status equal to or greater than the Preference value, and is not in a status of Closed and not set to "Do Not Include", they will be included in Committed balances and used to update the Available balances, otherwise if the status is set to a value less than the Preference value, they will not be included in Committed so they will not update Available balances. 

Identifies the Item, displayed as Item ID: Item Description. This comes from and can be edited from the 'Item Description' field on the 'Properties' tab of the Item record view.

Database Field: ERPX_IMItem.ItemID, ERPX_IMItem.ItemDescription

Identifies whether or not item balances are maintained for "Production Batches". This comes from the 'Lot Tracked' property on the 'Properties' tab of the Item record view. This field is not editable.

Database Field: ERPX_IMItem.TrackMethodEN

Displays the Market Cost assigned to the item or lot. This is the Market base cost when the the Source is Base and Market layer cost when the source is Layer. If an item has multiple lots with different costs, the most recent cost will be displayed. 

The Market Cost reflects the estimated "market" value for the inventory. Market Costs are typically set by taking Actual costs and adding additional components such as delivered freight, brokerage/rebate amounts, and desired profit margin. For each individual LotSK, this is calculated as the [Market Base Cost Rate] + sum of all the [Market Cost Layer Rates]. 

Market Costs are typically maintained in companies where costs and/or margin needs to be shown/used in Sales Order based on the current market value of the item, not the Actual costs.

Database Field: ERPx_IMItem.MarketCost

Identifies a the Lot Owner for a line item. This comes from the 'Owner' field for a line item on the Items grid on an Inventory transaction. This is not editable.

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.

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.

Database Field: ERPx_IMLotOwner.OwnerName

Displays the requested quantity to be subtracted from the Available balance for an Inventory Lot or Item. This is a calculated field and not stored in the database.

The Quoted (-) balance is the ordered (requested) quantity, that has not yet been allocated, on an open Quote transaction containing outgoing product. The Quoted (-) balance reduces the Available balance if the “Include Quote transactions in Available balances” preference is set to “Yes”.  Once Quote transactions are saved as Approved (and therefore converted to a Sales Order), the Quoted (-) quantity for the corresponding item/lot will be blank and will be displayed in the Committed (-) column.

Note: Each Quote Transaction can be conditionally included/excluded from the Quoted balance based on the "Include Quote transactions in Available balances" Inventory Preference. If the preference are set to "Yes", they will be included in Quoted balances and used to update the Available balances, if they are set to "No", they will not be included in Quoted so they will not update Available balances.

Identifies the unique Site ID (warehouse ID) of the Site the transaction, shipment, item, or lot is associated with. This defaults from the 'Site' field on the 'Home' tab of the Inventory transaction or the 'Default Site' field on the 'Home' tab of the sales order transaction. This field 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_IMLotBalance.SiteSK

Identifies the name of the Site (Warehouse) that the transaction, shipment, receipt, item, or lot is associated with. This field defaults from the 'Site' field on the 'Home' tab of the Inventory transaction or the 'Default Site' field on the 'Home' tab of the sales order transaction. This field is not editable after the transaction has been Saved.

Displays the available units of the item or lot at the corresponding site. This can be edited when units for an item on an inventory transaction has been entered or units for an item on a sales transaction have been committed, allocated or quoted. The Available Units balance is calculated as [On Hand Units] - [On Hold] - [Committed] - [Allocated] - [Quoted] + any balances from open transactions. This is a calculated field and not stored in the database.

Identifies the default inventory unit of measure that the units are stored in (boxes, Bags, Cases, Totes, etc.) for the item. This field comes 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 Field: ERPX_IMItem.DefaultIMUnitUOMSK

Identifies the UOM Schedule that is used to determine what Units of Measure are to be used for specific items that are bought, sold and manufactured as well as the conversions for those Units of Measure.
This field comes from and can be edited from the 'UOM Schedule' property on the 'Properties' tab of the Item record view.

Database Field: ERPX_IMItem.UOMScheduleSK

This field displays the available weight of the item or lot at the corresponding site. This can be edited when weight for an item on an inventory transaction has been entered or weight for an item on a sales order have been committed, allocated or quoted. The Available Weight balance is calculated as [On Hand Weight] - [On Hold] - [Committed] - [Allocated] - [Quoted]+ any balances from open transactions. This is a calculated field and not stored in the database.

Identifies the default inventory unit of measure that the weight is stored in (Lbs, Kg, Oz, Ton, etc.) for the item. This field comes 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 Field: ERPX_IMItem.DefaultIMWeightUOMSK