cancel
Showing results for 
Search instead for 
Did you mean: 

BRS (Bank Reconciliation Statement)

sai_kumar
Explorer
0 Kudos
401

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.

View Entire Topic
joerg_rolapp
Product and Topic Expert
Product and Topic Expert

Hi @sai_kumar ,

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_kumar
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.