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 subrec = load_inv.createCurrentLineItemSubrecord('inventory', 'inventorydetail');
subrec.selectNewLineItem('inventoryassignment');

 subrec.setCurrentLineItemText('inventoryassignment', 'issueinventorynumber',invnum);
subrec.setCurrentLineItemValue('inventoryassignment', 'binnumber',orgbin);

 subrec.setCurrentLineItemValue('inventoryassignment', 'quantity',onhand);

 subrec.commitLineItem('inventoryassignment');
subrec.commit();

 load_inv.commitLineItem('inventory');

 nlapiSubmitRecord(load_inv, false, true);


Code example for setting Sublist subrecord in 2.0





define([ 'N/record' ],

 function(record) { function afterSubmit(context)

 { // Create the purchase order.

 var rec = record.create({ type: record.Type.PURCHASE_ORDER, isDynamic: true });

 rec.setValue({ fieldId: 'entity', value: '1663' });

 rec.setValue({ fieldId: 'location', value: '6' }); // Create one line in the item sublist. 

rec.selectNewLine({ sublistId: 'item' }); 

rec.setCurrentSublistValue({ sublistId: 'item', fieldId: 'item', value: '299' }); 

rec.setCurrentSublistValue({ sublistId: 'item', fieldId: 'quantity', value: 1 }); 

var subrec = rec.getCurrentSublistSubrecord({ sublistId: 'item', fieldId: 'inventorydetail' }); 
// Add a line to the subrecord's inventory assignment sublist.

 subrec.selectNewLine({ sublistId: 'inventoryassignment' });

 subrec.setCurrentSublistValue({ sublistId: 'inventoryassignment', fieldId: 'quantity', value: 2 }); 

subrec.setCurrentSublistValue({ sublistId: 'inventoryassignment', fieldId: 'receiptinventorynumber', value: '01234' });

 // Save the line in the subrecord's sublist. 

subrec.commitLine({ sublistId: 'inventoryassignment' }); // Save the line in the record's sublist rec.commitLine({ sublistId: 'item' }); 

var recId = rec.save(); // Save the record. 

 var recId = rec.save(); 

} 

Comments

  1. SCApril 30, 2020 at 4:08 AM

    We are NetSuite Solution Provider with vast experience in NetSuite Implementation, netsuite customization including netsuite training & netsuite integration.
    NetSuite Solution Provider
    NetSuite Training
    NetSuite Implementation
    NetSuite Customization
    NetSuite Integration

    ReplyDelete
  2. Akber AlwaniDecember 28, 2021 at 4:47 PM

    Good article, how we can update the existing record
    line.

    ReplyDelete

Post a Comment

Popular posts from this blog

Work Around the 1000 Row Limit Returned by Saved Searches in Netsuite

nlapiSearchRecord can return only upto 1000 rows. But there is a work around to retrieve more than 1000 rows. This can be done by first sorting the result based on internal id and then using while loop and use concat method to get all results by internalid number as a filter inside the while loop. The sample code is given below: var filters = new Array(); filters[1] = new nlobjSearchFilter('mainline',null,'is','T'); var columns = new Array(); columns[0] = new nlobjSearchColumn('internalid').setSort();  //sort the result based on internalid var results = nlapiSearchRecord('transaction',null,filters,columns);  //search record var completeResultSet = results;  //copy the result while(results.length == 1000){  //if there are more than 1000 records      var lastId = results[999].getValue('internalid');  //note the last record retrieved      filters[2] = new nlobjSearchFilter('internalidnumber',null,'greaterthan',lastId);  //cre
Read more

Understand Core Technology behind SuiteScript 2.0

As a netsuite solution provider we want to share, The core of  SuiteScript 2.0 came from the RequireJs and CommonJs background. RequireJS is a JavaScript file and module loader. It is optimized for in-browser use, but it can be used in other JavaScript environment. Using a modular script loader like RequireJS will improve the speed and quality of your code. Commonjs  defines a module format. Unfortunately, it was defined without giving browsers equal footing to other JavaScript environments. Because of that, there are CommonJS specification proposals for Transport formats and an asynchronous require. In NetSuite Customization and netsuite implementation    RequireJS tries to keep with the spirit of CommonJS, with using string names to refer to dependencies, and to avoid modules defining global objects, but still allow coding a module format that works well natively in the browser. RequireJS implements the Asynchronous Module Definition (formerly Transport/C) proposal. D
Read more

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 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-Netsuite-Tra
Read more