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

Last updated on JULY 12, 2017

Applies to:

PeopleSoft Enterprise FIN General Ledger - Version 9.2 and later
Information in this document applies to any platform.

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 EUR01 (General Ledger Definition) and Add another BU TWD01
2.TabelSet Control Setup Detail Ledger to EUR01 and TWD01
3.Create Detail Ledger for EUR01 and TWD01 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 VP2, Journal Source, Journal Options
11.Login with VP2, 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)

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