SAP Knowledge Base Article - Public

3458244 - Error "G/L account XXXX YYYY does not exist" in Reprocess Bank Statement Items app - SAP S/4HANA Cloud Public Edition

Symptom

  1. 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.
  2. Reprocess Bank Statement error occurs "Posting is only possible with zero balance."

Environment

SAP S/4HANA Cloud Public Edition

Reproducing the Issue

  1. Go to Manage Bank Statements.
  2. Manually create a bank statement and post it.
  3. The status of the bank statement is "Not Completed".
  4. 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.
  • 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 RuleDescription of Posting RulePosting AreaDebit Posting KeyDebit Account SymbolCredit Posting KeyCredit Account SymbolJournal Entry TypePosting Type
F008Cash receipt140BANK50TECHSA1
F008Cash receipt240TECH CASHRECSA5

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.

Note: 

  1. The Account Symbol assigned to BANK should be ++++++++
  2. The masked entries (using a plus sign +) are always based on a ten-character account number.
  3. If a shorter account number is used (six characters, for example), the entries must be right-aligned.
  4. Example:
    • If the main bank account is 221010 and the masking is done as +++++1, then the GL account will be picked as 21, which is incorrect.
    • The masking should be done as +++++++++1, so that the correct GL account is picked as 221011.

See Also

2854415 - Information on Bank Statement Posting Rules in SAP S/4HANA Cloud system

2378951 - Error - F5 106 " G/L account & & does not exist during EBS "

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, Masking, Mask, Posting is only possible with zero balance, Reprocess Bank Statement Items , KBA , FI-BL-PT-BA-2CL , bank statement (Public Cloud) , FI-FIO-AR-2CL , Fiori UI for Accounts Receivable (Public Cloud) , Problem

Product

SAP S/4HANA Cloud Public Edition all versions