EGL9.2: System Generated Journal VAT line Uses Incorrect Currency Rate Causing Rounding Difference. (Doc ID 2112897.1)

Last updated on JULY 24, 2023

Applies to:

Symptoms

On : 9.2 version, Journal Edit

ACTUAL BEHAVIOR
---------------
System generated journal VAT line uses incorrect currency rate causing rounding difference.

A journal entry using VAT applicable accounts is created and edited online prior to realizing an incorrect currency effective date is used. The currency effective date is changed on the Journal Header and the journal is then edited via the batch edit. One system generated VAT line’s currency rate does not change with the second edit, whereas the rest of the journal lines do change the currency rate used. Because the journal then does not balance, the rounding account is employed with the difference. The currency effective date on this system generated VAT line does change, however, the currency rate used by the journal does not.

EXPECTED BEHAVIOR
-----------------------
The generated journal VAT lines should use correct currency rate and do not cause any rounding difference.

STEPS
-----------------

The issue can be reproduced at will with the following steps:

1.Create a new BU BUS01 (General Ledger Definition) and Add another BU BUS02
2.TabelSet Control Setup Detail Ledger to BUS01 and BUS02
3.Create Detail Ledger for BUS01 and BUS02 as below: ACTUALS, ACT_EUR, ACT_GBP
4.Create LEDGER Group ACTUALS for all SET IDs
5.Setup VAT for all BUs and SETIDs
6.Setup a Rounding Account for LEDGER GROUP ACTUALS
7.Open Period Update TWD,EUR,USD
8.Setup Market Rates: EUR to USD; EUR to GBP; EUR to TWD; TWD to USD
9.Add new Market Rate: TWD to GBP; TWD to EUR
10.User Preferences login1, Journal Source, Journal Options
11.Login with login1, And create a new journal, Save it, Edit and Change the Currency RATE, Press GET RATE
12.Run Batch Edit --> The rounding account is high in amount (eg.-10.38)

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.