https://netsuiteprofessionals.com logo
Title
c

Casey L

07/08/2021, 8:43 PM
any idea on how to pull an Item’s available inventory at a specific location using Formula search? I am trying to pull each location’s available quantity into different columns instead of having it make new lines for every location on an item search
r

Richard Liu

07/08/2021, 8:47 PM
We use formula of
CASE WHEN {inventorylocation} = 'LOCATION' THEN {locationquantityonhand} ELSE 0 END
And Group by item name/item id and set this formula column as MAX
c

Casey L

07/08/2021, 8:51 PM
ah the grouping is what got me. that will do it. thanks!
🙌 1