Hey all - I'm trying to edit a shipping subrecord ...
# suitescriptt
Tyler
11/02/2018, 3:41 PMHey all - I'm trying to edit a shipping subrecord on a sales order. The code I am using is nlapiEditSubrecord('shippingaddress'), but it's returning nothing. I'm not sure if I'm using the wrong field name or if it's something else. Any advice would be awesome
l
Lea CC
11/02/2018, 3:51 PMI don't think your syntax is correct. Might need to cross check in SuiteAnswers the correct one. Just search 'address subrecord script'. Sorry I am using mobile hence couldn't check.
p
prasad
11/02/2018, 3:56 PMvar address = rec.createSubrecord('shippingaddress');
address.setFieldValue('city');
rec.commitSubrecord('shippingaddress');
Try this. Here rec object is from SO.
r
Ravi
11/02/2018, 3:58 PMYup, its correct. the intrenalid for address subrecord is 'addressbookaddress'
t
Tyler
11/02/2018, 4:05 PMThanks everyone for the replies.
Tyler
11/02/2018, 4:06 PM@prasad I'm trying to edit an existing address subrecord on a new sales order.
@Ravi When I use addressbookaddress as the fieldname for the editSubrecord function, Netsuite throws this error "Field addressbookaddress is not a subrecord field."
r
Ravi
11/02/2018, 4:09 PMmay i know which field you want to edit on the shippingaddress subrecord?
t
Tyler
11/02/2018, 4:10 PMWhat I am trying to do is get the state off the address subrecord
Tyler
11/02/2018, 4:10 PMshippingaddress subrecord*
p
prasad
11/02/2018, 4:10 PMin that case, try this rec.editSubrecord('shippingaddress').getFieldValue('addrtext');
rec.setFieldValue ('shippaddress', addrtext);
But using this we will get all address as string. If it is not working, better to use customer record to load all the addresses.
t
Tyler
11/02/2018, 4:13 PM@prasad when I use rec.editSubrecord('shippingaddress').getFieldValue('addrtext'), Netsuite throws an error saying it can't get field value of null 😞
p
prasad
11/02/2018, 4:16 PMinstead of addrtext, use state
we will get the state itself
t
Tyler
11/02/2018, 4:16 PMSame issue
Tyler
11/02/2018, 4:17 PMIt seems the issue is it isn't pulling in the address Subrecord for whatever reason
p
prasad
11/02/2018, 4:22 PMTry using this code in Debugger, and see the record and subrecord object
var sorec = nlapiLoadRecord('salesorder', 111);
var state = sorec.editSubrecord('shippingaddress').getFieldValue('state');
Generally it should work on salesorder type.
t
Tyler
11/02/2018, 4:29 PMI wonder if the issue is because it's a new sales order?
r
Ravi
11/02/2018, 4:31 PMIs this problem solved now?
t
Tyler
11/02/2018, 4:31 PMNot yet 😞
r
Ravi
11/02/2018, 4:31 PMSend me the screen shot salesorder shipping tab
t
Tyler
11/02/2018, 5:46 PMI figured out the issue. On the shipping tab, it gives the option to use a stored address or enter a custom address. When I use a stored address, I can't access the subrecord. When I use a custom address, I have no issues.
Tyler
11/02/2018, 5:46 PMThis leads me to believe that I have to use some other keyword to access the stored addresses but I have no clue what that would be.
h
Helena
11/05/2018, 5:39 PMHi Tyler, i'm just curious to know if the shipping address subrecord that you mentioned above is the same as the Ship To select field ?
2 Views