Exchange Rate Variance (ERV) Amount Is Not Correct for Miscellaneous Tax Distribution Lines During Difference In Currency Conversion Rate at Receipt Level and at Invoice Level (Doc ID 2078770.1)

Last updated on DECEMBER 01, 2015

Applies to:

Oracle Financials for India - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

On : 12.1.3 version, India PO Localizations

ACTUAL BEHAVIOR
---------------
Invoice tax lines are showing different amounts i.e more than receipt amount with different accounts during scenarios like the following one:-

1) Unit Of Material (UOM) Conversion Setup is as follows:-

1 PACK =1000 Each

2) Exchange Rate Setup is as follows:-

1 USD = 63.15 INR

3) Create PO with UOM PACK, currency USD.

4) Receive the material in Each UOM.

5) Create invoice with conversion different from PO conversion rate e.g. 1 USD = 70 INR

6) Match the invoice with the receipt. Also, add tax lines by matching with the receipt.

7) Exchange Rate Variance (ERV) Line for the tax line is becoming tax amount * Exchange Rate Difference * UOM Conversion rate. It should be tax amount * Exchange Rate Difference ideally.



EXPECTED BEHAVIOR
-----------------------
Invoice tax lines should show same amount as receipt amount.

STEPS
-----------------------
The issue cannot be reproduced at will as per customer confirmation.


BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot pay the vendor correctly.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms