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


Email : info@smilingcoders.com
Below code loads a sales order, reads it's sublist values and sets value of a custom field.
Email : info@smilingcoders.com
/**
 *@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
        };
    });
Email : info@smilingcoders.com

Comments

Post a Comment

Popular posts from this blog

Calling User Event Script from another User Event

Image
As a netsuite solution provider User event scripts are executed on the NetSuite server. They are executed when users perform certain actions on records, such as create, load, update, copy, delete, or submit. Most standard NetSuite records and custom record types support user event scripts. The Most important thing is User event scripts cannot be executed by other user event scripts or by workflows with a Context of User Event Script. In other words for netsuite customizatio n, you cannot chain user event scripts. You can execute a user event script from a call within a scheduled script, a portlet script, or a Suitelet. I will help you to show how User event can be called from another User event Script using Suitelet. As we all know we cannot chain User event. Work around to this is to create a Suitelet that has the same logic as that of first User Event Script. Consider the use case given below: In NetSuite Implementation Create or edit an Inbound Shipment record and upon s...
Read more

Understanding SuiteScript 2.0

As a NetSuite solution provider we want to share that netsuite is expanding its footprints very rapidly with new and latest technology implementation in the backend and frontend to improve the user experience. Netsuite Implementation partner and netsuite solution provider needs to take care of some important things about the technology which NetSuite is using, as after the release of SuiteScrip 2.0 NetSuite is more flexible and customizable. Following are some of the things we need to understand before going deep into netsuite customization suitescript 2.0: 1) Why SuiteScript 2.0? Optimized performance, Code in modular structure which is easy to debug in modules and enhance the functionality with performance. Using a modular script loader like RequireJS will improve the speed and quality of your code. 2) Is SuiteScript 1.0 sufficient? The SuiteScript 1.0 is based on native JavaScript but it is not able to utilize the benefits of new libraries and framework which a...
Read more

HOW TO SET SUBLIST SUB RECORD VALUES IN SUITE SCRIPT 1.0 AND 2.0

Subrecord values are retrieved and set in different ways in 1.0 and 2.0. Below examples can be used to understand the difference. Code example for setting Sublist subrecord in 1.0.  Note some variable have not been defined. Define them as per your accounts requirements                       var load_inv = nlapiCreateRecord('inventoryadjustment', {recordmode: 'dynamic'}); load_inv.setFieldValue('account', '1019'); load_inv.setFieldValue('adjlocation', 106); load_inv.setFieldText('custbody_cp_transaction', 'Coating zero parent '); load_inv.setFieldValue('custbody_c_from', recid); load_inv.selectNewLineItem('inventory'); load_inv.setCurrentLineItemValue('inventory', 'item', invadjitm); load_inv.setCurrentLineItemValue('inventory', 'location', 106); load_inv.setCurrentLineItemValue('inventory', 'adjustqtyby', 1); var su...
Read more