I am having a problem because we pay commissions on paid invoices and we had a special report written to capture paid invoices.

What is happening is when an RMA is issued it opens up the original invoice and marks it as unpaid. This removes it from the guys commission reports.