Electronic Bank Statement in SAP - Account Determination and Masking

[former_member594341]

I am configuring Electronic Bank Statement Functionality for one of my clients and using BA12 format. This client does not want to use the masking (+++++++++) functionality. They have sub accounts for clearing in Canadian Dollar and US Dollar. Example Main Bank CAD - 1001101, Main Bank USD - 1001102, Cheque Clearing CAD - 1001111, Cheque Clearing USD - 1001112, ACH clearing CAD - 1001121, ACH Clearing USD - 1001122, Wires Clearing CAD - 1001131, Wires Clearing USD - 1001132. Can I use Masking in this case if I want to? If so, how?

The problem I am facing is that the external transaction that is used by bank for cheques clearing is 475 and it is the only one code used for all the currencies. Can I use the same transaction code 475 for both US and Canadian (Using multiple posting rules as below)? If so how can I configure and what do I need? They have only two currencies CAD which is local currency and USD is the foreign currency. Any inputs would be greatly appreciated. Is it possible to configure EBS without using masking functionality in this scenario?

External Transaction code 475 - Debit Cheques Clearing CAD, Credit Main Bank CAD (Posting Rule 1)

External Transaction Code 475 - Debit Cheques Clearing USD, Credit Main Bank CAD (Posting Rule 2)

Can I do the above configuration? Would EBS job pick up the correct bank accounts based on the currencies?

Please help!

[polaggari]

Hi Arun,

You have two options here:

Option 1- go for masking

Step 1: Account symbols: Main Bank +++++++

Chec Clearing +++++1+

ACH Clearning +++++2+ etc..

Step 2: Posting rules: PRCK- Check Dr

Main Bank Cr

Step 3: Assign posting rule to BTC in transaction type (TTYP)

475-PRCK

Step 4: Assign Bank accounts to transaction types:

Bank Key1-USD Account - TTYP (transaction type)

Bank Key1-CAD Account - TTYP (Transaction type)

That's the best way can do it. in the BAI2 statement you receive you will Account number, Currency, based on that system can take care of everything.

Option 2- without masking

Step 1: Account symbols:

Main Bank USA-1001102

Check USA-1001112

Main bank cad-1001101

check cad-1001111

Step 2: posting rules:

PR1 - Check USA Dr to Main Bank usd Cr

pr2: check cad Dr to Maint bank cad Cr

Step 3: Assign posting rule to BTC in transaction type

475-PR1 in TTYP1

475-PR2 in TTYP2

Step 4:

Assign Bank accounts to transaction types:

Bank Key1-USD Account - TTYP1 (transaction type)

Bank Key1-CAD Account - TTYP2 (Transaction type)

I would go with Option 1.

Feel free to post any further questions.

Please appreciate my answer without fail, it took me almost 30 minutes to just compose this for you 😛