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

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

Comments

Post a Comment

Popular posts from this blog

ALERT IN NETSUITE USING USER EVENT BEFORE LOAD SCRIPT

HOW TO THROW ALERT FROM USER EVENT BEFORE LOAD SCRIPT? It is a well known fact that alert can be thrown from client script by directly using alert() method. But lot of times developer needs to use user event script as client script has several limitations like not being able to run as admin. It always runs the script using the logged in user's role. Client script also doesn't get triggered when you view a record. It gets triggered only on edit, create and copy. Alert can be thrown from user event script by using a mix of  html code with Netsuite API. So, first you will to create a custom field of type inline html. Label is not required for this field. This field can be created using form object in the before load function. Then we can set an html alert in that field as default value. The code snippet is given below function UE_BeforeLoad(type, form, request) {             var alert_value = "<html><body><script type='text/javascript'
Read more

HOW TO CREATE SUITELET ASSISTANT IN NETSUITE?

Creating a suitelet assistant involves the following steps: 1)  Create the assistant. 2)  Create steps. 3) Attach client script to validate data on page init, field change, save ( when user clicks on next or finish) or any other trigger function supported by client script. 4)  Build pages for each step. (Get Function) 5) Set values for fields 6) Set up the action when user clicks on next, cancel, back or finish. (Post function) 1) Create the assistant First step is to create assistant by using the api. You can provide name of the assistant under the api parameter. var assist = nlapiCreateAssistant('SUITELET ASSISTANT); 2)  Create steps. Second step is to assign steps to the assistant. You must provide internal id and the name of the step. You can also declare if each step should be completed before proceeding to next one or can be completed randomly.        var step1 = assist.addStep('customstep_step1', 'STEP1'); var step2 = assist.a
Read more

USER EVENT SCRIPT 2.0 TO LOAD A RECORD, READ IT'S VALUE AND SET A FIELD VALUE

Below code loads a sales order, reads it's sublist values and sets value of a custom field. /**  *@NApiVersion 2.x  *@NScriptType UserEventScript  */ define(['N/record','N/log'], // modules used     function(record,log) {             function afterSubmit(context) {             if (context.type !== context.UserEventType.DELETE)             {                                  var rec_id = context.newRecord.id; // get record id                                          log.debug({                       title: 'rec_id',                       details: rec_id                       });                                          var load_so =  record.load({                         type: record.Type.SALES_ORDER,                         id: rec_id,                         isDynamic: false,                     });                                          var line_count = load_so.getLineCount({                         sub
Read more