Trying to set a field on the address subrecord of a customer NetSuite Professionals #suitescript

Trying to set a field on the address subrecord of ...

Nick

01/27/2021, 2:18 PM

Trying to set a field on the address subrecord of a customer in this UE script. What am I missing?

for(var line = 0; line < linecount; line++)

var defaultBilling = scriptContext.newRecord.getSublistValue({'sublistId': addrSublist, 'fieldId':'defaultbilling', 'line': line});

if (defaultBilling == true) {

var objSubRecord = scriptContext.newRecord.getSublistSubrecord({

sublistId: addrSublist,

fieldId: 'addressbookaddress',

line: line

});

objSubRecord.setValue({'fieldId':'custrecord_kes_invoiceemail', 'value': 'test'});

Sciuridae54696d

01/27/2021, 2:26 PM

what's the value of your variable addrSublist?

Nick

01/27/2021, 2:29 PM

addressbook

Sciuridae54696d

01/27/2021, 2:36 PM

I'd check your field ids, I think your code is good

Sciuridae54696d

01/27/2021, 2:37 PM

also try running it on the debugger, scriptContext.newRecord has a funny thing that not all values are there sometimes

Sciuridae54696d

01/27/2021, 2:44 PM

when is this UE run btw, you might need to save the record?

Nick

01/27/2021, 2:47 PM

Thanks @Sciuridae54696d i got it working. It was running in aftersubmit

Sciuridae54696d

01/27/2021, 2:48 PM

ahh ok haha

Sciuridae54696d

01/27/2021, 2:49 PM

Copy code

require(['N/record','N/runtime','N/search','N/format'], function(record,runtime,search,format) {
  try{
    var customerId = 2647;
    var rec = record.load({type:record.Type.CUSTOMER,id:customerId,isDynamic:false});
    var addrSublist = 'addressbook';
    var linecount = rec.getLineCount({sublistId:addrSublist});
    for(var line = 0; line < linecount; line++)
                            {
                                var defaultBilling = rec.getSublistValue({'sublistId': addrSublist, 'fieldId':'defaultbilling', 'line': line});
                                
                                if (defaultBilling == true) {
                                    var objSubRecord = rec.getSublistSubrecord({
                                        sublistId: addrSublist,
                                        fieldId: 'addressbookaddress',
                                        line: line
                                    });
                                    log.debug("success");
                                    
                                    
                                    objSubRecord.setValue({'fieldId':'addr2', 'value': 'test'});
                                    //objSubRecord.save();
                                    
                                }
                            }

                            rec.save();




  var abc = 1;

  } catch (e) {
    var scriptId = runtime.getCurrentScript().id;
    log.error('ERROR:'+scriptId+':fn:'+runtime.ContextType, JSON.stringify(e));
  }
});

was sure this ran fine for me on my debugger so your code was good, probably execution context problems!

stalbert

01/27/2021, 2:54 PM

another way to write this sort of code

🤯 2

👍 1

👀 2

Nick

01/27/2021, 3:09 PM

cool, thanks @stalbert

Watz

01/27/2021, 3:49 PM

@stalbert with NFT, that is?

stalbert

01/27/2021, 3:59 PM

alas, yes.

Watz

01/27/2021, 4:00 PM

I've never got around to try it out... do you use it in every script you create?

stalbert

01/27/2021, 4:02 PM

yup. It generally results in about half the lines of code and easier to understand so it's hard not to use it.

stalbert

01/27/2021, 4:08 PM

the above code snippet is actually the more complex (aka more 'functional') version. You could also skip the

.filter

and use

.find

to get the default billing then operate on that.

4 Views

Open in Slack

Previous Next