Sales Rep Commission Reports


Hi - With the disappearance of Intelligence Reporting, I have run into a brick wall on accurately accounting for and calculating the commissions that my sales reps get.

I have tried to do it through the Invoice Register, but the report that it spits out forces me to do a line item for EVERY line item on the invoice instead of summarizing it.  If I were to check the "summarize" box, I can longer add the "Receipt Date" data point to the report which is crucial information for paying a monthly report (we pay commissions on the 10th of each month and that commission is for the previous months' PAID invoices).

Has anyone found a solution that works for calculating sales rep commissions?  I am at my wits' end.

Thanks for any advice you can offer,