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 OCTOBER 03, 2023
Applies to:JD Edwards EnterpriseOne Rental Management - Version 9.2 and later
Information in this document applies to any platform.
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.
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.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document