R12: AP: When Import the Invoice Using Control Amount "Control Amount Cannot Be More Than Line Amount" Error Happens (Doc ID 2630968.1)

Last updated on MAY 22, 2023

Applies to:

Goal

In order to match the amount of prepayment, enter Control Amount of standard invoice which is bigger than Item Amount, then "Control Amount Cannot Be More Than Line Amount" Error Happens.
How to adjust the amount matching with prepayment?

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, C, D, E from interface table to the Payables(AP) base table manually, These invoices are also matching to the same Complex PO.
   In order to adjust the total of Tax Amount is matching to Tax Amount of prepayment A, need to enter Control Amount of standard invoice bigger than Item Amount, but "Control Amount Cannot Be More Than Line Amount" Error Happens.
   
(# Tax Rate is 8%, Rounding Rule is Down)

AMOUNT SAMPLE
-----------------
Prepayment Invoice A

Invoice Amount: 1080
Item1: 1000
Tax: 80

Standard Invoice B  Invoice Amount 359 Item 333 Tax 26
Standard Invoice C  Invoice Amount 359 Item 333 Tax 26
Standard Invoice D  Invoice Amount 359 Item 333 Tax 26
Standard Invoice E  Invoice Amount   3   Item   1   Tax  2   <- In order to adjust the total of Tax Amount is matching to Tax Amount of prepayment A, enter Control Amout: 2 Yen.

 

Solution

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