Morning, 

We have Sage 100ERP, I am looking to see if there is a way to create a report by period that shows how much in sales per vendor. So we are a distribution company and we purchase products from several vendors, and then sell those products to our customers. I want to see the sales of all the products to customers for the year by a specific vendor. I hope this makes sense. 

So far i can find vendor reports in accounts payable but this is just showing how much we spent buying product from the vendor. Which isnt what i want.

the purpose for the report im looking to do is for marketing. WE have a yearly showcase of our brands where they show their products and new products to our customers. I want to measure if we sold more or less of that particular brands (vendors) products to customers after the show. This will show how well the show did. 

Thanks!!!