To create an Item Saved Search that will show the Locations under the item record and will also show the Quantity on Hand and Value per Location
1. Navigate to Reports > Saved Searches > All Saved Searches > New.
2. Select Item.
3. Edit the Name of the search.
4. Under Criteria tab, enter:
--Location On Hand = is greater than 0
--Location Total Value = is greater than 0
--Inventory Location = is (select your preferred locations)
5. Under Results tab, select:
--Name (Summary Type : Group)
--Type (Summary Type : Group)
--Inventory Location (Summary Type : Group)
--Location On Hand (Summary Type : Maximum)
--Location Total Value (Summary Type : Maximum)
6. Hit Save & Run.