I am trying to create an Item Saved Search that lets us know if an items available inventory quantity has dropped below a set quantity at one location, and it's available inventory quantity is above a set quantity at another location.
I see results when I specify the following criteria:
Inventory Location: is Location A
Location Available: is less than 5
However, when using expressions to add the criteria regarding the second location, I have been unsuccessful.
It seems like the Criteria should be this:
(Inventory Location: is Location A And
Location Available: is less than 5) And
(Inventory Location: is Location B And
Location Available: is greater than 5)
There are items that fit the criteria of having less than 5 available in Location A, and greater than 5 available in Location B
What am I missing?
As a secondary question, it would be great to be able to show the item's available quantity at each location in the results, but I am not sure that is possible, or am I wrong?