EAR9.1+: Accounting Entries Are Out Of Balance (6030,20) When Creating an On Account Payment, Create Accounting Entries Online and Change Account Chartfield While Accounting Entries Are Balanced. (Doc ID 1544066.1)

Last updated on MARCH 03, 2025

Applies to:

Symptoms

On : 9.1 version, Payment Worksheet

When attempting to create an On Account Payment, create accounting entries online and then change the account chartfield the following error occurs.

ERROR
-----------------------
Accounting entries are out of balance (6030,20)

In order for the accounting entries to be balanced for a group, all of the accounting entries you have created must be balanced. This message reminds you that you have created some unbalanced accounting entries. You may save the entries, but you will need to take actions to ensure the accounting entries are in balance before they can be posted or delete the accounting entries and let posting create the accounting entries.

STEPS
-----------------------
The issue can be reproduced at will with the following steps:

1. Create or modify Distribution Code in Set Up Financials/Supply Chain > Common Definitions > Distribution Accounting > Distribution Code. For example Distribution Code PREPAYMENT where Account is 120007, Oper Unit is NEWYORK, Fund is F215, Dept is 25000, Program is P2005, Class is C25 and Product is HARDWR.
2. Navigate to Set Up Financials/Supply Chain > Product Related > Receivables > Payments > Automatic Entry Type and open System Function ID WS-05 (Place An Amount On Account). Link Distribution Code PREPAYMENT to System Function ID WS-05 and Entry Reason UNAPP.
3. Create a Regular Deposit.
4. Navigate to Accounts Receivable > Payments > Apply Payments > Create Worksheet and build payment worksheet.
5. Put amount On Account and make sure to use Reason UNAPP.
6. Go to tab 'Worksheet Action' and Create/Review Entries.
7. The following accounting entries are created:
   • Debit Cash Account 100004
   • Credit AR Account is 120007, Oper Unit is NEWYORK, Fund is F215, Dept is 25000, Program is P2005, Class is C25 and Product is HARDWR (chartfields are coming from Distribution Code PREPAYMENT).
8. Change value for Oper Unit, Fund, Dept, Program, Class, Product and save changes. This is all working fine.
9. Now change Account, save changes and error 'Accounting entries are out of balance (6030,20)' pops up while the accounting entries are balanced!

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users can no longer change the AR distribution code for On Account payments.

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.