htl1 — NetSuite Community

My Stuff

See All the Unlockable Badges See All the Unlockable Badges

Please note that on Friday, March 20, 2026, at 8:00 PM Pacific time, our Case Management System will undergo a scheduled maintenance for approximately 4 hours. During this time, case creation via SuiteAnswers will be unavailable and inbound calls will be routed to Customer Service.

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

htl1 Newbie

Comments