This site was built to compliment the existing NetSuite Professionals Slack Community by adding a means for members to easily find answers to common questions and to create a searchable database of those questions and answers.

NetSuite Professionals

I am creating a Saved Search to get the Inventory On Hand for a specific location, but all the quantities I get are the sum of all locations despite selecting the Location in the criteria. Any clue?

you have to use the location on hand joins for that.

all joins in searches are left outer joins - meaning you get a response for all locations for all location on hand fields - so you need a  location on hand criteria to filter your results down appropriately

also use "Location Available" vs. "Available"

Thanks <@UER9Q3SGM> "location on hand joins" what do you mean? Is it a field on the  Criteria tab?

There is a field call `Location On Hand`, that gives you a location on hand for a location.  Everything you see in that location table at the bottom of the item record that is retrievable is liek `Location On Hand` or `Location Available` , etc

If you have many locations, you will see a line for each location, you can restrict this by adding `Inventory Location` to your criteria