reporting discounts

MP,

Play with the Detailed Sales Report. Add the Price Source column and then drag the column to the left. It will sort on where the selling price came from, i.e. Regular price, Cashier Set, etc

I don't see totals in the "sold price" and "price" columns. I don't want to have to export to a spreadsheet to calculate the average discount percentage.

MP

"Jeff" wrote:

MP,

Try adding the Profit Margin, Price Source, Transaction, and Cost. Drag the Price Source to the far left, Cost next to Total Sales, Profit Margin next and Transaction last.

Now collapse all groups (Ctrl+O), you will have totals for Qty Sold, Total Sales, Cost and Profit Margin by Price Source.

If you want to see where the numbers came from, expand the Price Source group. If you want to see the transaction after that, double click on the transaction number.