My Oracle Support Banner

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
Item1: 2000
Tax: 160

Standard Invoice B

Invoice Amount: 1441
Item1: 667
Item2: 667
Tax: 107

Amount when Prepayment Invoice A is fully applied to Standard Invoice B.

Paid Amount: 1442
Tax:                  -1
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

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