Hello, is it possible to update a sublist line directly with a scheduled script? I am trying the following and it is not saving the field. try { var soRecord = record.load({ type: record.Type.SALES_ORDER, id: appliedtointernalid.value }); var abc=soRecord.setSublistValue({ sublistId: 'item', fieldId: 'custcol_pi_projectforsoline', line: linenum, value: jobtoset.value }); var recId= soRecord.save(); }catch(e){ log.debug('WO '+ WOID, e.toString()); } log.debug('WO '+ recId +' is updated');

the code by itself looks fine, you probably want to make sure that all the variables have valid values

thanks. can you go directly to the specific sublist line with a script?

Not sure what you mean by that

got it. what I mean is that I go directly to the transaction with my script and edit the specific line without doing the loop through all the items. I got the line number directly from a saved search

the code you shared has no loops

thanks. I'll try it out tomorrow

i think you should be careful with the line number, and make sure whatever value you retrieved from your search (no detail was provided) you are hitting the correct/expected line. This line number is a sequenced line as opposed to Line ID or Line Unique Key. And it is 0-based. So, I am not sure you can get to it in search. You will probably need to find the right line by looping through or calling findSublistLineWithValue

it looks like I am able to set the correct line by doing the following var linenum = searchResult.values["GROUP(linesequencenumber.appliedToTransaction)"]-1;

Wow great - glad to help