Symptom
You've uploaded a bank statement file with MT940 NL import format. Upon verifying the bank statement created by the system you notice that the Closing Balance is incorrect: the system calculated the amount as a negative value (e.g. -100.000,00 EUR) when it should be positive (e.g. 100.000,00 EUR).
Reproducing the Issue
- Go to Liquidity Management work center
- Go to Bank Statements view
- Find the respective Statement ID
Notice that its Closing Balance shows up as a negative amount (with a minus sign) when it should be positive.
As a result the system throws the error message:
ID 123: Calculated closing balance 100.000,00 Euro is different from stated - 100.000,00 Euro
The ID, the amounts and the currency are just an example here.
Cause
In the last part of closing tag ":62F:" you've entered a final mark of message "-" when it should be "-}{5:}".
Please note that sign " is not part of the bank statement file and has been used for better illustration here.
Resolution
You should upload the file again with correct final mark of message "-}{5:}" and the Closing Balance will be correct.
Keywords
KBA , SRD-FIN-CLM , Cash and Liquity Managment , How To