web
You’re offline. This is a read only version of the page.
close
Skip to main content
News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Customer experience | Sales, Customer Insights,... / Companies with no Acti...
Customer experience | Sales, Customer Insights,...
Suggested answer

Companies with no Active Contacts

(0) ShareShare
ReportReport
Posted on by LisaMB 75

How do I pull a list of all companies with no active contacts associated with them?

I can pull a list of companies with no contacts but not no active contacts. I want to deactivate old not used companies.

I have the same question (0)
  • Suggested answer
    a33ik Profile Picture
    a33ik 84,331 Most Valuable Professional on at
    RE: Companies with no Active Contacts

    Hello,

    I see 2 ways to achieve your goal:

    1. Marketing Lists. Here is what you can do:

    1.1. Create a static marketing list with the target entity as "Account".

    1.2. Add all accounts to that list.

    1.3. Remove accounts from that list based on Advanced Find Query and the Query, in this case, will be "Accounts with Active Contacts" - it should be straight forward.

    1.4. As a result, the marketing list you created on step 1.1 will contain only accounts without active contacts.

    2. Enhanced tricks with FetchXml - Microsoft introduced the "Doesn't contain" feature to FetchXml and in order to utilize that feature it would be required to use XrmToolBox tools that are described here - www.arbelatech.com/.../creating-system-views-with-complex-not-in-filter-in-dynamics-365-for-customer-engagement.html

  • Suggested answer
    Community Member Profile Picture
    Community Member on at
    RE: Companies with no Active Contacts

    Well, I understand the issue with the limitations of Advanced Find.  How many Companies/Accounts do you have?  You could pull two lists - 1 All Companies and 2. All Companies with an Active Contact, export to excel.

    Then put both into the same excel sheet and compare the lists, remove the ones that have an account in each list, then you have a list of accounts to turn off.  From there, you could attempt to import that list as inactive (you would need a unique id for the import, plus I am not 100% sure on limitations of importing records as inactive).  If that idea doesnt work, due to the import, you could flag them all in a different field, then filter on said field and deactivate.

    If the excel idea is out of the question let me know, Im sure I can come up with something else.

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

News and Announcements

Dynamics 365 Community Calls Return
Join experts in person to explore low code and AI agents at the Power Platform Community Conference sponsored by Microsoft
Responsible AI policies for the Community

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Mansi Soni – Community Spotlight

We are honored to recognize Mansi Soni as our August 2025 Community…

Congratulations to the July Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Customer experience | Sales, Customer Insights, CRM

#1
Hamza H Profile Picture

Hamza H 141

#2
Daniyal Khaleel Profile Picture

Daniyal Khaleel 132

#3
DAnny3211 Profile Picture

DAnny3211 130

Last 30 days Overall leaderboard

Featured topics

Hide selecting Contact for potential customer when creating quote

Product updates

Dynamics 365 release plans