Wrong Exchange Rate And Exchange Date Being Used For Rcv_transactions in Foreign Currencies for PO
Last updated on OCTOBER 25, 2017
Applies to:Oracle Inventory Management - Version 188.8.131.52 to 12.1.3 [Release 11.5.10 to 12.1]
Information in this document applies to any platform.
Form:RCVRCERC.FMB - Enter Receipts
Executable:RVCTP - Receiving Transaction Processor
Executable:POXPOIV - Pay On Receipt AutoInvoice
***Checked for relevance on 30-SEPT-2014***
Find Purchase Orders receipts in foreign currency have a wrong date and wrong rate.
As a consequence when matching an invoice to a Receipt and/or running Pay on Receipt the wrong currency rate is being used.
Expect currency rate and currency date at the time of receipt to be used.
The issue can be reproduced at will with the following steps:
1. Enter and approve purchase order in foreign currency on 13-JAN-2011
At shipment level ensure that Invoice Match Option is set to Receipt
1.1 At header level
Currency = EUR
Rate Date = 13-JAN-2011
Rate = 3.1354
1.2 At Shipment level
Invoice Match Option = Receipt
2. Receive the purchase order on Enter Receipts form on 27-FEB-2011. At this date
the conversion rate between functional currency and foreign currency has changed.
3. Run Pay on receipt .
4. The rate on the invoice has the rate of the Purchase Order not the actual rate in time of receipt.
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