Create an Item Search Which Displays Location Quantity On Hand on Separate Columns

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.

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:

Field	Summary Type	Formula	Custom Label	Summary Label
Name	Group
Formula (Text)	Minimum	CASE WHEN {inventorylocation} = 'Location A' THEN {locationquantityonhand} ELSE null END	Location A	Location A
Formula (Text)	Minimum	CASE WHEN {inventorylocation} = 'Location B' THEN {locationquantityonhand} ELSE null END	Location B	Location B
Formula (Text)	Minimum	CASE WHEN {inventorylocation} = 'Location C' THEN {locationquantityonhand} ELSE null END	Location C	Location C
Formula (Text)	Minimum	CASE WHEN {inventorylocation} = 'Location D' THEN {locationquantityonhand} ELSE null END	Location D	Location D

Note: Replace "Location A" with the actual name of the inventory location.

3. Give it a name and save