R12: AP: Tax Calculated Has the Variance Between Auto Applied Prepayment and Standard Invoice
(Doc ID 2630900.1)
Last updated on DECEMBER 07, 2020
Applies to:Oracle Payables - Version 12.2.7 and later
Information in this document applies to any platform.
Prepayment is automatically applied to the standard invoice, the standard invoice should be fully paid, no amount remaining. But the actual behavior is that the Amount Remaining is -1 Yen.
The standard invoice can be validated and accounted.
1. Rounding Level is Header.
2. Rounding Rule is Up. (If the Rounding Rule is Down, the Amount Remaining is 1 Yen.)
The issue can be reproduced at will with the following steps:
1. Navigate to Purchasing Responsibility -> Buyer Work Center -> Orders, create a Complex PO (including Advance Recoupment Rate:100%) in this page.
2. Import the prepayment A from interface table to the Payables(AP) base table manually, prepayment A is matching to the Complex PO.
Validate and pay this prepayment.
3. Import the standard invoice B from interface table to the Payables(AP) base table manually, standard invoice B is also matching to the same Complex PO.
When run "Payables Open Interface Import" program, standard invoice B create in AP base table, and the prepayment A is applied to the standard invoice B with fully amount automatically.
Standard Invoice B is not Fully Paid by the Prepayment, the Amount Remaining is -1 Yen. Tax has the variance between Prepayment and Standard Invoice like the following amount.
Prepayment Invoice A
Invoice Amount: 2160
Standard Invoice B
Invoice Amount: 1441
Amount when Prepayment Invoice A is fully applied to Standard Invoice B.
Paid Amount: 1442
Total of Amount: -1
Amount remaining of Standard Invoice B: -1
The Variance happens in Distribution lines of Standard Invoice B.
Item：667 + 667 = 1334
Tax：54 + 53 = 107
Prepay：-667 + -667 = -1334
Tax(Prepay)：-54 + -54 = -108
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