Symptom
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).
Environment
SAP Business ByDesign
Reproducing the Issue
- In the Liquidity Management workcenter navigate to the File Management - Inbound Files view.
- Press New - Inbound File.
- Maintain the mandatory data and the Import Format MT940 UK.
- Under Attachments press Add- File.
- Find the file that you want to upload and press Add.
- Now press Start File Upload.
- 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'.
Cause
The bank Statement date maintained in tag :20: of the MT940 UK file is not maintained in the correct format YYYYMMDD.
Resolution
- You need to correct the date maintained in the tag :20: in format YYYYMMDD.
- 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.
- Open the file and correct the date in tag :20: by applying the correct format YYYYMMDD.
- 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.
- Then add and upload the file again:
- In the Liquidity Management workcenter navigate to the File Management - Inbound Files view.
- Press New - Inbound File.
- Maintain the mandatory data and the Import Format MT940 UK.
- Under Attachments press Add- File.
- Find the corrected file that you want to upload and press Add.
- Now press Start File Upload.
- This time the bank statement will be uploaded.
See Also
Keywords
MT940 UK, Bank Statement, Upload, Date, Not Valid. , KBA , SRD-FIN-CLM , Cash and Liquity Managment , How To
Product
SAP Business ByDesign all versions