<@ULU0070HH> there is a separate field for locatio...
# inventorym
michoel
12/12/2019, 12:11 AM@Reed Dettrich there is a separate field for location quantity on hand -
locationquantityonhandr
Reed Dettrich
12/12/2019, 12:18 AMso should i be using it like this - CASE WHEN {location} = 'FBA' THEN {locationquantityonhand} else 0 END
Reed Dettrich
12/12/2019, 12:19 AMstill manage to get "0" as a result. Thank you for your help on this
m
michoel
12/12/2019, 12:27 AMAre you saying that it is working? Or still not?
k
KevinJ of Kansas
12/12/2019, 1:08 AMTry gong "location on hand" join for your on hand quantity and your criteria
KevinJ of Kansas
12/12/2019, 1:08 AMThat only works as an item search
e
Eric B
12/12/2019, 1:10 PMTry {location} = <numeric id of location>
r
Reed Dettrich
12/12/2019, 5:38 PMSo I needed to use {inventorylocation} = "location name" THEN {locationquantityonhand} . Have it working now. Thanks all!