web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / Customer statement (sa...
Microsoft Dynamics GP (Archived)

Customer statement (sales)

(0) ShareShare
ReportReport
Posted on by Community Member

Hi,

I would like to know if I can customize the default statement to exclude some invoice base on another table (external from GP but in the same MS-SQL server). This table is linked with the customer number.

Then I would like to create another statement page that will add the excluded invoice with the same information as the original statement but with a new contact and address.

Can I do this in Crystal Report?

Thank you for your help.

Martin.

*This post is locked for comments

I have the same question (0)
  • Victoria Yudin Profile Picture
    Victoria Yudin 22,769 on at

    Hi Martin,

    Based on what you've described, you can certainly do this in a Crystal report. However, at that point, your users will need to either use Crystal directly to print the statements, or you would need to get an add-on product like our GP Reports Viewer to allow printing/emailing of the statements directly from Dynamics GP.

  • Community Member Profile Picture
    Community Member on at

    GREAT!

    Your product look's good. Because our users are not CP user.

    Could you lead me to do this a little in Crystal Report?

    Thank you.

  • Verified answer
    Victoria Yudin Profile Picture
    Victoria Yudin 22,769 on at

    Hi Martin,

    Dynamics GP statements will typically use tables RM00101 (customer master), RM00102 (customer addresses), and RM20101 (open transactions). If you have specific questions about creating your reports or are running into trouble in a particular area, please give some more details and I will try to help.

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Meet the Microsoft Dynamics 365 Contact Center Champions

We are thrilled to have these Champions in our Community!

Congratulations to the April Top 10 Community Leaders

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

#1
Shravan Attelli Profile Picture

Shravan Attelli 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans