Hi, trying to make a saved search with criterias l...
# administrationg
george085
12/16/2021, 12:44 AMHi, trying to make a saved search with criterias like location 15's available quantity is less than 10 and location 13's on hand is greater than 0, returns nothing when join with 'AND', need to spark to fix it
george085
12/16/2021, 12:44 AMmessage has been deleted
george085
12/16/2021, 1:03 AMthinking all about case when function
george085
12/17/2021, 2:42 AMHi @battk are you able to help? thank you
b
battk
12/17/2021, 2:56 AMyou need to think in terms of grouping
battk
12/17/2021, 2:57 AMan inventory location cant be both location 15 and location 13