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='te...
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'); v...
Read more

HOW TO CREATE A FUNCTIONALITY TO PRINT GL IMPACT OF A TRANSACTION IN NETSUITE?

Netsuite provides the functionality to print a transaction but there is no standard functionality to print GL impact of a transaction. To create a new functionality to print GL impact of a transaction, we can make use of scripts. Using user event script, we can create a custom button on transaction. On click of this button a client script will get triggered which will open a suitelet to print the transaction. The code below shows how to create a custom code to print GL impact of an item fulfillment record. 1. First create a client script. This need not be deployed. Note down the script id. Let us assume that script id is "customscript_client_call_suitlet_printgl". 2. Write a User Event script to add a custom button on item fulfillment. Attach the client script created above to trigger it on click of button. function userEventBeforeLoad(type, form, request){ if(type=='view') {          form.setScript('customscript_client_call_suitlet_print...
Read more