I am trying to get the values from "quantity on hand" on item records. But i cant seem to get the right values. I need 1 line with quanity on hand = 1 and the next one where it equals = 3: But it seems like that i can only get the total amount of quantity on hand from all the locations. I even tried to set the criteria for subsidiray and location, so that the search would not count other quantitys from different locations/subsidiariesbut without any luck. Does anybody have an idea on how i could solve this problem?

Everything from the location table starts with the word

Location

in the Saved Search UI, like

Location Quantity On Hand

will you give the value from that table