My Oracle Support Banner

EGL9.2.Journal Edit Incorrectly Populating Foreign Amount On The Suspense Line When Balancing Is Done By Base Currency And There Is Only 1 Foregin Currency In the Journal (Doc ID 2852925.1)

Last updated on JULY 24, 2023

Applies to:

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


The Journal Edit is populating the Foreign Amount on the Suspense line, even if the Balancing in the Journal is done by base currency and there is only 1 foreign currency present in the journal.

If there are multiple foreign currencies in the journal, there are correctly balanced amounts in Monetary and Foreign columns of the Suspense line.

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

1.Open the General Ledger Definition for unit US001 and apply the following setup :
Currency balancing options : Balance by base currency only
Base currency adjust option: allow base curr adjustments

2.Journal Balance Option Suspend
Balance suspense chartfields : group DEFAULT and account : 899997

3.Create a journal for US001 and foreign currency EUR and with different amounts on foreign amounts and different currencies for each account.

4.Journal edit has created a balance line with the Foreign Amount that has been populated with YYY EUR, which is wrong as the balancing by base currency

Note : In the example above, user details/company name/address/email/ telephone number all represent a fictitious sample from the Oracle Demo Vision Database. Any similarity to actual companies or actual persons, living or dead, is purely coincidental and is in no way intentional on the part of Oracle.




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

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