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

I'm trying to get the PO value that is found on the related records in the vendor bill.

I tried doing this

var purchaseOrderId = currentRecord.getSublistValue({

sublistId: 'purchaseorders',

fieldId: 'poid',

line: 0});

​

but its coming up blank.

Any thoughts?

if you are trying this clientside, you want to use N/record to load the record instead

Ya I’m doing a client side triggering in field change.
Do I need to load the record? Is that why I can’t get the po? 
Or what’s the reason for record vs currentrecord? 

it just happens that the currentRecord doesnt have the data you need while the regular one does

sublists that you cant edit dont officially support suitescript

the related records one tends to have better support, im guessing because enough people have asked for it

I’ll give it a shot with record. Thanks!

<@U5TF1GQ20> going on with this script the next step I'm running a client script to automatically add the customer on the Customer field in the Expense line.

var customer = '1';

currentRecord.setCurrentSublistValue({

sublistId: 'expense',

fieldId: 'customer',

value: customer

});



its registering the customer but it doesn't set the field on the line.

I did with the memo field on the line with the same format and it worked fine, was hoping customer would do the same 