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

Dashboard of open orders by customer, state, item class, and salesperson


Minor ad hoc changes are made to the dashboard of sales that we just completed to create a dashboard of open orders. This report is intended to be informational in nature, and is typically used to review work created through yesterday; not to monitor and work with today's activity.

If you used the view for History only, you will need to completely recreate the previous report using the view for the Open transactions. If you used the downloadable view (see Preface for download location), you can follow the remaining steps. If you did use the History view, we've included the view for open transactions in the upcoming section.

Brief background of the company

This report is for the same company that sells all across the U.S., and sells products from a variety of manufacturers. This company has a direct sales force, a physical showroom where customers can purchase in person, and a web presence where customers can place orders...