Manage Duplicates in Microsoft Dynamics 365

Maintaining clean data is essential for accurate reporting and efficient customer management. This guide outlines the steps for Microsoft Dynamics 365 Administrators to configure duplicate detection rules and manage duplicate records found by the system.

Part 1: Accessing Data Management Settings

1. Log in to your Dynamics 365 environment.

2. Click the Settings icon (gear symbol) in the top-right corner of the navigation bar.

3. Select Advanced Settings from the dropdown menu.

4. In the new window that opens, navigate to Settings > Business Management (or look for the Data Management block directly if visible).

5. Click on Data Management.

Part 2: Configuring Duplicate Detection Rules

Before the system can catch duplicates, it needs to know what to look for (e.g., matching email addresses or phone numbers).

1. In the Data Management screen, click on Duplicate detection rules.

2. You will see a list of active rules (e.g., "Accounts with the same Account Name" or "Contacts with the same e-mail address").

   • To create a new rule: Click New in the top command bar.

   • To edit an existing rule: Select the rule from the list and click Edit.

3. In the Rule configuration window:

   • Name & Description: Give the rule a clear name.

   • Base Record Type: Select the entity you are checking (e.g., Lead, Contact, Account).

   • Matching Record Type: Usually the same as the Base Record Type.

   • Case Sensitivity: Choose whether capitalization matters.

   • Status: Ensure the rule is "Published" for it to take effect.

4. Define Criteria: In the criteria section, select the fields to compare (e.g., "Email Address" equals "Email Address"). You can specify the number of characters to match and whether to ignore blank values.

5. Save and Close when finished.

Part 3: Managing and Merging Duplicates

Once rules are running, you can review and resolve duplicates via Duplicate Detection Jobs.

1. Navigate back to Data Management and click on Duplicate detection jobs.

2. Locate the job you wish to review (e.g., "Duplicate Leads") and click to open it.

3. In the job record, click View Duplicates in the left-hand menu or command bar.

4. You will see a list of potential duplicate sets.

   • Top List: Shows the source records that have potential matches.

   • Bottom List: Shows the specific duplicates found for the record selected in the top list.

5. Select a record in the top list to view its matches.

6. To resolve the conflict, select the records you want to combine and click Merge.

The Merge Process

1. A "Merge Records" dialog will appear showing the two (or more) records side-by-side.

2. Select Master: Choose which record will be the Master record. This is the record that will remain active; the others will be deactivated.

3. Resolve Conflicts: If there are different values in specific fields (e.g., one record has a mobile number and the other doesn't), select the specific data points you want to keep in the final Master record.

4. Click OK to complete the merge.