Does anybody know if I can set a sum of the availa...
# general
j
Does anybody know if I can set a sum of the available inventory of several locations as a criteria of a search result? For instance, if I only want to return items that have 0 inventory in Location A, B and C. I’m assuming this would have to be some kind of formula?
s
inventorylocation anyof A,B,C
AND
locationonhand lessthanorequalto 0
, if you group them with parens that should get that specific criteria
if you wanted to add all those together, you can probably just ad d a sum to locationonhand, might get a little funky though