Contract Rate Date is not Taken into Account for Total Release Amount Conversion (Doc ID 2145718.1)

Last updated on FEBRUARY 13, 2017

Applies to:

PeopleSoft Enterprise SCM Purchasing - Version 9.1 and later
Information in this document applies to any platform.

Symptoms

Contract Rate Date is not taken into account for Total Release Amount currency conversion.

From the procurement contract created in EUR, different than the Purchasing BU Currency that is USD, when <Must Use Contract Rate Date> = Y the contract has a wrong Total Release Amount = 1650 EUR and not Total Release Amount = 1800 EUR (calculated from 1980 USD /1.1 at Rate 1 EUR = 1.1 USD from rate defined in the contract at date 04/21/2016).

STEPS
-----------------------
1. Create new Contract Genral Contract for Vendor ID USA0000001
Currency: EUR
Must Use Contract Rate Date= Y
Rate Date: 21/04/2016 Rate = 1.1
Begin Date 05/10/2016 Rate = 1.2
Contract Begin Date 10/05/2016 where the Rate = 1.2, Currency EUR.
Note: since the Must Use Contract Rate Date= Y and the Rate Date = 04/21/2016, should be used Rate 1 EUR = 1.1 USD for Currency EUR and not the rate from the Contract Begin Date 10/05/2016

2. Create new ePro Requisition in USD, where defaults the previous created contract, with Total Amount 1980 USD

3. Source eProcurement requistion to PO with Auto Sourcing
Pre-Approve Vendor = Y
Build POs as Approved = Y
Calculate PO Line Numbers = Y
Hold From Further Processing = N
Allow Dispatch When Appr = Y
 
The PO Created has Total Amount 1980 USD
 
3. Check the Contract where Total Amount 1650 EUR, in stand of Total Release Amount = 1800 EUR (calculated from 1980 USD /1.1 at Rate 1 EUR = 1.1 USD from rate defined in the contract at date 04/21/2016).

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