htl1 — NetSuite Community

My Stuff

New AI Community Guidelines. Please review and follow them to ensure AI use stays safe, accurate, and compliant.

Update: Narrative Insights has been restored and is now available.

Narrative Insights is Temporarily Unavailable due to an Infrastructure Issue. Learn how This Impacts Your Account and What to Expect While the Feature is Disabled.

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