The Accounted Amount And Entered Amount For The Subledger Jounral Entry Line Have Different Sign
Last updated on JUNE 01, 2016
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 jounral 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.
The issue has the following business impact:
Due to this issue, users cannot create accounting and transfer to GL
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms