My Oracle Support Banner

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

Last updated on JANUARY 04, 2022

Applies to:

Oracle Payables - Version 12.1.3 and later
Information in this document applies to any platform.


On : 12.1.3 version, Accounting Issues in AP

When attempting to create accounting
the following error occurs.

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

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.





To view full details, sign in with your My Oracle Support account.

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

In this Document

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