When you upload a bank statement file you receive the error message Conversion Result is Empty.
Reproducing the Issue
- Go to the Liquidity Management work centre.
- Go to the File Management - Inbound File 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.
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.
Bank statement files structure are based on a file format alike the BAI2 format for the United States or the MT940 format for Germany.
Those pre-defined formats define the structure of the file.
Each line within the structure starts with a pre-defined 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:
Examples of a 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
NB: 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.
KBA , SRD-FIN-CLM , Cash and Liquity Managment , How To