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 SEPTEMBER 12, 2016

Applies to:

PeopleSoft Enterprise FIN General Ledger - Version 9.2 and later
PeopleSoft Enterprise FIN Payables - Version 9.2 and later
Information in this document applies to any platform.
*** checked for relevance 12-Sep-2016 ***

Symptoms

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
NO VAT
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.

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