Book Image

Real-world Business Intelligence with Microsoft Dynamics GP

Book Image

Real-world Business Intelligence with Microsoft Dynamics GP

Overview of this book

Table of Contents (20 chapters)
Real-world Business Intelligence with Microsoft Dynamics GP
Credits
About the Author
Acknowledgments
About the Author
About the Reviewers
www.PacktPub.com
Preface
Index

Commission details


This report will track commissions for all customer documents in the Sales Series; it will also track whether the document is Open or History. By "Open", we mean the invoice or credit memo/return has been posted, and remains available to be displayed on the customer statement. "History" means the document has been posted, fully applied.

Brief background of the company

This report is for any company that tracks commissions on invoices in GP (Sales Order Processing, invoicing, and receivables management), particularly those companies that pay commissions when payment is received.

Pain or goal defined

GP does a great job providing the amount of commission to be paid. It does not, however, show the invoices with commission amounts for those that have not been paid in full. Salespeople keep track of their commission, and they want to know that your numbers match their numbers.

BI and BI tool chosen

We will be using the PivotTable feature of Excel. We will provide the salespeople...