News and Announcements icon

Dynamics 365 CommunityForums Microsoft Dynamics 365 | Integration, Dataverse... New Lead -> Qualify - ...

Microsoft Dynamics 365 | Integration, Dataverse...

Suggested answer

New Lead -> Qualify - check for existing Account based on different column?

(0) Share

Report

Report

Posted on by Cayshin

Hi,

When Qualifying a Lead, CRM already checks if it finds a matching Company Name in Accounts as seen below. However, we'd prefer if it could match against a different column in the Accounts table.

Is there a way to change it to instead match against our Account Number field (a custom column)? Instead of Company Name, we use our custom Account Number field as the uniquely identifying value for clients.

Thank you

All responses Img

All responses (2)

Answers Img

Answers (0)

Cayshin on at

Like (0)

Report

New Lead -> Qualify - check for existing Account based on different column?

Hi Leah Ju,

Yes, improved duplicate detection is turned on.

We also already have a rule to check for duplicate Account Numbers; however, it only triggers when manually creating an Account NOT when an Account is created via Qualifying a Lead.

I'm assuming that the duplicate check performed when qualifying a Lead is different than the duplicate detection rules simply because the two pop-ups are titled differently.

In my original post, the duplicate check pop-up when Qualifying a Lead is titled "Account or Contact may already exist", whereas when manually creating an Account the pop-up is titled "Duplicate records found". This leads me to believe the former is controlled by something somewhere else. That something is what I'm wondering if is possible to reconfigure.
Suggested answer

Leah Ju Microsoft Employee on at

Like (0)

Report

New Lead -> Qualify - check for existing Account based on different column?

Hi Dan Sienkowski,

When qualifying a lead, if a duplicate account or contact is detected while creating new records, a duplicate warning is shown to you.

Depending on whether your system administrator has enabled the improved duplicate detection and merge experience, you'll see the options to resolve duplicates.

https://learn.microsoft.com/en-us/power-platform/admin/set-up-duplicate-detection-rules-keep-data-clean

By default, there are four duplicate detection rules on the account entity as follows:

You can unpublish rules that you don't need, create one new rule on the account, select the field you need and publish this new rule.

I hope you can mark my answer verified if it is helpful! If you have any questions, please feel free to contact me.
Regards,
Leah

Helpful resources

Quick Links

Leaderboard > Microsoft Dynamics 365 | Integration, Dataverse, and general topics

#1

Daivat Vartak (v-9d... 181 Super User 2025 Season 1

#2

Siv Sagar 149 Super User 2025 Season 1

#3

Vahid Ghafarpour 124 Super User 2025 Season 1

Last month Overall leaderboard

Featured topics

Get batch job history log from D365 FO to Power Automate

Gross and Net Weight of Shipments feeding back into Sales Order (from External Source)

Product updates

Dynamics 365 release plans