E1: 54R: Rental Billing Workfile Generation (R54R300) Uses Incorrect Rental Rate When Using Foreign Transaction Currency and Variable Exchange Rate (Doc ID 2978506.1)

Last updated on DECEMBER 27, 2023

Applies to:

Symptoms

When a Rental Contract uses a foreign Transaction Currency, a domestic Billing Currency and variable header exchange rate, Rental Billing Workfile Generation (R54R300) should not modify the Rental Rate by the processing option date-based exchange rate. This will allow the system to calculate the Amount Billed based on the Exchange Rate Date correctly.

Steps:
1. Create different rates by date in Currency Exchange Rates (P0015A) for the currencies to be used in the contract; a new rate should start on 08/31/2023.
2. Create a Rental Contract Header (P54R10) as follows:
a. Billing Start Date = 08/01/2023
b. A domestic Customer and Ship to
c. Domestic Base Currency
d. Foreign Transaction Currency
e. Domestic Billing Currency.
 
3. Enter a Rental Contract Detail using a Rental Item (exists in P54R41) and monthly Rental Billing Unit of Measure; verify the Foreign Unit Price.
4. Run Rental Billing Workfile Generation (R54R300) in proof as follows:
a. Date to Bill Through = 08/31/2023
b. G/L Date = 08/31/2023
c. Exchange Rate Date Basis = 3 (use G/L Date).
 
5. Review the report. Note that the Exchange Rate Date is correct: 8/31/2023. However, the Rental Rate has been modified by this exchange rate and then uses the 08/31/2023 rate again to calculate the Amount Billed.
6. Change the Rental Contract Header where Fixed Exchange Rate is active.
7. Re-run Rental Billing Workfile Generation in proof mode.
8. Review the report. Notice that the Rental Rate now matches what displays in the Rental Contract, however the Exchange Rate Date is 8/1/2023.

Changes

Cause

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