web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Customer experience | Sales, Customer Insights,...
Suggested Answer

Duplicate Detection of records

(0) ShareShare
ReportReport
Posted on by 5,514

Hi, All 

I need to find/avoid Duplicates of records . 

Which will be the best solution 

Plugin or Duplicate Detection Rule ? 

Please suggest some links if available 

Thanks 

Sandeep

I have the same question (0)
  • Suggested answer
    meelamri Profile Picture
    13,218 User Group Leader on at

    Hi Sandeep,

    You can use alternate keys to avoid duplicates.

    Please refer to this blog :

    www.nexsoftsys.com/.../alternate-key-duplicate-detection-using-dynamics-crm.html

  • sandeepc Profile Picture
    5,514 on at

    But my custom entity is not showing up in drop down 

  • sandeepc Profile Picture
    5,514 on at

    any suggesstion will be marked as verified

  • Community Member Profile Picture
    on at

    Hi sandeepc

    You need ensure the entity is enabled for duplicate detection.

    Go Settings > Customizations > Customize the system > entities.

    Click the entity you need, then check ‘Duplicate detection’ under ‘Data Services’ section.

     pastedimage1610962738456v2.png

    Test.

    Go Settings > Data Management > Duplicate Detection Rules to create new rule.

    pastedimage1610962792669v3.png

    Regards,

    Leah Ju

    Please mark as verified if the answer is helpful. Welcome to join hot discussions in Dynamics 365 Forums.

  • Inogic Profile Picture
    766 on at
    Hi Sandeep,
    The choice between a plugin and a duplicate detection rule really comes down to your specific business needs and the volume of data you're working with. Here are a few things to consider before deciding:
    • If you have under 50,000 records, Dynamics CRM's built-in duplicate detection rules are a good starting point. From experience, though, it's worth knowing upfront that it matches on exact values only, so minor name variations will slip through. Merging is manual and capped at four records at a time, and it works best with standard entities like Account, Contact, and Lead. Also, think of it more as a cleanup tool, so you'll still need a process to stop duplicates from entering in the first place. But as you have a small dataset, it is always feasible with little effort, and the best choice instead of paying for any 3rd party solutions.
    • Between 50,000 and 500,000 records, you'll want to look at dedicated tools which handle this scale much more comfortably.  
    • Beyond 500,000 records, consider other advanced data deduplication solutions for Dynamics 365 CRM.
    • But, while choosing the solution, check whether
    • The tool provides a complete package of duplicate identification, prevention, and duplicate merging in Dynamics 365 CRM.
    • Check whether the tool provides customization in duplicate matching rules and merge rules so that your data deduplication can align with your business needs.
    • Furthermore, verify that the tool does support cross-entity/related-entity based duplicate detection in Dynamics 365 CRM.
    • Confirm whether the tool provides support for bulk data deduplication in Dynamics 365 CRM while maintaining the relationship between the records or historical data.
    Hope this helps you make the right call for your situation!

    Thanks!

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Season of Sharing Community Challenge Launch!

Jump in, show your community spirit, and win prizes!

Women in Power Builds Momentum

Expanding mentorship, skilling, and AI innovation

Congratulations to the April Top 10 Community Leaders

These are the community rock stars!

Leaderboard > Customer experience | Sales, Customer Insights, CRM

#1
Nagaraju_Matta Profile Picture

Nagaraju_Matta 121

#2
ManoVerse Profile Picture

ManoVerse 73 Super User 2026 Season 1

#3
Abhilash Warrier Profile Picture

Abhilash Warrier 66 Super User 2026 Season 1

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans