Hi,

We have to do a monthly reconciliation of monthly sales by product... So we use the Product Summary Report. We recently did some better categorizing of our products, with some products being in more than 1 category, which the cart allows for.

However, the Product Summary Report is showing duplicate entries for all products with more than 1 category. It is the same sales totals, just repeated with a different category.

Would you know where to modify the stored procedure, or which one it is, so we can only get the total products sold? We do not need the categories.

Thanks!

Steve