Wrong Exchange Rate And Exchange Date Being Used For Rcv_transactions in Foreign Currencies for PO (文档 ID 1307548.1)

转到底部

In this Document

Symptoms

Cause

Solution

References

APPLIES TO:

Oracle Inventory Management - Version 11.5.10.0 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***

SYMPTOMS

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.

Expected Behavior:
Expect currency rate and currency date at the time of receipt to be used.

Steps:
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.

CAUSE

The issue is caused by intended functionality due to the following setup :

The purchase order has a User Rate type
(in PO_HEADERS_ALL and PO_DISTRIBUTIONS_ALL tables).

Rcv11i output from Note 402245.1
shows that the purchase order in PO_HEADERS_ALL and PO_DISTRIBUTIONS_ALL tables has

Currency_Code    EUR
Rate_Type            User
Rate_Date            01-13-2011 00:00
Rate                     3.1354

With Match_Option set to Receipt for the shipment lines (in po_line_locations_all table)
when entering receipts the default is today's date.

But " For User rate types, changing the Rate Date does not affect the Rate."

and the related receiving transactions have in RCV_TRANSACTIONS table

Transaction_Date                    02-27-2011 19:17
Currency_Code                       EUR
Currency_Conversion_Type User
Currency_Conversion_Rate     3.1354
Currency_Conversion_Date    02-27-2011 00:00

(as a consequence pay on receipt will use this rate)

This is explained in Online Help when entering receipt (and PO user's guide)
and in Bug 5958649 DATAFIX: SOME PO'S RECEIPT CURRENCY DATE AND RATE ARE INCORRECT that states

											To modify exchange rate information:

Navigate to the Currency tabbed region.

You can update exchange rate information on the receipt only if you perform invoice-to-receipt matching (an Invoice Match Option of Receipt is chosen for the shipment in the purchase order Shipments window).

These fields are blank and disabled if there is no exchange rate-that is, if the purchase order is not in a foreign currency.

Modify the Rate Date.

If the Invoice Match Option on the purchase order shipment is Purchase Order, the default is the purchase order creation date, and you cannot change it. If the Invoice Match Option is Receipt, the default is today's date. You can change the Rate Date to one that better captures the cost of the item at the appropriate exchange rate. For example, if you are creating a receipt for an item that was actually received into inventory a few days earlier, you could enter the earlier date to apply the rate from that day. You can enter a different Rate Date for different receipt lines. For User rate types, changing the Rate Date does not affect the Rate.

Once you complete the receipt transaction, you cannot correct this exchange rate information later.

If the Rate Type is User and the profile option PO: Allow Rate Override for User Rate Type is set to Yes, optionally modify the Rate.

The Rate defaults from the purchase order.

Note: The Currency and the Rate Type also default from the purchase order, but cannot be changed.

With User rate type system does not automatically fetches rates from gl_daily_rates table but instead expects user to manually enter a new rate.

This is further detailed in
Note 138199.1 Oracle General Ledger Journal Entry Setup and Usage
or
Note 123542.1 Rate Frequently Asked Questions

SOLUTION

To implement the solution, please execute the following steps:

Option A:
Instruct the users to manually update the Rate and the Rate Date when entering receipts:

1. Go into the Responsibility Purchasing
2. Navigate to Receiving Receipts form
3. In Currency tab, update the Rate and the Rate Date ( Rate Type is User)
(after setting profile option 'PO: Allow Rate Override for User Rate Type' to Yes)

Option B:
Ensure to use Corporate (or Spot, or User-Defined ... ) Currency_Conversion_Type for the purchase order so that system automatically defaults Exchange rate when receiving from gl_daily_rates table.

1. Go into the Responsibility Purchasing
2. Navigate to Enter Purchase Order form
3. In Currency tab, update the Rate Conversion Type to use Corporate (or Spot, or User-Defined ..)

Please Note that In case of LCM shipment currency details are always from the LCM shipment rather then the PO or Receipt, regardless of match option.
This is explained in Bug 9689804 or Bug 12531839

Wrong ER for PO

APPLIES TO:

SYMPTOMS

CAUSE

SOLUTION