Symptom
Error occurs when uploading a bank statement file:
Conversion Result is Empty.
Environment
SAP Business ByDesign
Reproducing the Issue
- Go to the Liquidity Management work center.
- Go to the File Management - Inbound Files view.
- Press the New button and select the option Inbound File.
- Press the Add button and select the option File.
- Once the file location is specified, press the Start File Upload button.
The upload process fails and the error message "Conversion Result is Empty" is shown.
Cause
The uploaded file does not have line breaks. Hence the conversion program interprets the file as having only one line and the upload process cannot be finished successfully.
Resolution
Bank statement files structure is based on a file format alike the BAI2 format for the United States or the MT940 format for Germany.
Those predefined formats define the structure of the file.
Each line within the structure starts with a predefined tag and each line has to be separated from the previous one by a line break character.
If the file you upload does not contain line breaks before each tag the application will not be able to interpret the file and will show the error message instead of finishing successfully the upload. as a consequence no banks tatement instance will be created.
Examples of a correct file structure for a MT940 format:
:20:
:25:14091200/111111
:28C:15/1
:60F:C110327EUR48000,00
:61:1103270327CR1000,00NMSC05100733827
:86:051?00TRANSFER-CREDIT MEMO
?10995904
?20TK-230312,CDZU,5100733827
?21QWERTY
?22PERSONALNUMBER 00044
?3020040000
?310200061507
?32TK-220312,AB629,569
:62F:C110327EUR49000,00
Examples of an incorrect file structure for a MT940 format missing line break characters:
:20::25:14091200/111111:28C:15/1:60F:C110327EUR48000,00:61:1103270327CR1000,00NMSC05100733827:86:051?00TRANSFER-CREDIT MEMO?10995904?20TK-230312,CDZU,5100733827?21QWERTY?22PERSONALNUMBER 00044?3020040000?310200061507?32TK-220312,AB629,569:62F:C110327EUR49000,00
Remark: You can visualize the real file format by opening it in Notepad which does not re-format it automatically on opening as, for example, Notepad++, using the feature "show all characters", each line of the file should finished by <CR LF> (Return Carriage Line feed) and with no blank line in between.
For Notepad++:
- Open the file in Notepad ++
- Go to Tab: "View"
- Then "Show Symbol" and then "Show All characters"
If you see only <LF> you can change it to <CR LF> with the following steps.
- Click Edit
- Go to EOL Conversion
- Choose Windows (CR LF)
This will correct the end of line to <CR LF>.
Keywords
CR; LF; CRLF; Carriage Return; Line Feed , KBA , SRD-FIN-CLM , Cash and Liquity Managment , How To