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

IBAN in MT940

Hi All,

I am facing an issue in Importing Bank statement for a leading Bank in Europe.

The Bank is sending the IBAN instead of bank account number in Tag 25.

We are importing the bank statement with Elect. bank statement format as I in FF_5.

Now the basic requirement of this Format (I) is the IBAN should be unique, i.e. the IBAN should be appearing once & only once in TIBAN table.

But the Company Code for which the bank statement is imported is also created as Inter-company Vendor for Inter-company transactions.The bank details of the vendor (Company Code) is the same house bank.

Now this is causing the conflict & our bank statement is not imported. I need your inputs on how to handle this situation.

Regards

Nitin

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

1 Answer

  • Best Answer
    Posted on Feb 10, 2014 at 11:21 AM

    Dear Nitin,

    Please test leaving T012K-BNKN2 empty, the iban is entered in FI12

    clicking IBAN, which will be stored in TIBAN based on the main bank

    account.

    If T012K-BNKN2 is maintained, this is the value that will be checked

    not IBAN and in the file IBAN is specified not alternative account

    number which cannot be definitively longer than 24 characters.

    Regards

    Gaurav

    Add a comment
    10|10000 characters needed characters exceeded

    • Hello Nitin,

      Please check the correct entry once again in FI03 by giving the input details as bank country and bank key. Here you can get the correct details of bank key and bank a/c no. combination and then you can go and delete the duplicate entry.

      Please remember one more point also. If we have more than one entry with Bank country, Bank key combination in this situation IBAN No. will get changed according to the bank account no.

      In the above scenario Bank A/c no & IBAN is same ( probably country key also same) but Bank key no. is varying. So please find the correct entry through FI03.

      Set the deletion flag for the duplicate entry through FI06.

      Please do the above stated modifications and try again.

      Thanks & Regards,

      Lakshmi S

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.