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

Items sold by the manufacturer


The same company from the previous sections needs to be able to review sales by their product manufacturer. This same BI reporting can be used for any information that is tracked in inventory categories.

Brief background of the company

This company sells all across the U.S., and sells products from a variety of manufacturers. They have a direct sales force, a physical showroom where customers can purchase in person, and a web presence where customers can place orders directly via their website.

They use inventory item category 1 to store the manufacturer of each item. This field is used because they can either purchase items directly from the manufacturer or a wholesale distributor. Although the vendors change, the item's manufacturer does not.

Pain or goal defined

Some higher-end manufacturers require their customers to sell a certain amount of product(s) to maintain the privilege of selling their product(s). This being said, although monitoring sales by customers...