Setting Up Duplicate Detection

After you enable the Duplicate Detection feature at Setup > Company > Enable Features, you need to set the criteria for finding duplicates before records can be flagged. By default, NetSuite looks for duplicates by email address.

You can change how NetSuite searches for duplicates on the Duplicate Detection page. You can have NetSuite search for duplicates among customer, contact, partner, or vendor records and look for matches in certain fields.

Go to Setup > Company > Duplicate Detection.

Note:

You may have to scroll down the Company menu to see Duplicate Detection in the Company Management section.

The following topics describe the duplicate preferences on each subtab of the Set Up Duplicate Detection page.

Use the Duplicate Entity Management permission to specify which users can access the Manage Record Duplicates page. For more information, see Duplicate Entity Management Permission.

After you set the duplicate detection preferences, NetSuite starts searching for duplicate records based on your criteria.

Note:

The initial search can take a while, depending on how many customer and contact records you have in your account. You won't see duplicate alerts or be able to merge records until this first search is done.

After the search is complete, possible duplicate records are flagged with a notice and a link to a page where you can decide how to handle them. For more information, see Duplicate Record Notification and Merging or Deleting Duplicate Records.

You can only merge records if they have the same tax registration number or if neither record has a tax registration numbers entered. This restriction prevents you from merging records that aren't duplicates. If you use NetSuite OneWorld, you can't merge records with different subsidiaries.

Note:

Merging records also merges their transaction histories. The original data, such as entity name, is retained to preserve a transaction's history. You should limit who can merge records to specific roles or to a user with the Administrator role. This is particularly important if audit requirements discourage merging transaction records.

You can also go to Lists > Mass Update > Entity Duplicate Resolution to search for all possible duplicate contact and customer records based on the criteria you've set.

Related Topics

General Notices