My Stuff
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
-
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
-
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?