R12: AP: Invoice Variance Calculation If Both IPV And ERV Exist In One Invoice (Doc ID 1578362.1)

Last updated on JANUARY 02, 2024

Applies to:

Goal

How is the calculation of IPV and ERV if both of these variance exist in one invoice.

For Example:
Receipt PO Number 001:
Item A (Receipt Price = 100, Quantity = 10, Rate = 9000)

Invoice Number 002 match to Receipt 001:
Item A (Invoice Price = 110, Quantity = 10, Rate = 9100).

From above example, it will generate IPV and ERV, but what is the formula to calculate the proportion?
 

Solution

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