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

Do y'all know what field to pull from the "Address" record so that on a sales order (transaction) I can do newRec.setValue("shipaddresslist", address.internalid)?

Currently I am using the `internalid` from a search type of "Address" and it is giving me an "invalid value for ShipAddresslist"

shipaddresslist is the numeric value of the address in the customer address book subrecord when you view the customer record on the UI

The field from the address book is addressid and not internalid.

Ah, this explains an issue from last week

addressid doesn't exists on search type address though does it? I can't find it at least

there are 2 internal ids associated with an address

the internal id of the address subrecord, named `internal id` in searches

and the internal id of the address book line from the entity, named `address internal id` in searches

the shipping address list uses the internal id of the address book

expect to do an entity search instead of an address search