Detect duplicate data


Applies To: Dynamics CRM 2013

To determine whether a record is a potential duplicate, Microsoft Dynamics CRM uses duplicate detection rules. When publishing a duplicate detection rule, a matchcode is created for each existing record. A matchcode is also created when a record is created or updated. When a record is in the process of being created or updated, its matchcode can be checked automatically against the matchcodes of existing records. By default, Microsoft Dynamics CRM has simple duplicate detection rules for accounts, contacts, and leads. For example, you detect duplicates by matching the record fields, such as email address, first name, and last name.


Microsoft Dynamics CRM Online Spring ‘14 and Microsoft Dynamics CRM 2013 Service Pack 1 (SP1) bring the duplicate detection capability to CRM for tablets.


You have to be a system administrator or a system customizer to create, enable, and publish duplicate detection rules for your organization.

After publishing a duplicate detection rule, increasing the length of fields that are included in the duplicate detection criteria goes undetected. The field length could exceed the matchcode length limit and not be verified. This may result in duplicates not being detected.

You can create multiple detection rules for the same entity type. However, you can publish a maximum of five duplicate detection rules per entity type at one time.

You can detect duplicates:

  • When you create or update records for entities that enabled for duplicate detection. This includes records created with CRM for Outlook and tracked in Microsoft Dynamics CRM web application. The duplicate detection dialog is only displayed for the records created or updated in CRM user interface (UI). For example, for records created by a workflow, the duplicate detection dialog is not displayed.


    The Microsoft Dynamics CRM Online Spring ‘14 and Microsoft Dynamics CRM 2013 Service Pack 1 (SP1) bring back the capability to detect duplicates for the updated UI entities, when you create or update records using entity forms or grid views in the CRM web application.

  • When CRM for Outlook goes from offline to online.

  • During data import. You can specify whether or not to check for duplicates during the import.


    Duplicates can’t be detected when a user merges two records, converts a lead, or saves an activity as completed. Duplicates also aren’t detected when a user changes the status of a record, such as activating or reactivating it.

To check for duplicates in the web application, you can use Detect Duplicates capability provided in More Commands (More commands icon) on the nav bar in the grid. The duplicate records are also detected when you import data programmatically or through Import Data Wizard. In addition, you can check for duplicates by running scheduled duplicate detection jobs. For step-by-step instructions on how to set up the duplicate detection job, see Run system jobs to detect duplicates.

A duplicate detection job runs in the background while you do other things in Microsoft Dynamics CRM. You can request email notification from CRM upon the completion of a duplicate detection job.

For information about how to create duplicate detection rules and run duplicate detection using Microsoft Dynamics CRM web services (programmatically), see Detect duplicate data.

See Also

Manage your data
Import data (all record types)
Check for duplicates
Set up duplicate detection rules
Run system jobs to detect duplicates
Delete bulk records

© 2016 Microsoft Corporation. All rights reserved. Copyright