Symptom
The bank statement Inbound file for the import format MT940 XX is being attempted to be uploaded. The upload is terminated with an exception or an error message.
(XX represents the country)
Environment
SAP Business ByDesign
Reproducing the Issue
- Go to Liquidity Management work center.
- Go to File Management view and select Inbound Files subview.
- Click New and select Inbound File.
- Under Attachments click Add and select File.
- Add the file and click Start File Upload.
File Type: Bank Statement
Company: 123
Bank ID: PRQ
Import Format: MT 940 XX
System throws the error message: 'Unexpected Error During Backend Processing'
Cause
As per MT 940 format in Tag 25, it is expected to have either International Bank Account Number (IBAN) or Society for Worldwide Interbank Financial Telecommunication (SWIFT - Bank Identifier Code) /Account Number.
The MT 940 format is not complied with in the file submitted, as the tag :25: only appears to contain the Account Number.
Ex: In the MT 940 file the tag 25 looks like in the below format preceding by tag 20 here the format is incorrect for tag 25 without preceded by SWIFT BIC.
:20:STYYDL123767604E
:25:00123456
If the account number consists only of numerical data (numbers only), the format should be BANK_ID/BANK_ACCOUNT_NUMBER, the tag :25 line does not include BANK_ID (followed by BANK_ACCOUNT_NUMBER). As a result, the account number is not being updated or mapped correctly.
Resolution
The SWIFT MT 940 version is supported in ByDesign, while the non-SWIFT version is not supported. It is necessary to maintain IBAN or SWIFT and proceed with the process.
In the below example the Tag 25 in the MT 940 should look in the format provided here.
:20:STMYYL123767604E
:25:00123456/09375684947.
In case of account number consists only of numerical data (numbers only), the correct format should be as follows:
:25: 1234/5678910111
(1234 represents the Bank Account ID)
(5678910111 representes the Bank Account Number)
Although this formats are preconfigured, there are usually bank-specific characteristics that have to be considered and these may require further fine-tuning of your configuration settings (business transaction codes, for example). Contact your bank to verify the format and communication settings that are specific to your relationship.
See Also
Keywords
MT940; an error occurred; IBAN; Bank Account Number; Tag; :25: , KBA , SRD-FIN-CLM , Cash and Liquity Managment , How To