R12: AP: Can Invoice and Tax Currency Conversion Rates Different on an AP Invoice ? (Doc ID 2923524.1)

Last updated on FEBRUARY 06, 2024

Applies to:

Goal

Why are the Invoice Currency and Tax Currency Conversion Rates Different on AP Invoice and what is the field TAX_CURRENCY_CONVERSION_RATE used for present in ZX_LINES table?

For Example, The tax and item lines has the same currency, which is USD where and functional currency is in IDR. So, if user want to create an invoice with foreign currency USD, but the invoice has different rates for item and tax lines.
- Item line : 100 USD -> uses Corporate Rate Type with rate 1 USD = 15.000 IDR
- Tax line : 11 USD -> uses Spot exchange rate type with rate 1 USD = 14.500 IDR
Is it possible to have different foreign currency exchange rate for item and tax lines as example above? If not, are there other workarounds to accommodate this case?

Solution

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