SAP Knowledge Base Article - Public

2723994 - General Ledger Account Balance Calculation Difference in Reports

Symptom

You would like to understand how the general ledger account balances are calculated. As you see there is a difference in total in the report compared to the system.

Environment

SAP Business ByDesign

Reproducing the Issue

  1. Go to General Ledger work center.
  2. Go to view General Ledger Accounts.
  3. Chose Advanced button.
  4. Select the General Ledger account, Company, Set of Books.
  5. Select the period.
  6. Chose the button Go.
  7. Check the account balance.
  8. Now compare this result with the General Ledger Accounts - Line Items report with the same selection parameters.

You observe that the results are different.

Cause

The one reson could be the selection parameters that you are passing in the report and comparing it with the current data in the system is incorrect. The account balance in the system is cumulative. What you see is till the given period that is same as Trial Balance. But General Ledger - Line items is only for that period balance, only for that given selection.

There could also be other reason on why the balance is not the same.

Resolution

To get the desired result, you need to pass on the parameter as <= acc per in the period selection and not = acc per for any given period. Now the result in the report matches the result in the system.

Keywords

General Ledger Account Balance, G/L Account - Line Items, Report balance , KBA , SRD-FIN-ANA , Analytics Content , Problem

Product

SAP BUSINESS BYDESIGN 1611 ; SAP BUSINESS BYDESIGN 1705 ; SAP BUSINESS BYDESIGN 1708 ; SAP BUSINESS BYDESIGN 1902 ; SAP Business ByDesign 1.0 ; SAP Business ByDesign 1302 ; SAP Business ByDesign 1305 ; SAP Business ByDesign 1308 ; SAP Business ByDesign 1311 ; SAP Business ByDesign 1402 ; SAP Business ByDesign 1405 ; SAP Business ByDesign 1408 ; SAP Business ByDesign 1411 ; SAP Business ByDesign 1502 ; SAP Business ByDesign 1505 ; SAP Business ByDesign 1508 ; SAP Business ByDesign 1511 ; SAP Business ByDesign 1602 ; SAP Business ByDesign 1605 ; SAP Business ByDesign 1608 ; SAP Business ByDesign 1702 ; SAP Business ByDesign 1711 ; SAP Business ByDesign 1802 ; SAP Business ByDesign 1805 ; SAP Business ByDesign 1808 ; SAP Business ByDesign 1811 ; SAP Business ByDesign feature pack 2.0 ; SAP Business ByDesign feature pack 2.5 ; SAP Business ByDesign feature pack 2.6 ; SAP Business ByDesign feature pack 3.0 ; SAP Business ByDesign feature pack 3.5 ; SAP Business ByDesign feature pack 4.0