RE: Can I create a saved search to identify available inventory at 2 separate inventory locations in one search?

I need to create a saved search based on criteria at 2 different inventory locations.

Specifically identifying items available greater than or =1 at location 1 and inventory available = 0 at location 2. I am stuck and horrible with expressions

jblickstein Rookie Asked on December 10, 2020 in Saved Searches.
Add Comment
5 Answers

 

not sure how complex your rules are,   hopefully this helps

use a numeric formula on criteria where value =1 ……… when the “when” statements are =1 then  your rules are met.

case when {inventorylocation} like ‘%Quiet%’ and {locationquantityavailable} =0 then 1 when {inventorylocation} like ‘%Beac%’ and {locationquantityavailable} >1 then 1 else 0 end

 

Rookie Answered on December 11, 2020.
Add Comment

Your Answer

By posting your answer, you agree to the privacy policy and terms of service.