Skip to main content

Notifications

Microsoft Dynamics RMS forum

Must be an Easier way to Report Customer Purchases

Posted on by Microsoft Employee

I can generate a customer purchase history report through detail sales but there has to be a way to have a drop down customer list to generate this report rather than having to type the name exactly. I have checked out the reports page to no avail. Thanks.

*This post is locked for comments

  • Jeff @ Check Point Software Profile Picture
    Jeff @ Check Point ... 13,380 on at
    Re: Must be an Easier way to Report Customer Purchases

    Would still have to be exact, but have you tried the Account Number instead?  Some of my clients have 100,000 customers so it would be just as time consuming.

  • Suggested answer
    Community Member Profile Picture
    Community Member Microsoft Employee on at
    Re: Must be an Easier way to Report Customer Purchases

    what would I do with this line? Thanks

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    Re: Must be an Easier way to Report Customer Purchases

    left join customer on transaction.customerid = customer.id where isemploye = true...

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

Give Back to the Community this Month

Quick Links

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... 290,807 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 229,135 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans