hi everyone, I am trying to set boolean values on a custom column field associated to an item sublist in a sales order record. I am able to load the record and get any line item values, however when I am trying to set a value to the custom field, its not setting anything or throwing any error. My code that sets the sublist field value looks like this:

soRec.setSublistValue({
     sublistId: 'item',
     fieldId: 'custcol_first_email',
     line: i,
     value: true
});

Is there something that I am missing?

Depending on the context of the script and how the field was created (e.g. scripted or not), I've intermittently had to use string

T

or

F

values instead of boolean `true`/`false`. Not sure if that's the issue here, but it's probably worth a shot at least. If that doesn't fix it, some more context within the script might help pinpoint the problem - what type of script, how you're loading

soRec

, etc.

hi @MTNathan , the field is created in UI. And I tried using

T

or

F

as well as

'T'

or

'F'

. `T`/`F` gave me a reference error, while nothing happened while wrapping those boolean value as a string. Regarding the script, its a map reduce script, and I am loading the

SoRec

like this:

var soRec = record.load({
     type: record.Type.SALES_ORDER,
     id: so_id
});

are you saving the record after?

Line is actually a number, right, not the string

'0'

, this can cause problems. Also assuming didnt mistakenly start indexing at 1 instead of 0?

@Nicholas Klug I tried your recommendation, and initially I wasn't saving the record. Now when I am saving it, I am getting the following error:

{"type":"error.SuiteScriptError","name":"RCRD_HAS_BEEN_CHANGED","message":"Record has been changed","stack":["anonymous(N/serverRecordService)","reduce(/SuiteScripts/test.js:245)"],"cause":{"type":"internal error","code":"RCRD_HAS_BEEN_CHANGED","details":"Record has been changed","userEvent":null,"stackTrace":["anonymous(N/serverRecordService)","reduce(/SuiteScripts/testjs:245)"],"notifyOff":false},"id":"","notifyOff":false,"userFacing":false}

What action is this script running on? If it's a user event, you very likely should be running this in the beforeSubmit

Its a Map Reduce

so, RCRD_HAS_BEEN_CHANGED means that another script or workflow has edited the record you've loaded between the time you loaded it and saved with your M/R script

there is a UE script thats running on the SO on

beforeSubmit

action, however, the two scripts have completely different logics running. I keep on getting the same after running the MR script again

have you checked the scripted record list on SO?

The values do however seem to have changed before setting it in the sublist and after setting it.

I'm not 100% on the location right now because I don't have access to an instance of NetSuite (new company, we're beginning implementation sometime soon), but I think it's customizations > records > scripted records, then go to sales order and see everything in the user event and workflow sublists

there are 2 UE scripts, one runs only on beforeSubmit, and the other one runs on all 3 actions but does not seem to be saving the record

Are you saving the record after you've updated all of the sublist lines? Also, how are you determining which record to load and edit?

I am saving the record at the very end after all actions have been complete. Since its a MR script, I am feeding data via a saved search which determines which SO to load

If you load the saved search, do you have more than one line per Sales Order?

Yeah it sounds like the MR is loading the sames sales order more than once

Yup. Your MR script might be fighting with itself 😂

no the saved search returns one line per SO

Well, unfortunately there's not much more insight I can give from here. This requires a lot of digging around to find a root cause for where the record contention is

I think I found the issue 🙂 So the reduce stage of my SO has a primary if-else condition, I was trying to load and save the SO record in each if-else condition (i know a very bad practice). I updated my code to load the SO before the if-else kicks in and save it after the if-else is done, and now it seems to be working as desired. Thank you guys for your help!

Nice! glad to hear it