R12: AP: The LINE VARIANCE Hold Is Placed When a Prepayment Is Applied to a Standard Invoice in Foreign Currency (Doc ID 3039851.1)

Last updated on AUGUST 06, 2024

Applies to:

Symptoms

The user is not able to validate a standard invoice after a prepayment application.
The standard invoice has 'LINE VARIANCE' hold name, 'Total of Invoice Lines does not equal Invoice Amount' hold reason and status is "Needs Revalidation".

The issue can be reproduced at will with the following steps:

1. Go to Payables responsibility - Entry - Invoices - New
2. Create a prepayment invoice in foreign currency
   
   Sample Case:
   
   Ledger currency code is USD with an Exchange Rate of 0.10482776954705
   Invoice Amount: 217.88
   Invoice Currency: RON
   Invoice Currency Functional Amount: 22.840
   Functional Currency: USD
   
   
3. Pay and Account the prepayment invoice.
4. Go to Payables responsibility - Entry - Invoices - New
5. Create a standard invoice in foreign currency
   
   [Invoice Header]
   Invoice Amount: 217.88
   Invoice Currency: RON
   Invoice Currency Functional Amount: 22.840
   Functional Currency: USD
   
   [Invoice Lines&Distributions]
   Line 1
   Type: Item
   Amount: 207.50
   Functional Amount: 21.752
   --------
   Line 2
   Type: Item
   Amount: 10.38
   Functional Amount: 1.088
   
   
6. Click on Actions button -  Apply/Unapply Prepayment - OK
7. Check the Apply for the prepayment
8. Click on Apply/Unapply
9. Close the Apply/Unapply Prepayments form
10. Inquiry again the standard invoice
11. Click on Actions - Validate
12. The standard invoice has 'LINE VARIANCE' hold name, 'Total of Invoice Lines does not equal Invoice Amount' hold reason and status is "Needs Revalidation".

Changes

Cause

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