The error message “The transactions on voucher XXX do not balance as per [date]. (accounting currency: 50,00 – reporting currency: 50,00)” in open customer transactions settlement
There might be a situation when you are not able to settle customer transaction with payment due to error message “The transactions on voucher XXX do not balance as per [date]. (accounting currency: 50,00 – reporting currency: 50,00)” (when the amount in error message is full invoice amount).
Cases when this issue can occur:
1. You have enabled the “Mark lines on free text invoices and interest notes” in AR/Setup/Tab Settlement/AR parameters.
2. Post Free text invoice for a customer.
3. Delete posted FTI in step 2 (it was possible to delete posted FTI before R2 CU7, but the hotfix KB 2878451 solves this issue in 6.2.1000.2487).
4. Create payment journal and try to settle it with invoice transaction posted in step 2. (or you can have payment posted and settle open transactions later).
Actual result: the error appears “The transactions on voucher XXX do not balance as per [date]. (accounting currency: 50,00 – reporting currency: 50,00)” (when the amount in error message is full invoice amount).
Solution: disable the parameter “Mark lines on free text invoices and interest notes” and then settle open transactions again. Settlement should be posted successfully. Go back and enable the “Mark lines on free text invoices and interest notes” parameter again.
If you have the hotfix KB 2878451 installed, you should not be faced with this issue.