2089501 - MT940 UK Bank Statement Upload Date Not Valid

When trying to create a new bank Statement by uploading an MT940 UK file error messages appear: 'Date YYYMMDD not valid for. No bank account active on [...] for account number XYZ, national bank code ABC, and currency DEF found'.

(XYZ represents the account number).

(ABC represents the bank code).

(DEF represents the currency).

SAP Business ByDesign

1. In the Liquidity Management workcenter navigate to the File Management - Inbound Files view.
2. Press New - Inbound File.
3. Maintain the mandatory data and the Import Format MT940 UK.
4. Under Attachments press Add- File.
5. Find the file that you want to upload and press Add.
6. Now press Start File Upload.
7. Error Messages appear: 'Date YYYMMDD not valid for. No bank account active on [...] for account number XYZ, national bank code ABC, and currency DEF found'.

The bank Statement date maintained in tag :20: of the MT940 UK file is not maintained in the correct format YYYYMMDD.

1. You need to correct the date maintained in the tag :20: in format YYYYMMDD.
2. The easiest way to do this is by converting the 940 file to a text file, by changing the ending of the file to .txt.
3. Open the file and correct the date in tag :20: by applying the correct format YYYYMMDD.
4. You can either keep the txt format of the corrected file or convert it back to 940 file format, just by changing the ending of the file back to .940.
5. Then add and upload the file again:
6. In the Liquidity Management workcenter navigate to the File Management - Inbound Files view.
7. Press New - Inbound File.
8. Maintain the mandatory data and the Import Format MT940 UK.
9. Under Attachments press Add- File.
10. Find the corrected file that you want to upload and press Add.
11. Now press Start File Upload.
12. This time the bank statement will be uploaded.

 MT940 UK, Bank Statement, Upload, Date, Not Valid. , KBA , SRD-FIN-CLM , Cash and Liquity Managment , How To