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

Customer sales this year compared to last year


Are your customers spending more or less with you year after year? Which customers have had the biggest increase in revenue over the last year? Or, the biggest increase in gross margin over the last year? This report is all about comparing these types of statistics, using data from the receivables management module.

Brief background of the company

This report is for a company that has limited sales staff, so they need to know whether customers are increasing or decreasing their sales, in order to know which customers deserve rewards (for increasing sales) and which customers deserve some extra attention (for declining sales).

Pain or goal defined

This company wants to track which of their customers have the largest revenue increase and decrease. They also want to know which customer has the largest gross margin increase and decrease. The staff members who need this information are not GP users.

Our goal is to have one report that allows you to compare...