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

Can anyone help me figure out why the setsublistvalue isn’t working here? Thanks. Code in the replies.

`/**`
 `* @NApiVersion 2.x`
 `* @NScriptType UserEventScript`
 `* @NModuleScope SameAccount`
 `*/`
 `define(['N/record', 'N/log'],`
 `function(record, log) {`
     `function beforeLoad(context) {`
         `try {`
             `if (context.type === context.UserEventType.CREATE) {`
                 `var newVendorBill = context.newRecord;`

                     `var headerFinLoc = newVendorBill.getValue({`
                         `fieldId: 'cseg1'`
                     `});`

                     `log.debug('headerFinLoc: ', headerFinLoc);`

                     `var vendorBillLinesCount = newVendorBill.getLineCount({`
                         `sublistId: 'item'`
                     `});`

                     `log.debug('vendorBillLinesCount: ', vendorBillLinesCount);`

                     `for (var i = 0; i &lt; vendorBillLinesCount; i++) {`
                        `newVendorBill.setSublistValue({`
                             `sublistId: 'item',`
                             `fieldId: 'cseg1',`
                             `line: i,`
                             `value: headerFinLoc`
                         `});`
                     `}`
                 `}`
         `} catch (e) {`
             `log.error({`
                 `title: 'Error',`
                 `details: e`
             `});`
         `}`
     `}`

     `return {`
         `beforeLoad: beforeLoad`
     `};`
 `});`

You have no lines on a new record. So the line count is zero and your for-loop never runs.

The Vendor Bill is being created from the PO. So there are lines upon creation. The no. of lines is also being logged correctly.

i would say try the following options
1. try setting it dynamicall using selectLine and setCurrentSublistValue and then commitline 
2. instead of a user event to achieve this i would typically try this in a Client side script unless this need for other non UI Context ( For other UI context try doing this logic in the beforesubmit may be ) 

image.png

he's not creating the record in the script, i see no record.create ?

I interpreted that line as it was OK to do manipulations in the context CREATE 

See example here. <https://docs.oracle.com/en/cloud/saas/netsuite/ns-online-help/section_4387799721.html#bridgehead_4485602565|https://docs.oracle.com/en/cloud/saas/netsuite/ns-online-help/section_4387799721.html#bridgehead_4485602565>

yeah i agree its confusing, and poorly worded, I've always done this type of stuff in the pageinit or fieldchange of a client script

But a transform from a PO might not be considered a "real" create :man-shrugging: 

hmm I guess you're right... and line level vs. header might be different too?
Like I said I don't recall ever doing something like this in a beforeLoad so I don't have any experience with it.

thinking about it though it makes sense, if its a create context then its not saved to the DB yet so there shouldnt be an issue with editing it

if what you are accomplishing can be done via a default value, then you can use beforeLoad to set the value

in general, setting sublist values in a before load is especially bad, doing so doesnt actually set any sourced values

Thanks all. I'll try to convert this to pageInit and see what happens.