If you don't need customer specific details, just query the revenue GL Account(s).

You can learn to create this report and more using Sage Intelligence Reporting or Crystal Reports  The next Crystal Reports: Beginning course is April 8-9.  The next Sage Intelligence Intermediate course is scheduled for June 1.  In the meantime you can view the Sage Intelligence Reporting: Beginner Anytime Learning course. You'll find a full complement of courses on Sage U.

I would recommend creating a Crystal Report against the AR_InvoiceHistoryHeader table.  This way you are looking exactly at the invoices generated for a customer and you can summarize the information easily.  If you need item specific sales information, you can add the AR_InvoiceHistoryDetail table.  Hope this helps!