finding orders with discounts.

Here is the business process- We offer an 8% commission on sales at full price. If there is a discount (closeout order) then we only offer a 4% commission.

To facilitate this we have a custom field "Commission Rate" where the order entry person is supposed to choose "Full Commission" or "Closeout". If this is not chosen correctly we are in danger of overpaying commission on the sale.

Ideally I would like a report that shows me invoices or cash sales where:

1.) Items are sold at a price level other than the default price level set on the customer record.

OR

2.) There is a discount entered on the order.