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({
                        sublistId: 'item'
                     });
                   
                     for(var i=1;i<=line_count;i++)
               {
             
                       var sub_field1 = load_so.getSublistText({
                        sublistId: 'item',
                        fieldId: 'custcol_sublistfield1',
                        line: i
                    });
                     
               
                     
                       log.debug({
                        title: 'sub_field1',
                        details: sub_field1
                        });
                     
                   
                     
                       if(sub_field1=='test1')
                     
                       {
                     
                   
                     
                                   load_so.setValue({
                                    fieldId: 'custbody_tran_field1',
                                    value: '7',
                                 
                                });
                                   break;
                       }
               }// for i
                   
                     load_so.save();
                   
            }//not delete
     
        }//after submit
        return {
         
            afterSubmit: afterSubmit
        };
    });

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