Skip to main content

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Customer Service forum

Very popular request - help

(0) ShareShare
ReportReport
Posted on by

We have had a lot of requests from our sales/marketing teams and they all revolve around the same query. 

"Provide a list of Accounts where they do not have a contract for X product" 

This query would be "Active Accounts where they do not have an Active Contract Detail for Product X".

We have struggled to find a way to produce this via Advanced Finds/SSRS/PowerBI etc. Is there any way to do this? Any custom solutions? 

  • Suggested answer
    Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Very popular request - help

    I was able to complete this using Advanced Find

    AccountsNoProducts.png

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

November Spotlight Star - Khushbu Rajvi

Congratulations to a top community star!

Forum Structure Changes Coming on 11/8!

In our never-ending quest to help the Dynamics 365 Community members get answers faster …

Dynamics 365 Community Platform update – Oct 28

Welcome to the next edition of the Community Platform Update. This is a status …

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 292,489 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 231,305 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans