I remember looking at this a while ago. The queries are definitely different. You can see the difference if you open up the jrxml files.

I just took a look. It appears that the 'practice clinician sales report' is looking at 'act.customerAccountCharges%' to do the calculation. The 'clinician sales report' is looking at 'act.customerAccount%Item'. The 'Charges' types will represent the invoices themselves. Each invoice has a single clinician name associated with it. Each line item is represented by a 'Item' -- which also have clinicians associated with them. So, at least one difference would be due to any invoices that have more than one clinician logging items to the invoice.

I customized mine. Basically, we needed the clinician report to pull from line-items instead of from invoices (which I think they do by default) because we had a lot of invoices with multiple clinicians on them. We also added a check that the invoice was finalized. We didn't want to credit items to a clinician for invoices stuck in WIP.

Thanks, Paul