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

Open purchase orders older than 45 days


Often Purchase Orders are created and, for one or another reason are never completed or cancelled. Sometimes they are simply forgotten to be purchased, and they just linger in GP for who knows how long. We are going to try to put a stop to that. We are going to monitor old POs.

Tip

If you are using the new Workflow for requisitions, part of your flow definition is how to handle old items, so this report may not be necessary. However, join us in building this report anyway as you may find another use for it.

Brief background of the company

This report is for a company that creates Purchase Orders for a large annual event they have, which provides over 75 percent of their sales for the year in the first month of that year. There are over 10,000 attendees at this event each year. As you can imagine, there is a lot of preparation that results in a LOT of POs.

Pain or goal defined

As the event approaches, sometimes POs are overlooked. These POs remain in the...