Discussions
Read on for the latest updates including:
• Agenda Builder launch
• SuiteWorld On Air registration
• New NetSuite Prompt Studio Contest
• And more!
Check out this thread to learn more!
Saved Transaction Search sublist, need to show on on hand inventory for two specific locations
Is there a formula I could use to show one column with on hand inventory in 'Texas', and one column to show on hand inventory in 'Mexico'
I have searched in suite answers but I have not found a solution.
My first guess for column 1 is:
Formula Numeric = CASE WHEN {item.location} = 'Texas' THEN {item.locationquantityonhand} ELSE null END
My first guess for Column 2 is:
CASE WHEN {item.location} = 'Mexico' THEN {item.locationquantityonhand} ELSE null END
But that does not work. any suggestions would be greatly appreciated.