News and Announcements icon

Dynamics 365 CommunityForums Microsoft Dynamics GP (Archived) SQL Reporting Services...

Microsoft Dynamics GP (Archived)

SQL Reporting Services reports

(0) Share

Report

Report

Posted on by Community Member Microsoft Employee

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

All responses Img

All responses (1)

Answers Img

Answers (0)

Community Member Microsoft Employee on at

Like (0)

Report

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

Helpful resources

Quick Links

Leaderboard

#1

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

#2

Martin Dráb 231,321 Most Valuable Professional

#3

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans