ANS-0303 · INVENTORY & ITEM MANAGEMENT
How to Display Item Inventory Quantities by Location in NetSuite Searches
Learn to configure a NetSuite saved search to accurately report on item quantities available or on hand at each specific inventory location.
Short answer
To display item inventory by location in NetSuite, configure a saved search. Include 'Inventory Location Join' (`{inventorylocation.name}`), 'Location On Hand' or 'Location Available' (`{locationquantityonhand}`), and 'Item Name' (`{Name}`). This setup provides a distinct line for each location, detailing its specific item quantity.
Scenario
Users often need to view a detailed breakdown of item inventory across various locations within NetSuite. The challenge is to configure a saved search that clearly presents the quantity of a specific item available or on hand at each individual inventory location, rather than just a consolidated total.
Solution
To achieve a detailed view of item inventory by location in NetSuite, a saved search must be configured with the following columns:
Inventory Location Join with field name
{inventorylocation.name}Location On Hand or Location Available field
{locationquantityonhand}Item Name
{Name}This configuration will produce results where each line represents a specific location, displaying the corresponding quantity for the item at that location.
Expert NetSuite Support
Need help with this NetSuite issue?
Inventory & Item Management consulting and configuration support