SAP Knowledge Base Article - Public

3368046 - Unexpected Balance in G/L Accounts - Line Items Report for an Opening or Closing - Balance Sheet G/L Account

Symptom

The Account Balance for G/L Account AAA (of account type Opening or closing  - balance sheet) displayed in General Ledger - General Ledger Accounts work center view is not matching with the G/L Accounts - Line Items report -> key figure Balance Company Currency for the same G/L Account and accounting period.

AAA means the G/L Account ID.

Environment

SAP Business ByDesign

Reproducing the Issue

  1. Go to the General Ledger - General Ledger Accounts work center view.
  2. Check the balance for G/L Account AAA for respective Company, Set of Books and current accounting period: notice that the balance is zero.
  3. Now run the G/L Accounts - Line Items report for same combination of Company, Set of Books and G/L Account and enter Accounting Period/Year as Current Fiscal Year.
  4. Enter key figures Debit Amount Company Currency, Credit Amount Company Currency and Balance Company Currency.
  5. Notice that there's a difference between Debit Amount and Credit Amount, which ends up in a Balance in Company Currency.

Here you expected Balance Company Currency to be zero.

Cause

Only Balance Carryforward step 1 - Carry forward accounts has been executed for referred company and set of books.

Resolution

Execute Balance Carryforward step 2 - Calculate and carry forward profit/loss for referred company and set of books.

Afterwards the Balance Company Currency in G/L Accounts - Line Items report should be cleared for G/L Account AAA.

See Also

Help Document: Balance Carryforward

Keywords

G/L Accounts - Line Items; account balance; Opening or closing  - balance sheet; Balance Company Currency; bcf; balance carryforward , KBA , SRD-FIN-GL , General Ledger , How To

Product

SAP Business ByDesign all versions