Scenario
To display the On Hand quantity per location, user needs to add the following columns to an item search: Inventory Location and Location On Hand. However, this will be displayed as multiple rows per location. User would like to view the Location On hand per column.
Solution
To create an Item search which displays Location Quantity On Hand on separate columns, please follow the steps below:
1. Navigate to Lists > Search > Saved Searches > New > Item
2. Under the Results tab > Columns sub tab, add the following:
Note: Replace “Location A” with the actual name of the inventory location.
3. Assign a name and click Save