htl1 — NetSuite Community

My Stuff

Comments

Thank you so much for your help you pointed me in the right direction! I found that your suggestion pulled the total quantity on hand fro all locations. For just one location I used this formula and it worked: CASE WHEN {ITEM.inventorylocation} = 'Texas' THEN {item.locationquantityonhand} ELSE null END

in Saved Transaction Search sublist, need to show on on hand inventory for two specific locations Comment by htl1 Mar 4, 2020 12:49PM
What would be the formal numeric I would put? It does not work on a saved transaction search: CASE WHEN {location} = 'Texas" then {item.quantityonhand} ELSE null END

in Saved Transaction Search sublist, need to show on on hand inventory for two specific locations Comment by htl1 Mar 3, 2020 12:50PM
Thanks for answering, what I need in the transaction saved search is this result: CASE WHEN {inventorylocation} = 'Texas' THEN {locationquantityonhand} ELSE null END However, in transaction saved search inventory location is unaviable, is there a work around?

in Saved Transaction Search sublist, need to show on on hand inventory for two specific locations Comment by htl1 Feb 29, 2020 5:04PM