Solution to View and Merge All Duplicates Directly from the record in Dynamics 365

The existing Duplicate data management features in Dynamics 365 requires users to access the duplicate detection jobs via Settings / Data management to manage potential duplicates. I would like to present my Display and Merge Duplicates Solution which provides the ability to display duplicates records for any Lead, Contact or Account record you are accessing without having to navigate to the Duplicate detection job and provide the ability to merge. I have also provided a ready to use Display Duplicates form that you can switch to view the duplicates, alternatively you can add the html webresource to your form which is triggered on load to return any duplicate record. Duplicate Detection jobs need to be enables for duplicates to be returned for the given record.

 

http://www.crmconsultants.co.uk/wp-content/uploads/2017/06/image002-1.png

 

 

The solution also provides the ability to merge the duplicate record, providing the merge dialogue allowing you to identify the master record and attributes you want to keep in the final record.

 

http://www.crmconsultants.co.uk/wp-content/uploads/2017/06/image003.png

 

 

 

http://www.crmconsultants.co.uk/wp-content/uploads/2017/06/image004.png

 

 

The Display Duplicates Solution provides a html webresource on an entity form which I have called View Duplicates and performs a RetrieveDuplicatesRequest to find duplicates specific to the open record when the Tab is expanded, this is to prevent unnecessary requests that could affect the dynamics 365 performance. The retrieve Duplicates will retrieve a list of duplicates for the given record using the duplicate detection rules, therefore your duplicate detection rules need to be configured and published your entity by going into settings > data management > duplicate detection rules

 

I have made some improvements to use Webapi to perform the Request is real time onchange event as soon as the HTML web resource is loaded.  so I advise to only load it from a new form or an expandable tab. By using the  duplicaterulecondition and duplicaterule entities to find out matchingattributename It will fetch the attributes based on baseentityname.

 

Steps to configure Display & Merge Duplicates webresource on form.

  •       Import the Display Duplicates Managed solution.
  •       Create Tab or Section on form. I recommend to create separate Tab and make it collapsed so the HTML web resource wont load until Tab is expanded.
  •       Insert Web resource raz_DisplayDuplicates.html on form. You can give any name to Web Resource.
  •       Make sure your duplicate detection rules are published.
  •       When you change the fields those are participating in duplicate detection it will trigger RetrieveDuplicatesRequest and fetch the duplicates based on the duplicate detection rule configured for the entity.

 You can download the Duplicates Merge Solution for CRM 2016 and Dynamics 365 from the download  form below;


Your Name (required)

Your Email (required)

Organisation Name / Website

Dynamics Version



mm
Author: Raz Dynamics
Razwan is a Microsoft MVP and Dynamics 365 Community Moderator responsible for developing Microsoft Dynamics 365 and CRM integrated solutions for over a decade. Razwan is responsible for delivering Dynamics 365 User Groups & CRM Saturday Conferences. Raz has developed many free community utilities for Dynamics 365 and CRM which you can download from this blog.