/
Item Balances Inquiry List View

Item Balances Inquiry List View

The Item Balances List View displays item balances summarized by Site. 

 This list view also contains columns for each Attribute that is set up for the 'Items' attribute type. Because these are user defined, they are not included in the default view but can be added a saved column layout. Item attributes are not included in the help documentation.

Software Version: 2026.06.17 and newer

[ 1 Page Header ] [ 1.1 Search ] [ 2 Page Detail ] [ 2.1 Related Topics ] [ 2.1.1 Page Definitions ] [ 2.1.2 Technical Details ]

Page Header

Search

Search Options

Description

Search Options

Description

Auto Hide Filters

Auto Refresh on Open

Group By Owner

Identifies whether item balances will be summarized by Lot Owner. This is a Yes/No lookup that is required and it defaults to "Yes".

  • When set to "Yes", Item balances will be summarized by unique combination of Item+Site+Owner and the 'Owner' column will display the Lot Owner.

  • When set to "No", Item balances will be summarized by unique combination of Item+Site and the 'Owner' column will be blank.

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.

Item

 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. 

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

Item Class

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. 

The lookup contains a list of all Item Classes.

Lot Owner

 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.

The lookup contains a list of all Owners.

Search

 

  • 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)

Site

 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. 

The lookup contains a list of all active Sites.

Saved Searches

Page Detail

Toolbar Icons

Description

Toolbar Icons

Description

Column Filter Show/Hide

Excel

Favorites

Group By Show/Hide

Help

More Actions

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

Quick Column Filter

Refresh

Saved Layouts

 

Search Options

Fields

Description

Allocated (+)

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

Allocated (-)

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

Available

 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.

Committed (+)

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

Committed (-)

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

Cost Amount

Displays the extended cost amount for the Lot.  This is calculated as Cost Quantity * Cost Rate.

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

Cost Quantity

Database Field: ERPx_IMLotBalance.CostQuantity

Cost Rate

Database Field: ERPx_IMLotBalance.ActualCost

Cost UOM

Database Field: ERPx_IMItem.CostUOMSK

Item Class

Identifies the class the Item is assigned to. This is displayed as Item Class ID: Item Class Description. required and can always be edited from the 'Item Class Description' field on the 'Properties' tab of the Item Record View.

Database Fields: ERPx_IMItemClass.ClassID, ERPx_IMItemClass.Description

Item Description

Identifies the Description of the Item. This comes from and be edited from the 'Item Description' field on the 'Properties' tab of the Item record view.

Database Field: ERPX_IMItem.ItemDescription

Item ID

Identifies the unique identifier of the Item. This comes from and be edited from the 'Item ID' field on the 'Properties' tab of the Item record view.

Database Field: ERPX_IMItem.ItemID

Item: Description

This comes from and can be edited from the ‘Item ID’ and 'Item Description' fields on the 'Properties' tab of the Item record view.

Database Fields: ERPX_IMItem.ItemID, ERPX_IMItem.ItemDescription

Lot Tracked

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

Market Amount

Identifies the extended Market amount for the Lot.  This is calculated as Cost Quantity * Market Rate and is not editable. 

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

Market Rate

 If an item has multiple lots with different costs, the most recent cost will be displayed. 

Database Field: ERPx_IMLotBalance.MarketCost

On Hand

This can be edited when units or weight for an item on an inventory transaction has been Posted or units or weight for an allocated item on a sales order has been Posted. This is a calculated field and not stored in the database.

Note: For companies that want unposted Sales Orders to update the On Hand balances as soon as they are marked as Shipped, they can set the "Include Shipped & Approved Sales Orders in On Hand balances" Inventory Preference to "Yes".

On Hold (-)

When a lot is placed On Hold, the On Hold balance is taken from the Available balance. The On Hold balance is increased by the entire lot's On Hand balance (not the item's On Hand balance). The On Hold balance is decreased when the lot is removed from on hold and the amount is added back to the Available balance. This is a calculated field and not stored in the database.

Owner

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

Database Field: ERPx_IMLotOwner.OwnerName

Quoted (-)

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.

Site ID

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.

Database Fields: ERPx_MFSite.SiteID, ERPx_IMLotBalance.SiteSK

Site Name

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.

Database Fields: ERPx_MFSite.SiteName, ERPx_IMLotBalance.SiteSK

Units - Avail.

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.

Units - On Hand

 This can be updated when units for an item on an inventory transaction has been Posted or units for an allocated item on a sales order has been Posted. This is a calculated field and not stored in the database.

Note: For companies that want unposted Sales Orders to update the On Hand balances as soon as they are marked as Shipped, they can set the "Include Shipped & Approved Sales Orders in On Hand balances" Inventory Preference to "Yes".

Unit UOM

 This field comes from and can be edited from the 'Inventory Unit UOM' property on the 'Properties' tab of the Item record view.

Database Field: ERPX_IMItem.DefaultIMUnitUOMSK

UOM

This field comes from and can be edited from the 'Default Reporting UOM' property on the 'Properties' tab of the Item record view.

Database Field: ERPX_IMItem.DefaultIMUnitUOMSK or ERPX_IMItem.DefaultIMWeightUOMSK

UOM Schedule

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

Weight - Avail.

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.

Weight - On Hand

 This can be updated when weight for an item on an inventory transaction has been Posted or weight for an allocated item on a sales order has been Posted. This is a calculated field and not stored in the database.

Note: For companies that want unposted Sales Orders to update the On Hand balances as soon as they are marked as Shipped, they can set the "Include Shipped & Approved Sales Orders in On Hand balances" Inventory Preference to "Yes".

Weight UOM

This field comes from and can be edited from the 'Inventory Weight UOM' property on the 'Properties' tab of the Item record view.

Database Field: ERPX_IMItem.DefaultIMWeightUOMSK