Symptom
Bank statement processing is failed due to the error "G/L Account XXXX YYYY does not exists". The error message can be found in the log in the Reprocess Bank Statement Items app after the bank statement is imported through Manage Incoming Payment files app or manually created using Manage Bank Statements.
Environment
SAP S/4HANA Cloud
Reproducing the Issue
- Go to Manage Bank Statements.
- Manually create a bank statement and post it.
- The status of the bank statement is "Not Completed".
- Check the Log in Reprocess Bank Statement Items app.
Cause
The G/L account is not created as per the G/L account configuration maintained in the account symbols in the SSCUI Make Global Settings for Electronic Bank Statement - 101024.
Resolution
The G/L accounts for bank statement processing are determined based on the account symbols and posting rules maintained in the SSCUI Make Global Settings for Electronic Bank Statement - 101024.
You can find the list of posting rules provided as part of Standard SAP S/4HANA Cloud product here: Overview of Posting Rules.
Consider posting rule F008 as an example. The posting rule F008 is defined as below:
Posting Rule | Description of Posting Rule | Posting Area | Debit Posting Key | Debit Account Symbol | Credit Posting Key | Credit Account Symbol | Journal Entry Type | Posting Type |
F008 | Cash receipt | 1 | 40 | BANK | 50 | TECH | SA | 1 |
F008 | Cash receipt | 2 | 40 | TECH | CASHREC | SA | 5 |
The G/L account for CASHREC and TECH account symbols are determined based on the G/L account assigned in the house bank account and the masked G/L account assigned to the account symbols in the SSCUI 101024.
Suppose the G/L account assigned in the house bank account is 10100000 and the configuration in SSCUI 101024 is as below:
CASHREC +++++++010
TECH +++++++090
As per this configuration, the G/L accounts will be determined as below: (last 3 digits of the main bank G/L account will be replaced by the digits in the masked G/L account in the SSCUI 101024)
CASHREC 10100010
TECH 10100090
User should ensure that the G/L accounts based on the above configuration are created in the app Manage G/L Account Master Data in order to avoid such errors.
See Also
Keywords
F5106, BRS, F0731, EBS, Manage Bank Statements, Not Completed, Post, Display Item, Reprocess, Company code, G/L account, FI-BL-PT-BA, FI-FIO-AR, S4_PC, S4_1C , KBA , FI-BL-PT-BA-2CL , bank statement (Public Cloud) , FI-FIO-AR-2CL , Fiori UI for Accounts Receivable (Public Cloud) , Problem