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

what is the best way to selectNewLine in a user event script? (aka add new lines)

```        tranRec.selectNewLine({sublistId:'item'});
        tranRec.setCurrentSublistValue({sublistId:'item',fieldId:'item',value:item});
        tranRec.setCurrentSublistValue({sublistId:'item',fieldId:'quantity',value:quantity});
        tranRec.commitLine({sublistId:'item'});```
i have tried clients side like this ^ (problem: does not seem to commit)

```        tranRec.insertLine({sublistId:'item',line: 0});
        tranRec.setSublistValue({sublistId:'item',fieldId:'item',line: 0, value:item});
        tranRec.setSublistValue({sublistId:'item',fieldId:'quantity',line: 0, value:quantity});```
i have tried afterSubmit ^ (problem: line does not get added and there are no error messages)

For client side code, you need to use <https://system.netsuite.com/app/help/helpcenter.nl?fid=section_4637579872.html|forceSyncSourcing> to commit the line after the item is done sourcing

for a before submit user event script, you only need to use setSublistValue on the next available line

you dont need to insert the line unless you actually want to insert a line at the first line

for an after submit user event script, you need to load the record again and save it to make your changes

keep in mind thats its a terrible idea and will double your sales order save times

interesting, ok so I will try client side with forcesyncsourcing on

thanks for the write up <@U5TF1GQ20> very helpful