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
- Go to Liquidity Management work center.
- Go to Inbound Files view.
- Click New -> Inbound File.
- Fill out the required fields.
- Upload the .txt file to the Attachments section.
- 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