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

Where the money goes


In the movie Jerry Maguire, the signature line is "Show me the money!" It's repeated over and over again. Every business owner asks a very similar question, "Where did the money go?", and they ask it over and over again.

Brief background of the company

This time we are the company in need of a report. We are a business services consulting and software sales organization.

Pain or goal defined

One of the owners wants to know where the cash is being spent. The owner feels this will assist him in keeping close tabs on expenditures as they are occurring rather than at the end of the period.

BI and BI tool chosen

We will produce a simple list subtotaled by who was paid and how much they were paid. Monitoring this report on a regular basis (for example, weekly) could be confusing if you base it on a transaction date (that is, post something for today with a GL posting date of last week and it would miss the report altogether). So, we will monitor this information by the actual date...