O'Reilly logo

Real-world Business Intelligence with Microsoft Dynamics GP by Mark Polino, Belinda Allen

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required