Changing the bank key of House Bank

[Former Member]

Hi Experts,

We have done the house bank configurations with a common bank key, for several bank accounts we maintained at a particular bank branch. Now I'm doing the Electronic Bank Statement Configurations for these account.

The bank sends the EBS in Multicash format and there the bank has assigned a different bank key to the foreign currency accounts to differentiate them form local currency accounts. We requested the bank to change the bank key of these accounts as per bank key defined in the system. However, the bank informed us that it is not possible.

To accommodate the EBS, I tried to change the bank key of the house bank and then the corresponding bank account details got disappeared . When I tried to make a new entry to bank account details, it does not permitted to do so saying "An Entry Already exists with the same key". We are not in a position to change the house bank code or account ID as those have been mapped under  the payment settings to enable automatic payments with the bank.

Can any one suggest a way to change the bank key of a house bank to accommodate EBS 

Thanks in advance.

Regards,

Pradeep J.

[Former Member · Accepted solution]

Hi

Step 1 - Go to SE16 and in table T012K check if the bank accounts are still there.

Step2 - If the accounts are there but it is now showing up in FI12, then go to SM30 and put the table name T012K. Then click on the icon . It will show the table name as T012K and click continue.

Step3 - System will open up a list of objects. From that list select the object VCL_T012_CORE.

Step4 - In the next screen you click on maintain.Enter the company code and after that it will show up all the house banks maintained in the FI12. Select the desired house bank and click on the bank accounts. It will now show you those bank accounts which you can not see any FI12 but still there in the T012K table.

Step5 - Delete those bank accounts.

Step 6 - Now go to FI12 and maintain those bank accounts with correct details.

Alternatively you can try to edit the bank account in the multicash bank statement file and try to upload that in quality system first. if that is successful, then you can do the same exercise in production system.

I hope this will resolve your issue.

Regards,

Pintu

[Former Member · Accepted solution]

Thanks Pintu.

I was able to change the bank key as per your instructions.

[former_member182098]

What is the bank key that you are referring to on the Electronic Bank Statement.

Which tag line?

You do not need to delete any of the bank keys you have created. You can use as it is.

On the tag line :25: you will have the bank key / SWIFT code. If they are using a different bank key that the one you have configured, you enter the bank key used by the bank in your FI12 configure in the field "Alternative Account Number" BNKN2

If bank is using SWIFT code ensure that you have swift code in your bank master data in FI03

[Former Member]

Hi Ravi,

I'm referring to the "Bank Key" field of the Multicash format bank statements.

[nico_dewaele]

hello,

delete the current settings. save and leave the transaction and then restart to create the bank account again with a the new bank key.

kr

Nico

[Former Member]

Dear Pradeep,

Please confirm, for creation of new bank key, you have different IFSC codes or not?? If yes, then you can create new Bank key & also you can assign it to house bank. (Relation Is 1:1)

Regards,

Omkar C Kulkarni

[Former Member]

Hi Omkar,

Could you please explain what is meant by IFSC ?