Getting access to accurate customer address information is a common requirement for many NetSuite users—whether it is for reporting, logistics, communication, or audit purposes. While writing SQL queries using SuiteQL gives you full control over your data, not everyone is comfortable working with code.
In previous article, NetSuite Admin Tip | SuiteQL: Retrieve Customer Addresses, we showed how to use SuiteQL to pull customer address data using SQL queries. But if you are not familiar with SuiteQL or prefer a no-code option, SuiteAnalytics Workbook Datasets offer an intuitive, visual way to access the same information—no scripting required.
Here’s how you can build a custom Dataset to view customer addresses:
1.Navigate to Analytics > Datasets
2.Click the New Dataset button
3. In the search bar, find and select Customer
4. In the Customer Dataset, drag the following fields into the table:
From Customer:
Company Name (Note: Entity ID is automatically included)
From Address Book > click Address to expand:
Address 1Address 2AddresseeCityCountryStateZip
Click Save to keep the dataset for future use or analysis.
Here’s a sample GIF that shows how to drag and drop fields into the table:
Note: You can tailor this dataset by adding filters or more fields depending on your business needs.
We’d love to hear how you use SuiteAnalytics Workbook Dataset in your NetSuite processes! Share your insights and experiences in the NetSuite Admin Corner.