SAP Knowledge Base Article - Public

2507538 - System Crash Upon MT940 Bank Statement Upload

Symptom

You have tried to import a MT940 Bank Statement file into the system, however a backend exception occurred.

Environment

SAP Business ByDesign.

Reproducing the Issue

  1. Go to Liquidity Management work center.
  2. Go to Inbound Files view.
  3. Click New -> Inbound File.
  4. Fill out the required fields.
  5. Upload the .txt file to the Attachments section.
  6. Click Start File Upload.

The system ends with a backend exception.

Cause

One of the possible causes is that in the MT940 .txt file, you have specified the transaction amount (tag :61:) in parenthesis, reason being you want to represent a negative amount.

For example: 61:1707300730C(3475,88)NONREF

The system does not interpret the amount in tag :61: as a number since it is not as per MT940 standard, hence the exception is raised.

Resolution

For the MT940 specification, the amount is only represented with comma for decimal separator.

In order to define the payment direction, you specify the Funds Code element within tag :61:

Funds Code can be:
C for Credit
D for debit
RC for Reverse Credit
RD for Reverse Debit

For example:
 61:1707300730C3475,88NONREF-> incoming payment in bank statement
 61:1707300730D3475,88NONREF-> outgoing payment in bank statement

See Also

Keywords

Bank Statement Upload, MT940, Dump. , KBA , SRD-FIN-CLM , Cash and Liquity Managment , How To

Product

SAP Business ByDesign all versions