My Oracle Support Banner

EGL 9.2: Monetary And Foreign Amounts Having Opposite Signs And Wrong Values (5860,38) In Interunit Accounting Entries (Doc ID 1961895.1)

Last updated on APRIL 10, 2019

Applies to:

PeopleSoft Enterprise FIN General Ledger - Version 9.2 to 9.2 [Release 9]
PeopleSoft Enterprise FIN Payables - Version 9.2 to 9.2 [Release 9]
Information in this document applies to any platform.
*** checked for relevance 12-Sep-2016 ***
*** checked for relevance 08-Mar-2018 ***


On : 9.2 - Image 6, Interunit Processor, Voucher Post, Journal Generator, Journal Edit

On accounting entries (ACCRUAL) for inter unit voucher, the monetary and foreign amounts are of opposite signs. Also, the value of monetary amount is wrong as per the exchange rate values.
Accounting entries (ACCRUAL) should have the same sign for monetary and foreign amounts.

The issue can be reproduced at will with the following steps:
1. Voucher
BUAP: US001  - Base Currency: USD
Line Total:     9714,63 EUR
Total :          9714,63 EUR

1 Invoice Line: 9714,63 EUR with 9 Distrib Linnes:

Distribution Lines:
Merchandise Amt:  GL UNit  Currency   Exchange rate
964,36                    BLGE1     EUR       1,00000000
1911,61                  JPN01      JPY       9.88479926
501,26                    US001     USD       0.78443677
817,01                    DEUE1     EUR       1.00000000
543,36                    FRA01     FRF       4.78158361
3785,06                  US001     USD       0.78443677
627,56                    FRAE1     EUR       1.00000000
480,21                    ITLE1      EUR       1.00000000
84,20                     ITLE1       EUR       1.00000000

2. Run Voucher posting.
There is one IUR acct entry with FOREIGN_AMOUNT = 964,360 EUR and MONETARY_AMOUNT = -2008,540

3. Run Journal generator.
Message error: 5860,38 Foreign amount and monetary amount are of different signs

Note: This problem is affecting account balances due to incorrect voucher accounting entries and resulting journals going to error status.




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.