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

How can I find a transaction shipaddress in the Netsuite address book using SuiteQL? The number that is returned as transaction.shippingaddress doesn't seem to exist in any of the address book records

do you understand the difference between an addressbook and an address?

I think so, my issue is that upon querying a transaction - sales order for example, I am getting back a number for `Transaction.shippingaddress` and I can't seem to find that number in any of the entries in the addressbook record, nor in the transactionShippingAddressbook or transactionAddressbook record

the shippingaddress is the id of an address

you looked for it in addressbook related tables

Ok, so is there any way to query all addresses? Or are they only accessible via the transaction?

searches treat entity addresses the same as transaction addresses

for queries, there is a separate entity address table and a transaction address table