I need a sales report to generate monthly/qrtly commissions which will show me all invoices paid during a specific period (with option to filter by rep) in order to calculate commissions due.  I only want the report to show the invoice # once and the amount, if there is more than 1 item on the invoice it shows each amount and the invoice number. I want rep-amount the invoice was and amount the we received by the client, no matter the date the invoice was issued. 

We only pay commission to reps when an invoice has been paid. Some invoices get paid partially or within a 30-90 day term or longer  I want to be able to see which invoices were paid or partially paid during a specific time period no matter how old the invoice is.