SAP Knowledge Base Article - Public

2134225 - Error Message: Account DEF: Balance in company currency is not zero

Symptom

When you are trying to clear open items for G/L Account ABC and you receive error message:

'Account DEF: Balance in company currency is not zero'. (Here DEF and ABC are two different G/L accounts).

Environment

SAP Business ByDesign

Reproducing the Issue

  1. Go to the General Ledger work center.
  2. Click General Ledger Accounts view.
  3. Find the G/L Account ABC.
  4. Click Edit and Select the Open Items on Selected Account.
  5. Select the open line items and click Clear.

You receive error message:

'Account DEF: Balance in company currency is not zero. Save Failed.'

Cause

You have assigned the Open Item Reference ID to some of the open items for the G/L account DEF as well. However Balance in company currency for such items is not zero.

When you try to clear the items for the G/L account ABC having Open Item Reference ID as GHI (GHI means the Open Item Reference ID), system checks for all open item assigned to the same Open Item Reference ID and since for the G/L account DEF it's not balancing to zero (0), system throws the error message.

You can also check G/L Accounts - Line Items report to check the difference for Debit Amount Company Currency and Credit Amount Company currency for both G/L accounts.

Resolution

The issue can be resolved by maintaining the different Open Item Reference ID for both the G/L Accounts or assigning the Open Item Reference ID such that it balance to zero (0).

To Remove the Open Item Reference ID follow the below steps:

  1. Go to the General Ledger work center.
  2. Click General Ledger Accounts view.
  3. Find the G/L account and click Edit.
  4. Select the Open Items on Selected Account.
  5. Click Remove assignment.

To assign the existing Open Item Reference ID follow the below steps:

  1. Go to the General Ledger work center
  2. Click General Ledger Accounts view
  3. Find the G/L account
  4. Click Edit and select the Open Items on Selected Account
  5. Click Assign and select Assign Existing Open Item Reference

Once Balance in company currency for the particular open item reference is zero, you will be able to clear the items.

See Also

2134010 - Unable To Clear Open Items In G/L Account

Keywords

Open items on selected account, G/L accounts, Clear, Balance in company currency is not zero , KBA , open items on selected account , balance in company currency is not zero , clear , SRD-FIN-GL , General Ledger , How To

Product

SAP Business ByDesign all versions