3809525 - G/L Account Balance Does Not Match Open Items in Current Period for Open Item Managed G/L Account

Open item management is active for a G/L account XYZ. The balance shown in the open item list does not match the total balance of the G/L account XYZ.

Here XYZ represents G/L account.

SAP Business ByDesign

1. Go to the General Ledger work center.
2. Open the General Ledger Accounts view.
3. Apply an Advanced Filter and select the relevant Company, Set of Books, and the G/L Account XYZ for which Open Item Management is active.
4. Observe the Account Balance displayed for G/L Account XYZ.
5. Select 'Edit' for G/L Account XYZ and navigate to Open Items in Current Period.
6. Compare the values displayed under Open Items in Current Period with the Account Balance.
7. A discrepancy is observed, as the Account Balance does not match the total of the Open Items in Current Period.

The Open Item Management list and the G/L account balance are not directly comparable because the Open Item Management view only considers postings without subledger involvement. However, the G/L account balance includes postings from all subledger types as well as postings without subledger involvement.

To verify this,

1. Open the G/L Account Line Items report for the affected G/L account.
2. Add the Balance Company Currency key figure.
3. Add the Subledger Account Type attribute to the report.
4. Review the balances by filtering for Without Subledger and the relevant Subledger Account Types.
5. The combined balance across all subledger types will match the total G/L account balance.

This behavior is expected, as the G/L account balance represents all postings to the account.

open item management, general ledger, G/L account, balance mismatch, subledger postings, sales subledger, without subledger, miscellaneous subledger, reconciliation, line items report, Balance Company Currency, Subledger Account Type, ByDesign, Open Item, period with no items , KBA , SRD-FIN-GL , General Ledger , Problem