Add Vendor filter on merchandise sales report
We need to be able to report on merchandise sales by vendor. Currently, I do not see an easy way to do this. I would use the merchandise activity report but I need Gross Sales, $ Discounts, Net Sales, etc.
I also tried query but there is not a vendor filter in the Sales Order Item Merchandise section.