Sage 300 allows a user to apply a payment to invoices for more than the amount of the payment. A payment that is not fully applied, displays as a negative value on the A/R Aged Trial Balance. A payment that is over applied, displays as a positive value. Typically, this would not be an issue, however, the apply feature for credits and the entry of credit memos can only be used against invoices, and not against the over applied payments.
If the over applied payment is from a check receipt, the check can be reversed in Common Services – Bank Transactions – Reverse Transactions, but if the payment was received via credit card, through Sage Payment Solutions, that transaction cannot be reversed.
If the customers balance is correct, no action needs to be taken. When the next payment is received, it may be applied to that over payment record. Only new payments can be applied against the over payment, and it can only be completed at the time payment is received.
If the balance is incorrect, a credit memo should be created, but it cannot be applied against the over applied payment. The customer balance will be correct, but the aged receivables will show a credit balance and an equal over applied payment balance. In order to clean up your records, a zero dollar receipt can be entered and applied to both the over applied payment and the credit memo. This will remove both transactions from the A/R Aged Trial Balance.
If you have this problem, please feel free to contact me at Michael.Ericksen@wacptrs.com.