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 to query Vendor Addresses? Attempting to access the vendor addressbook via the join on vendor id = vendoraddressbook.entity (as per the documentation, Records Catalog), but receiving a cryptic message that this field isn’t exposed (even though the documentation references it for this use?)

```SELECT vab.id

FROM Vendor v
INNER JOIN addressBook vab ON v.id = vab.entity

Where v.id = 1420```
Search error occurred: Field ‘entity’ for record ‘AddressBook’ was not found. Reason: NOT_EXPOSED - Field is marked as internal for channel SEARCH Field ‘id’ for record ‘AddressBook’ was not found.

relative url to Records Catalog for Vendor:

`/app/recordscatalog/rcbrowser.nl?whence=#/record_ss/Vendor`

```SELECT
  vendorAddressbookEntityAddress.addr1,
  vendorAddressbookEntityAddress.state,
FROM
  Vendor
  LEFT OUTER JOIN vendorAddressbook ON Vendor.id = vendorAddressbook.entity
  LEFT OUTER JOIN vendorAddressbookEntityAddress ON vendorAddressbook.addressbookaddress = vendorAddressbookEntityAddress.nkey
WHERE
  vendor.id = 679```