This site was built to compliment the existing NetSuite Professionals Slack Community by adding a means for members to easily find answers to common questions and to create a searchable database of those questions and answers.

NetSuite Professionals

Hello! If I have the `line` id of a sales order line (not the line number), is it possible to update the line without having to loop through the sublist?

yeah setSublistValue takes the line as a param so you can just use salesOrderRecord.setSublistValue({fieldId: 'yourfieldid', value: 'yourvalue', line: 'yourline'});

but doesn't that take the sequential line number NOT the line id (order line id)?

you want lineuniquekey if you're gonna do that

Even if your know the lineunique key, you will still need to find in your sublist which line that is sequentially

findSublistLineWithValue and using the lineuniquekey is what i'd use.. i guess its sequential behind the scenes

so no, you can't use line as its not unique enough

so do need to loop through the sublist to find that line right?

_&lt;http://.fi|.fi&gt;nd(so.item, l=&gt; l.lineuniquekey = ='theId')

its 2 part if you use findSublistLineWithValue. First get the line using the method and then set the value of whatever line it returns if its valid. YOU do not need to do any looping yourself.