I realized that processing an AP from AR Clearing transaction will overwrite the original customer invoice payment date with the clearing date. This has led to duplicate commission payments when the customer invoice payment date and clearing date are in different periods.

Sage support stated that this is how it is designed and is working properly. I find this archaic.

We should not have to review all commissions each payroll to verify we have not already paid out on them.