Exchange Rate On Posted Invoice Not Equal To Exchange Rate On Original Invoice (Doc ID 869403.1)

Last updated on AUGUST 17, 2016

Applies to:

Oracle Retail Invoice Matching - Version 13.0.2 and later
Information in this document applies to any platform.

Symptoms

When an invoice is matched and then posted, the exchange rate of the posted invoice, IM_AP_STAGE_HEAD.EXCHANGE_RATE, is not equal to the exchange rate on the original invoice, IM_DOC_HEAD.EXCHANGE_RATE. IM_DOC_HEAD.EXCHANGE_RATE is equal to the exchange rate on the purchase order, ORDHEAD.EXCHANGE_RATE. IM_AP_STAGE_HEAD.EXCHANGE_RATE comes
from the CURRENCY_RATES exchange rates that are Consolidated.

Steps To Reproduce:
1. Create a purchase order (PO) with a foreign currency, changing the currency rate; approve and ship it.
2. Create an invoice, noticing that it picks the changed currency rate from the PO; match and post the invoice.
3. Note that once posted the currency rate is not that of the PO and the document but the
consolidated one from currency rates table.


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