Create Accounting fails with Error : Entered Amount and Accounted Amount for Line Are Not on the Same Side (Doc ID 1457829.1)

Last updated on MARCH 13, 2017

Applies to:

Oracle Receivables - Version 12.0.6 to 12.1.3 [Release 12.0 to 12.1]
Information in this document applies to any platform.

Symptoms

Create Accounting fails for few cases with the following error:

ERROR
-----------------------
The entered amount and accounted amount for line 1 are not on the same side.

The accounted amount and entered amount for the subledger journal entry line have different sign.
Please inform your system administrator or support representative that:
The sources assigned to the accounting attributes Accounted Amount and Entered Amount have different sign for extract line number -1934520. Please make sure the sources assigned to the two accounting attributes have same sign, or assign different sources to these accounting attributes.

Responsibility:  Receivables Manager
Navigation:  Transactions > Transactions
1. Create an Invoice with multiples lines
2. Choose a small exchange rate
3. The Sum of Invoice lines should be zero
For e.g., create an Invoice in foreign currency with 0.026228647759481894190031122047886025153 and enter 6 lines with following amounts
   3346.88
-16734.38
   3346.88
   3346.88
   3346.88
   3346.88

Subledger Accounting Program Report shows

Journal Entry Description Invoice Transaction Type - Inv-Consult-East
Invoice Transaction Number - 505733 Document Sequence Category - Document
Number - Journal Entry Status Invalid
Line Accounting Class Account Entered Accounted
Currency Debit Credit Debit Credit
1 Receivable 01-000-1210-0000-000 INR 0.02 0.02
2 Revenue 01-140-4150-0000-000 INR 0.02 0.02
Journal Entry Total 0.02 0.02

Line Error Number Error Message
2 95314 The entered amount and accounted amount for line 1 are not on the same side.

XLA_AE_LINES shows
RECEIVABLE 0.02 Entered_Cr 0.02 Accounted_Cr
REVENUE 0.02 Entered_Cr 0.02 Accounted_Dr

It may come if header level rounding is disabled in System Options.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms