R12: AP: Standard Invoice was Fully Paid by the Prepayment, But Payment Remaining of Standard Invoice Occurred (Doc ID 2561613.1)

Last updated on SEPTEMBER 21, 2023

Applies to:

Symptoms

Standard Invoice was Fully Paid by the Prepayment, the Payment remaining should be zero, but Payment Remaining of Standard Invoice Occurred.

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Navigate to Purchasing Responsibility -> Buyer Work Center -> Orders, user create a Complex PO (including Advance Recoupment Rate:100%) in this page.
2. Through interface table import the prepayment A to the Payables(AP) base table manually, prepayment A is matching to the Complex PO.
    Validate and pay this prepayment.
3. Through interface table import the standard invoice B 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 Fully Paid by the Prepayment, but Payment Remaining of Standard Invoice B is not zero.

The following is the example amount:
-----------------------
Prepayment Invoice A

Invoice Amount: 21600
Item1: 20000
Tax: 1600

Standard Invoice B

Invoice Amount: 21600
Item1: 10000
Item2: 10000
Tax: 1600
Paid Amount: 21600        <- Prepayment Invoice A is fully applied to Standard Invoice B
Total of Amount: 0
Amount remaining of Standard Invoice B: -1600

#The issue only happen when numbers of Standard Invoice B line are more than 1.

Cause

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