EGL 9.2: Monetary And Foreign Amounts Having Opposite Signs And Wrong Values (5860,38) In Interunit Accounting Entries
Last updated on MARCH 08, 2018
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:
BUAP: US001 - Base Currency: USD
Line Total: 9714,63 EUR
Total : 9714,63 EUR
1 Invoice Line: 9714,63 EUR with 9 Distrib Linnes:
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.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms