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 JUNE 21, 2023

Applies to:

Oracle Receivables - Version 12.0.6 and later
Information in this document applies to any platform.

Symptoms

BEST PRACTICES:

Run the Receivables Period Close Analyzer before closing the period to proactively identify this issue, as well as many other issues that will prevent you from closing the period.
If you post to multiple EBS subledgers, use the EBS Period Close Process Analyzer for a smoother period close.

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

                                                     --Entered--- -Accounted--
 Line Accounting Class  Account             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 Entered_DR = 0.02, Accounted_CR = 0.02
REVENUE Entered_CR = 0.02, Accounted_DR = 0.02

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

NOTE: Data issues similar to this may also occur for Receipts.
Please run the following query to identify similar cases

SELECT trx.customer_trx_id,
trx.trx_number,
nvl(l.entered_dr,0) ENTERED_DR,
nvl(l.accounted_dr,0) ACCOUNTED_DR,
nvl(l.entered_cr,0) ENTERED_CR,
nvl(l.accounted_cr, 0) ACCOUNTED_CR
FROM xla_ae_lines l,
xla_ae_headers h,
xla_transaction_entities_upg xte,
ra_customer_trx_all trx,
ra_cust_trx_types_all ctt
WHERE xte.security_id_int_1 = &org_id
AND xte.ledger_id = &ledger_id
AND xte.application_id = 222
AND xte.entity_code = 'TRANSACTIONS'
AND xte.source_id_int_1 = trx.customer_trx_id
AND trx.cust_trx_type_id = ctt.cust_trx_type_id
AND ctt.name != 'Projects Invoice'
AND trx.customer_trx_id = &customer_trx_id
AND xte.entity_id = h.entity_id
AND l.application_id = h.application_id
AND l.ae_header_id = h.ae_header_id
AND h.application_id = 222
AND h.ledger_id =xte.ledger_id
AND l.accounting_class_code not in ('EXCHANGE_GAIN_LOSS', 'BALANCE', 'INTRA', 'ROUNDING', 'SUSPENSE', 'CURR_ROUND')
AND h.accounting_entry_status_code = 'I'
AND ((sign(nvl(l.entered_dr,0)) <> sign(nvl(l.accounted_dr,0)))
or (sign(nvl(l.entered_cr,0)) <> sign(nvl(l.accounted_cr,0)))
)