Skip to Content
author's profile photo Former Member
Former Member

Electronic Bank Reconciliation Issue

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

Add a comment
10|10000 characters needed characters exceeded

Related questions

1 Answer

  • Best Answer
    Posted on May 03, 2012 at 08:51 AM

    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

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.