2089501 - MT940 UK Bank Statement Upload Date Not Valid

SAP Knowledge Base Article - Public

2089501 - MT940 UK Bank Statement Upload Date Not Valid

Symptom

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

Reproducing the Issue

  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 YYMMDD 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

  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.

Keywords

KBA , SRD-FIN-CLM , Cash and Liquity Managment , How To

Product

SAP Business ByDesign all versions