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 Feel free to reach out TheSmilingCoders for proper netsuite implementation , netsuite consultation , netsuite customization , netsuite Support , netsuite Training contact us at: Email : info@smilingcoders.com Facebook : https://www.facebook.com/Smiling-Coders-...
Comments
Post a Comment