NetSuite Admin Tip | SuiteQL: Retrieve Customer Addresses

When working with customer data, having access to accurate and well-structured address information is crucial for reporting, integrations, and business operations. While standard saved searches can help, SuiteQL provides more advanced querying capabilities, allowing you to join tables and retrieve data that isn't easily accessible through the UI alone.

Below is a sample query that retrieves each customer’s ID, name, and associated address components using a join between the customer and entityaddress tables.

Sample SuiteQL Query:

SELECT 
    c.id AS customer_id, 
    c.entityid AS customer_name, 
    a.addr1 AS address_line_1, 
    a.addr2 AS address_line_2, 
    a.city,