SAP Knowledge Base Article - Public

2934581 - Error While Uploading a Bank Statement With MT940 DE File Format Due to IBAN House Bank Account Identifier

Symptom

You are unable to upload a Bank Statement using the File Format M940 DE due to error messages.

Environment

SAP Business ByDesign.

Reproducing the Issue

  1. Go to the Liquidity Management work center.
  2. Go to the Inbound Files view.
  3. Click New -> Inbound File.
  4. Enter the File Type as Bank Statement and select Import Format as MT940 DE.
  5. Add the relevant file.
  6. Click Start File Upload.

System raises the error messages below:

'No bank account active on DD.MM.YYYY for account number, national bank code, currency ABC found'

'Bank account missing or cannot be determined'

'Bank Statement ID XXX for Bank Account ID rejected'

DD.MM.YYYY - Date

ABC - Currency

XXX - Bank Statement ID

Cause

The errors are raised because in the tag 25 of the file only the IBAN is being maintained.

Currently it is not supported to use only the IBAN Number to determine the Bank Account with File Format MT940 DE.

Resolution

An Internal Development Request has been added to the Product Backlog in order to enhance the functionality with this feature in one of the future product releases.

As a workaround it is possible to use the Alternative Account Number in combination with the IBAN Number as follows:

  1. Go to the Liquidity Management work center.
  2. Go to the My Banks view.
  3. Select the relevant Bank.
  4. Click Edit -> Bank Accounts.
  5. Populate the IBAN Number in the Alternative Account Number field.
  6. Then, in the tag 25 of the file, it is required to maintain the BIC + IBAN, following the example:

Bank Statement Header

:25:BIC/IBAN

Keywords

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

Product

SAP Business ByDesign all versions