Customer Engagement & Dynamics CRM Forum

Back to discussions
Expand all | Collapse all

Accounts with no Contacts

  • 1.  Accounts with no Contacts

    GOLD CONTRIBUTOR
    Posted Feb 07, 2019 04:46 PM
    Hi,

    Any advice on how to identify which Accounts have no Contacts?  I thought there was a way with the Version 9 but it doesn't seem evident to me.  Help?

    Thanks in advance to everyone who responds.
    Cara

    #CustomerEngagement
    #nocontactsunderAccount
    ​​​

    ------------------------------
    Cara McCulloch
    Green Shield Canada
    Windsor ON
    ------------------------------


  • 2.  RE: Accounts with no Contacts

    TOP CONTRIBUTOR
    Posted Feb 07, 2019 04:54 PM
    @Cara McCulloch - There is an option in ​Advanced Find using the "Does Not Contain Data" filter. You can find out more in this article: https://community.dynamics.com/crm/b/magnetismsolutionscrmblog/archive/2018/06/20/find-records-without-a-child-record-in-dynamics-365-v8-and-v9

    ------------------------------
    Aaron Back, MCSE
    Sr. Microsoft Dynamics 365 Consultant
    www.acemicrotech.com
    _______________________________________
    CRMUG Board Member
    CRMUG Chapter Leader - Cincinnati, Ohio
    ------------------------------

    Original Message


  • 3.  RE: Accounts with no Contacts

    Posted Feb 08, 2019 08:36 AM
    I use a Rollup field on the Account entity to track the number of Contacts related to each account.  It does take 24 hours before the field is calculated for the first time.  This article explains them very well. Define rollup fields
    Microsoft remove preview
    Define rollup fields
    Applies to Dynamics 365 for Customer Engagement apps version 9.x (on-premises) Rollup fields are designed to help users obtain insights into data by monitoring key business metrics. A rollup field contains an aggregate value computed over the records related to a specified record, such as open opportunities of an account.
    View this on Microsoft >


    ------------------------------
    Steven Mayhue
    Lead Developer/DBA
    My Florida Regional MLS
    Altamonte Springs FL
    ------------------------------

    Original Message


  • 4.  RE: Accounts with no Contacts

    GOLD CONTRIBUTOR
    Posted Feb 08, 2019 10:57 AM
    Got it, thanks so much.  This is perfect!  ​

    ------------------------------
    Cara McCulloch
    Green Shield Canada
    Windsor ON
    ------------------------------

    Original Message


  • 5.  RE: Accounts with no Contacts

    SILVER CONTRIBUTOR
    Posted Feb 08, 2019 09:06 AM
    Ditto what Aaron posted.

    This new feature in v9 has been a great benefit.


    ------------------------------
    Brian Mergen
    Dynamics 365 (CRM) Administrator/DBA
    Morton Buildings, Inc.
    Morton IL
    ------------------------------

    Original Message


If you've found this thread useful, dive deeper into User Group community content by role