NetSuite Saved Searches: Get the list of records with duplicate addresses

Sample Scenario: You’re trying to get a list of NetSuite customers with duplicate addresses.

A duplicate address, as defined in your company, is when the Address Label is exactly the same with an existing one. Example as shown below:

duplicate-address.jpg

Here are the steps on how to come up with a simple NetSuite saved search that allows you to generate a report of all customers that fall under that scenario.

1. Go to Lists > Search > Saved Searches > New

OR

Reports > New Search.

2. Select “Customer”.

3. Enter a comprehensive title.

4. Under “Results” tab, select the following Columns.

duplicate-address-columns

5. Click on “Save and Run”.

duplicate-address-results-all-customers

Notice on the image above that all the customers in the NetSuite system are displayed. We want to filter that to display the applicable results only. Here are the next steps:

6. Under Criteria tab, click on “Summary”.

search-based-line-count-filter

7. Select “Count”. Field = “Address Internal ID”

8. Select “greater than” and put “1” on the “Value”.

duplicate-address-greater-than.jpg

See sample results below. Notice that this time, the only row that displays is the Customer with the duplicate address.

duplicate-address-results

For more tips on NetSuite Saved Searches, please click here!

LEACC Consulting is a team of NetSuite Certified Developers with IT experience solely dedicated to NetSuite technologies for eight years. We are experts in both SuiteScript 2.0 and SuiteScript 1.0. Our team has worked with 400+ NetSuite scripts and workflows combined. If you need some consulting help of how you can design your NetSuite scripts better, contact us by filling out this form or by commenting below.

 

TALK TO A NETSUITE EXPERT NOW!

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s