Skip to Content
0
Former Member
May 03, 2012 at 07:10 AM

Electronic Bank Reconciliation Issue

429 Views

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