- Navigate to Lists > Search > Saved Searches > New > Item.
- On the Criteria subtab, enter specific filters depending on user’s preference.
- On the Results subtab, enter the following:
- Type
- Name
- Description
- Location On Hand
- Location In Transit
- Location On Order
- To sum the Location On Hand, Location In Transit and Location On Order per row, add a Formula (Numeric) on the Results subtab. Formula as follows:
COALESCE({locationquantityonhand}, 0) + COALESCE({locationquantityintransit}, 0) + COALESCE({locationquantityonorder}, 0)
- Hit Save and Run.