htl1 — NetSuite Community

My Stuff

See All the Unlockable Badges See All the Unlockable Badges

Nominate Your Peers for NetSuite Support Community's Choice of the Quarter! Submit your nomination today.

Intelligent Payment Automation version 1.0.3 is now available in the SuiteApp Marketplace. The SuiteApp, powered by BILL, lets you automate payments, manage vendor details, and bank account information within NetSuite. Learn more

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