R12: AP/XLA: Large Rounding Created when Clearing a Future Dated Check (Bills Payable) when the Exchange Rate of the Clearing is Different than the Rate of the Maturity (Doc ID 3017886.1)

Last updated on SEPTEMBER 10, 2024

Applies to:

Symptoms

Large rounding lines are created in the accounting for a clearing event when the exchange rate for the Maturity is different than the exchange rate of the Payment event and the Clearing event.

Steps to Replicate:

1. From a Payables Responsibility navigate to Payments -> Entry -> Payments
2. Pay a non-functional currency invoice using a future dated payment method with a "User" rate of 2.0 and a "User" maturity rate of 2.5
3. Run "Create Accounting" to account for the payment
4. Run "Update Matured Bills Payable Status"
5. From a Cash Management Responsibility clear the check with a "User" rate of 2.0
6. This will create accounting similar to the following, the ROUNDING line is not correct:
   
   

   Event Type	Accounting Line Code	DR	CR
   Payment Created	FUTURE_DATED_PMT		2160
   Payment Created	LIABILITY	1620
   Payment Created	LOSS	540
   Payment Matured	CASH_CLEARING		2700
   Payment Matured	FUTURE_DATED_PMT	2160
   Payment Matured	LOSS	540
   Payment Cleared	CASH		2160
   Payment Cleared	CASH_CLEARING	2160
   Payment Cleared	GAIN		540
   Payment Cleared	ROUNDING	540

Cause

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