2452398 - Bank Statement Upload MT940 NL Format: Closing Balance Is Negative (Minus Sign) When It Should Be Positive

SAP Knowledge Base Article - Public

2452398 - Bank Statement Upload MT940 NL Format: Closing Balance Is Negative (Minus Sign) When It Should Be Positive

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

  1. Go to Liquidity Management work center
  2. Go to Bank Statements view
  3. 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

Product

SAP Business ByDesign all versions