Hi Guys, how to get quantityOnHand form the inventory location i don't want to use locationquantityavailable in save search because whenever i used the locationquantityavailbale it creates two line of single items

Creating a line for every location is expected. If you need all locations in a single line, then yes a formula is needed.

Might post in #C2A1ZEMF0