USING CASE (IF AND ELSE) IN NETSUITE SAVED SEARCH- NETSUITE ACADEMY

USING CASE (IF AND ELSE) IN NETSUITE SAVED SEARCH- NETSUITE ACADEMY

Category : Uncategorized

While creating a saved search in Netsuite, you want encounter a situation where you want have to display a value depending on some conditions. Such scenarios can be implemented by using sql CASE syntax in the formula field. For eg, in a transaction search, if you want to display a value depending on the transaction type, then you can add a formula text field in coulmn and use CASE as given below:

CASE WHEN {type}=’Invoice’ THEN ‘0’
WHEN {type}=’Journal’ THEN {status}
 ELSE ” END

The above field will display 0 when type is Invoice. It will display status of the transaction when type is Journal and for other transaction type, it will be blank.

NETSUITE ACADEMY


Leave a Reply

Reach Us @

Linkedin
Facebook
info@smilingcoders.com
+91 7306857196