cancel
Showing results for 
Search instead for 
Did you mean: 
Read only

BRS (Bank Reconciliation Statement)

sai_kumar1
Explorer
0 Kudos
1,586

Hi Experts,

Similar to the checks I created bank transfer incoming and outgoing g/l as sub banks for which main bank g/l is given in master data.

1. Bank Transfer Incoming: 11010010 for this external transaction type 030 which created/customized using posting F002 (checks In).

sai_kumar_1-1738060989303.png

2. Bank Transfer Outgoing: 11010020 for this standard external transaction type 020 is used, posting rule F004 (Transfer domestic/SEPA/Foreign).

sai_kumar_0-1738060930234.png

3. Main Bank G/L: 11000100

In APP: Manage Bank Statements when I click on post after providing the data. The system does not post the bank transfer incoming payments (External Transaction Type: 030 and Posting Rule: F002).

sai_kumar_2-1738061410351.png

I click on the reprocess for the incomplete item.

sai_kumar_3-1738061489217.png

Here system picks some other g/l instead of Bank Transfer Incoming: 11010010.

sai_kumar_4-1738061648089.png

Here I need to change the g/l Bank Transfer Incoming: 11010010 manually.

How can I solve this issue.

Moreover main bank account is shown correct closing balance. Please observe the below screenshots.

sai_kumar_5-1738061915651.png

sai_kumar_6-1738061936105.png

Thanks in advance.

Accepted Solutions (1)

Accepted Solutions (1)

joerg_rolapp
Product and Topic Expert
Product and Topic Expert

Hi @sai_kumar1 ,

F002 is a two-step posting rule. The first posting is done from main bank account to the tech account (+++++++090). This posting seems to be ok as your balance on 11000100 was updated correctly.

The second posting area was not done automatically. According to the posting rule it should be posted from the tech account to the checkrec account (+++++++060) This is the reason the Reprocess Bank Statement Items app proposes this account.

 

Best regards, Joerg Rolapp

sai_kumar1
Explorer
0 Kudos

Hi @joerg_rolapp ,

The standard for cheques in public edition is set as Cheque In (+++++60 g/l) and Cheque Out (+++++50 g/l). Similarly, I have created Bank Transfer In (11010010 g/l). My question is, what is the external transaction key for Bank Transfer In to be processed in the Manage Bank Statements app?

I couldn't find the external transaction key for Bank Transfer In either, so I created a new external transaction key, 030, by copying from the 070 transaction key and assigned it to the posting rule F002. Is this process correct? Please find the screenshot below.

sai_kumar_0-1738662624483.png

Note: For Bank Transfer Out standard in public cloud is +++++020 and external transaction key is 020.

Answers (1)

Answers (1)

Anita_Ahmadpour
Product and Topic Expert
Product and Topic Expert

Hi Sai Kumar, 
@sai_kumar1 

I'm afraid I cannot help you solve the problem you're facing. However, I really recommend you to start using processing rules instead of posting rules! Processing rules are the successor functionality of the posting rules and are more precise. You can create and edit (and even automate) processing rules in the Manage Processing Rules app in your SAP S/4HANA Cloud Public Edition system. 
Processing rules mainly consist of conditions and actions, and determine exactly how a bank statement item must be posted. They determine which accounts are posted to on debit and credit sides, and also whether or not the respective debit or credit side is cleared.

For more detailed information, see the following help links and their subordinated pages: 

I hope that this information helps you further. And hopefully another product expert can have a look at the problem you have decribed. 🙃

Best regards,

Anita

sai_kumar1
Explorer
0 Kudos

Hi Anita_Ahmadpour

@Anita_Ahmadpour 

After doing R&D I came up with the solution that in configuration level I provide same masked g/l for the both checkIn (21010010) and Bank Transfer Incoming (11010010)

sai_kumar_0-1738135156839.png

In Make Global Settings for Electronic Bank Statement configuration where I provide same masked g/l for the both checkIN and Bank Transfer Incoming.

sai_kumar_2-1738135900755.png

sai_kumar_3-1738136300892.png

Please correct me if i am wrong.