Skip to main content

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Microsoft Dynamics GP (Archived)

SQL Reporting Services reports

(0) ShareShare
ReportReport
Posted on by

I am new to a company that is pulling all of their reports out into Excel and trying to manipulate data that way.  I am SURE it's faster and easier to have SQL reporting services to do that, however, I am stuck.

I am looking for a report that will allow a user to look up their territory and find customers that have not purchased a minimum of $750 over the past 9 months and what products that they have purchased.  What would my SQL query look like in order to accomplish this?

Thank you in advance for your help!

*This post is locked for comments

  • Community Member Profile Picture
    on at
    RE: SQL Reporting Services reports

    The report should contain the following:

    Customer ID

    Name

    From

    To

    Document = INV

    Individual invoice

    Total Amount

    Sales Person ID

    Territory

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

Daivat Vartak – Community Spotlight

We are honored to recognize Daivat Vartak as our March 2025 Community…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Kudos to the February Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 231,723 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156 Moderator

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans