Routing number in USA

[former_member222946]

Hi everybody,

I need some help because we are on a roll out proyecto for a company located in USA and I have some doubts about how some settings should be done.

We know that for wire and ach payments the routing number of the house bank/bank account is different but do not really know what to enter as bank data and what as account number, and more specifically:

- Where to enter the routing number on tx. FI12

- Where to enter the routing number for the BP on FK01, FD01 transactions for vendors/customers bank master data (on Bank type?)

- Posible codifications of the routing number

Could somebody help me ? Thanks in advances.

Best Regards,

Abdali

[Former Member]

Hello-

You should enter routing number in SAP Bank Key field. In FI12, you would enter your house bank code which can have only one bank key. So, lets say you have two accounts with wells fargo with two different routing numbers, one is for checks and one is for wires, you would create two house banks each assigned with one bank key. Next, in FI12 you would assign all the bank accounts to your bank keys.

For example, you use wells fargo as bank and you have two routing numbers. One for check and one for wires. The routing number you have for check has three accounts - checking, savings and payroll. The routing number you have for wires has only one account - Checking. Below is how your structure looks like:

House Bank Bank Country Bank Key Bank Name

WY US 11112211 WELLS FARGO A

WZ US 11112212 WELLS FARGO B

Now to enter bank accounts, it will look like:

House Bank Account ID Bank Account Text

WY 01 123123123 CHECKING

WY 02 234123213 SAVINGS

WY 03 897897897 PAYROLL

WZ 01 234324234 WIRES

Coming to your other question regarding entering Bank information in vendor master, in FK01 transaction you would enter bank details in "Payment transactions" tab. Here you would key in bank country, bank key (routing number), name, checking or savings indicator and if you use ACH CTX format, key in CTX in the reference details field.

Hope this helps.

Shail

[former_member222946]

Hi Shailender,

Thanks for your help. It has almost answered all my doubts but now I've got new ones: For CCD or PPD ACH transactions should I enter something in any field (as reference in bank details for vendors).

Thanks a lot.

Regards,

Abdali

[Former Member]

Its been a while i worked with these formats. Try not entering anything in the reference field section of vendor master payment transactions tab and run a test. I am guessing it should give you output in CCD format and if you key in PPD, it will give PPD format.

Generally it is ideal to use CTX format as it will have vendor invoice details (addendum records).

Good Luck.

Shail