Duplicate Record Detection
The Duplicate Detection & Merge feature helps you find duplicate records in your NetSuite account and use the information in them to create a single record.
An administrator can turn on the Duplicate Detection & Merge feature at Setup > Company > Enable Features (Administrator) on the Company subtab in the Data Management section. The administrator configures the types of records you detect duplicates of and also chooses which fields to consider when finding duplicates. For more information about the setup of this feature, see Setting Up Duplicate Detection.
Four types of records support duplicate matching:
-
Customer
-
Vendor
-
Partner
-
Contact
Note:Private contacts are excluded from the Duplicate Detection process.
You must have full permissions to the entity types you are merging. For example:
-
You must have full permissions for Vendors to merge two vendors.
-
You must have full permissions for both Contacts and Customers to merge Individual Customers, which are composed of both.
-
You must have full permissions for both Customers and Vendors to merge into a Customer/Vendor entity.
Duplicate Customers and Vendors can be detected across subsidiaries. The subsidiary a potential duplicate customer or vendor belongs to is shown in the Primary Subsidiary column. You must first enable the Detect Duplicates Across Subsidiaries feature at Setup > Company > Company Management > Duplicate Detection.
System notes are not transferred from duplicate entity records to the primary entity record during a merge. Merging entities updates the system notes and last modified date for all transactions associated with the duplicate entity or entities. The system notes for these transactions will indicate that they were updated by the Duplicate Resolution process.
Merging entities is a data-intensive operation, and complex merges of many records such as transactions, custom fields, or workflows may time out when processing. You should test the merge process in a sandbox account first to ensure that it can be completed.
You should designate the entity with the most transactions as the primary entity and entities with fewer transactions as duplicates to reduce the time it takes to complete the merge. You should also avoid merging entities with large numbers of transactions whenever possible.
With this feature enabled, you receive notification before saving a record that might be a duplicate. Notification occurs in two ways:
-
When you create a new record and enter matching data in fields the administrator set up as duplicate criteria, a warning appears at the top of the record with a link to the potential duplicates. If you have permission to view those records, you can click the link to resolve these matching records.
-
When you add a record from a list by using Quick Add or use the Edit button to make changes to a record that would make it a duplicate, you receive a popup warning.
You can also go to Lists > Mass Update > Entity Duplicate Resolution to search for all possible duplicate records based on criteria you have set. With the duplicate resolution mass update, you can find and resolve large numbers of duplicate records in your NetSuite account in a single operation.
For more information about how to manage duplicate records, see Manage Record Duplicates Page.
For more information, see the following: