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,