SAP Knowledge Base Article - Public

1860455 - HSBCNET MT940 Format Statement Error

Symptom

You receive the following errors while uploading a bank statement using MT940 format

Bank statement ID XX for bank account ID rejected

Date YYMMDD not valid for

Reproducing the Issue

  1. Go to Liquidity Management work center
  2. Go to File Management view and select Inbound Files sub view
  3. Click on New and select Inbound File
  4. Under Attachments click Add and select File
  5. Add the file and click on Start File Upload

You receive the error messages.

Cause

The error messages appear as the information in the TAGS is not consistent in the MT940 file supporting format used in the bank statement.

Resolution

The date format in TAGS under Tag 20 should be maintained as YYYYMMDD instead it was maintained as YYMMDD

Example: Tag 20        : 20: 20130305 

Keywords

KBA , SRD-FIN-GL , General Ledger , How To

Product

SAP Business ByDesign all versions