Symptom
Reprocessing bank statement items failing into error "House bank & & is not assigned to G/L account & in company code &" (FINS_ACDOC_POST133).
Environment
SAP S/4HANA Cloud Public Edition
Reproducing the Issue
- Upload bank statement files via App Manage Incoming Payment Files.
- Check imported bank statements in Reprocess Bank Statement Items App.
- Check the Log of failed bank statements.
- Error: "House bank & & is not assigned to G/L account & in company code &".
In this case example let's simulate the issue with the following data:
House bank ABC01/ABC01 is not assigned to G/L account 1010101090 in company code XXYY.
Message no. FINS_ACDOC_POST133
Procedure
Choose a different combination of house bank/account or change G/L account.
House Bank: ABC01
House Bank Account: ABC01
Company Code: XXYY
Bank Reconciliation Account: 1010101010
Bank sub-account: 1010101090
Cause
The error is raised as the bank reconciliation account or bank sub-account is not configured correctly.
Resolution
Depending on different business needs, either a bank reconciliation account or a balance sheet account can be assigned to the house bank account in "Manage Bank Accounts" App.
When the bank reconciliation account is activated for the house bank account, the bank subaccount is derived by the account symbol.
- Check bank reconciliation account in Manage Bank Accounts App under House Bank Connectivity of ABC01/ABC01/XXYY.
- Bank Reconciliation Account is set to 'Yes' and G/L Account is maintained as 1010101010.
- Check the account symbol used in the posting rules, such as TRANSF.
- Check the G/L Account of the account symbol under 'Assign Accounts to Account Symbols' in configuration "Make Global Settings for Electronic Bank Statement" (ID: 101024). For example, TRANSF is ++++++++90.
- The G/L Account 1010101090 (masked as ++++++++90) is a bank sub-account.
- Check in Manage G/L Account Master Data App if bank reconciliation account is linked to this bank sub-account.
Bank Sub Account (Clearing account) Example:
G/L Account: 1010101090
Company Code: XXYY
G/L Account Type: Cash Account
G/L Account Subtype: S (Bank Subaccount)
Reconciliation Accnt: 1010101010
Account Group: FIN (Liquid Funds Accounts)
A bank sub-account needs to be configured as above, otherwise error occurs during bank statement processing.
Also note that, in the backend table of the bank statement, the bank reconciliation account is stored at the time of the bank statement upload.
And the value will not be updated based on changes made to the bank account.
Therefore, changing the bank reconciliation account of the house bank will not affect bank statements that have already been uploaded.
See Also
KBA 3059653 - Bank determination for Payments using Single Reconciliation Account for Bank Accounts.
Community Blog How to use Bank Reconciliation Account in Payment Program.
Keywords
Bank Reconciliation Account, Bank Sub-account, House Bank Connectivity, Manage Bank Accounts, Account Symbol, 101024, Make Global Settings for Electronic Bank Statement, Cash Account, Bank Statement, Reprocess, FINS_ACDOC_POST13 , KBA , FI-FIO-AR-PAY-2CL , Payment Apps: Public Cloud , FI-BL-PT-BA-2CL , bank statement (Public Cloud) , Problem
SAP Knowledge Base Article - Public