I found that not all paid:prosites record entries have added the credit amount. For example in image below, there are 6 paid signups but the affiliate only has credit for 5. I went to the affiliaterecords table and edited the record to change the amount but apparently that is not sufficient because it is not reflected in the balances.
1. There must be a bug that caused the problem. The record was created but not correctly.
2. Although I do not want to babysit all of the transactions to find errors, if I do like in this case what can I do to correct the error and have it display also in the credit balance?