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

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Microsoft Dynamics 365 | Integration, Dataverse...
Answered

How to Identify Customer Accounts from Accounts Created from Qualifying a Lead

(0) ShareShare
ReportReport
Posted on by 32

Hi,

We have a list of 'Accounts' within Dynamics which includes our existing customers, but the list also includes 'Accounts' that were automatically created when qualifying a lead (these 'Accounts' may still be in quote stage and are not customers yet).

We can't seem to create a list of actual customers on the 'Account' views (on the sales app), as there does not seem to be a method of filtering these into actual customers.

We also want to send out a bulk email to all existing customers (through the marketing app), but it is currently using the entire list of accounts, which would send a customer email to the list of existing customers and automatically generated 'Accounts' that were created when qualifying a lead. 

Is there a field on the account form that we're missing, to say whether an 'Account' is a customer or not?

Can anyone advise please?

Thanks,

CP 

I have the same question (0)
  • Verified answer
    a33ik Profile Picture
    84,331 Most Valuable Professional on at

    Hello,

    There is a field called "Relationship Type" where you might define the type of relationship with the customer - either it's an existing customer or the prospect but in order to use that field, you will have to update the existing data.

    In order to identify if the account was converted from the lead, you can check the "Originating Lead" field.

  • Verified answer
    Community Member Profile Picture
    on at

    Hi Cnpeps,

    As Andrew said, you need use 'Originating Lead' lookup field as filter to check accounts.

    There is one 1:N relationship between Lead and Account, so one  lookup field named 'Originating Lead' in the Account entity:

    Originating Lead: Shows the lead that the account was created from if the account was created by converting a lead in Microsoft Dynamics 365. This is used to relate the account to data on the originating lead for use in reporting and analytics.

    pastedimage1664851820326v1.png

    Then you can create one new Account view with  'Originating Lead' not contain data as filter:

    pastedimage1664851202423v1.png

    Then you can get a list of accounts that do not include those that are automatically created when qualifying a lead,.

    pastedimage1664851575795v2.png

  • Suggested answer
    a33ik Profile Picture
    84,331 Most Valuable Professional on at

    Hello,

    If my reply (or replies) answers your question take a minute and verify the answer. You can do it by clicking "Yes" at the top of the reply (or replies) under the label "Does this answer your question?"

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Congratulations to our 2025 Community Spotlights

Thanks to all of our 2025 Community Spotlight stars!

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

#1
Pallavi Phade Profile Picture

Pallavi Phade 102 Super User 2026 Season 1

#2
11manish Profile Picture

11manish 55

#2
Abhilash Warrier Profile Picture

Abhilash Warrier 55 Super User 2026 Season 1

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans