After uploading MT940 I am doing Bank Reconciliation and trying to match the amount manually. But I am getting this error “The difference between statement line amount -23,500,000.00 and total amount of bank documents 23,500,000.00 exceeds the allowed penny difference.”. Does Anyone face this before?
You may need to increased the maximum penny difference in parameters form GL
Thanks for reply Krishna … I already have doe this but no luck … in coding part I went through the logic where system is calculating credit and debit amount… For this particular error system is looking for 0 value after deducting these values.
But system is adding both value and throwing this error.
like :-
Credit Value = - 5000
Debit value = 5000
system condition = abs (Debit value - Credit Value)
= abs (5000 - (-5000))
Here negative * negative turn to positive value so the final values are
syetsm condition = abs (5000 + 5000)
system value = 10000
For this we can’t set the penny difference every time…
Not sure if it’s a Microsoft Bug or purposely they did it.
- Is there any customization involved in the current system?
- Which module & form you are using for reconciliation.
Nothing is customized there … I am doing it from Cash And Bank Module…
Well in that case, register a support ticket with Microsoft.
They may have suggest you a relevant hotfix for the issue.