Item Saved Search to find Items with Negative Inventory in any Location

Create an item saved search

Criteria :
Type – Inventory Item
Location on Hand – less than zero

Results:
Name
Display Name
Location On Hand
Inventory Location fields (Join field) – Name

Note: The “On Hand” and “available” result fields will show the sum of the Quantity from all locations. To get the quantity of each location, we should select “Location on Hand” or “Location Available”