Background:
User needs a saved search to get the locations which have NO Quantity On Hand and NO Quantity On Order so that they can Inactive this location.
Solution:
- Create an Item Search
- Criteria: Standard
- Inventory Location: Inactive
- Criteria: Summary
- Summary Type: Maximum
- Field: Formula (Numeric)
- Description: is 0
- Formula: CASE WHEN {locationquantityonhand}=0 OR {locationquantityonhand} IS NULL THEN 0 ELSE 1 END
- .
- Summary Type: Maximum
- Field: Formula (Numeric)
- Description: is 0
- Formula: CASE WHEN {locationquantityonorder}=0 OR {locationquantityonorder} IS NULL THEN 0 ELSE 1 END
- Results:
- Inventory Location (Group)
- Inventory Location: Inactive (Group)
- Location Available (Maximum)
- Location On Hand (Maximum)
- Location On Order (Maximum)