Hello, how do I set the shipaddresslist field on a...
# suitescriptp
pnetsuite
08/27/2019, 3:47 PMHello, how do I set the shipaddresslist field on a salesorder? I have a script that looks up a specific address on the customer record through a search. I get the following error Invalid shipaddresslist reference key 238211 for entity 13051.
b
battk
08/27/2019, 3:53 PMi dont think you do anything special, using setValue on the
shipaddresslistbattk
08/27/2019, 3:54 PMis the address with internal id 238211 an address from the customer record with internal id 13051
p
pnetsuite
08/27/2019, 4:02 PMthats correct
pnetsuite
08/27/2019, 4:02 PMbut I still get an error when trying to set the internal id
pnetsuite
08/27/2019, 4:02 PMmessage has been deleted
b
battk
08/27/2019, 4:03 PMyou should probably be looking at the customer record, not your search
p
pnetsuite
08/27/2019, 4:04 PMwhat do you mean?
pnetsuite
08/27/2019, 4:05 PMI do a lookup on the customer record for the correct address and then try to set the internal id
b
battk
08/27/2019, 4:05 PMthe address subrecord is stored on the customer record
battk
08/27/2019, 4:05 PMthe internal ids are from there
p
pnetsuite
08/27/2019, 4:06 PMvar myCustTransColFieldfromSO = searchResults[0].getValue('internalid','address');
b
battk
08/27/2019, 4:06 PMusually on the address subtab
p
pnetsuite
08/27/2019, 4:07 PMis it the internal id field I need or the id field?
pnetsuite
08/27/2019, 4:09 PMit looks like my search is returning the internal id correctly of the address from the customer record but I am unable to set the fieldvalue for the shipaddresslist field
b
battk
08/27/2019, 4:17 PMyou should be using the
address internal idbattk
08/27/2019, 4:17 PMnot the internal id from the address join
battk
08/27/2019, 4:17 PMbasically, you should be using whatever id is shown on the customer records address subtab
p
pnetsuite
08/27/2019, 4:18 PMgot it
pnetsuite
08/27/2019, 4:36 PMthanks for your help. it worked
2 Views