Electronic Bank Reconciliation Issue

[Former Member]

Hi Expert,

In my company we are running electronic bank reconciliation with MT940 format (We are using 940 unstructured format)

Suddenly I got the error saying "ISO code EU is not assigned to a currency key in the valid time period " but ISO code already there in the system

This error is occuring due to the following issue

In MT940 file, there are additional information's are appearing under field 86

I have uploaded this file by removing additional informations & it has been worked fine.

Please can you let us know is there any possibility to correct the above issue in EBRS configuration or Bank has to do the needful correction from their side since we are getting lot of transactions with these additional information's

Herewith I am attaching the MT940 text file & detail error for your more information's

Appreciate your valuable input regarding this

MT940 File -Issue Highlighted in Red

:20:9400124559371418

:25:200912004

:28:1850/1

:60F:C120110LKR0,00

:61:1201100110DR331890,50NCHK107315//0000107315

/CTC/754/MICR CLG CHQ WITHDRAWAL

:86:/PT/DE/EI/007287086                       107315

:61:1201100110DR183248,50NCHK107320//0000107320

/CTC/754/MICR CLG CHQ WITHDRAWAL

:86:/PT/DE/EI/007010612                       107320

:61:1201100110DR683350,25NCHK107325//0000107325

/CTC/754/MICR CLG CHQ WITHDRAWAL

:86:/PT/DE/EI/007162000                       107325

:61:1201100110DR207836,00NCHK107143//0000107143

/CTC/754/MICR CLG CHQ WITHDRAWAL

:86:/PT/DE/EI/007214900                       107143

:61:1201100110DR261654,40NCHK107146//0000107146

/CTC/754/MICR CLG CHQ WITHDRAWAL

:86:/PT/DE/EI/007056032                       107146

:61:1201100110DR1800,00NCHGOTT36374//3142010181

/CTC/001/COMM/CHARGES/FEES

:86:/PT/FT/PY/MIFT 664917                        IMPORT OF CANDOL

55 S AS PER       PROFORMA INVOICE NO A108155/OA/EUR651,60/OCMT/

EUR651,60/BI/AT962011100009816194/BN/CANDOL PRODUKTIONS- U/AB/GIB

AATWW/CM/LKR1800,00/CA/200912004/ER/146,8

Error Massage in SAP

ISO code EU is not assigned to a currency key in the valid time period

Message no. B1882

Diagnosis

No internal code assignment was found for ISO code EU for currencies (table TCURC). Either the internal code does not exist, or it is not assigned to the ISO code.

Procedure

Assign an internal code to the ISO code.

Regards

Chrishantha

[former_member436737 · Accepted solution]

Dear Chrishantha,

Kindly notice, that the reason of getting this error is indeed the line
break between key word /OCMT/ and the Currency/amount.

If you use a unstructured file the lines will not be concatenated,
because the SWIFT specification says for unstructured 86-fields no
line breaks within information are allowed.
The structured 86-field allows line breaks, so the program would
concatenate lines.

As mentioned there is a line break after the /OCMT/ and the currency
in your file (/OCMT/ at the end of a line,EUR at the beginning of the
next one):

86:/PT/FT/PY/MIFT 664917                        IMPORT OF CANDOL 

55 S AS PER       PROFORMA INVOICE NO A108155/OA/EUR651,60/OCMT/ <<<<<<

EUR651,60/BI/AT962011100009816194/BN/CANDOL PRODUKTIONS- U/AB/GIB

AATWW/CM/LKR1800,00/CA/200912004/ER/146,8

Please advise your bank to provide you with a valid SWIFT-File; either

not to cut the OCMT-information with a line break, or to provide you

with one containing a proper structured 86-field.

Hope this helps you with this issue,

Kind regards,

AZ