Scenario
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
Solution
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.