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
- Go to the General Ledger work center.
- Click General Ledger Accounts view.
- Find the G/L Account ABC.
- Click Edit and Select the Open Items on Selected Account.
- 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:
- Go to the General Ledger work center.
- Click General Ledger Accounts view.
- Find the G/L account and click Edit.
- Select the Open Items on Selected Account.
- Click Remove assignment.
To assign the existing Open Item Reference ID follow the below steps:
- Go to the General Ledger work center
- Click General Ledger Accounts view
- Find the G/L account
- Click Edit and select the Open Items on Selected Account
- 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
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