The Accounted Amount And Entered Amount For The Subledger Journal Entry Line Have Different Sign (Doc ID 2133397.1)

Last updated on APRIL 04, 2025

Applies to:

Symptoms

On : 12.1.3 version, Accounting Issues in AP

When attempting to create accounting
the following error occurs.

ERROR
-----------------------
'The accounted amount and entered amount for the subledger journal entry line have different sign


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Insert data into ap_invoices_interface and ap_invoice_lines_interface.
 created 1 invoice with 490 invoice lines of line type as 'ITEM'.

Each line has the same amount as 9.28. The tax rate is 0.13000087966221.

This brings the tax amount of each tax line to be 1.20640816326531 (9.28*0.13000087966221).

After rounding, the tax amount is 1.21.

There are 490 invoice lines. So, the sum of all tax lines is 592.9 = 490

amount in Tax Control is in the invoice.

The amount is 591.14 =490*9.28*0.13000087966221.

This is to make sure the total tax amount is correct.

The creates a difference of 1.76 (592.9-591.14).

To resolve the difference, system put the variance into the first distribution line. 1.21-1.76=-0.55.

3. Check the invoice, make sure the tax control amount is in the invoice.

4. Validate the invoice.

5. Check the first distribution line of 'REC_TAX' and we found the amount is negative.

Changes

Cause

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