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:

Goal

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.

CONDITION
-----------------
1. Rounding Level is Header.
2. Rounding Rule is Up. (If the Rounding Rule is Down, the Amount Remaining is 1 Yen.)

STEPS
-----------------
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.

AMOUNT SAMPLE
-----------------
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

Solution

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