EGL: Journal Edit Fails with Out Of Balance Error for Journal Generated from AP (Doc ID 1377535.1)

Last updated on MARCH 24, 2016

Applies to:

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

Symptoms

Journal Edit fails for Journals Generated from AP with the following error:

ERROR
------------
The transaction for ledger ACTUAL_USD is not in sync with the primary ledger transaction

REPLICATION STEPS
-------------------------------

  1. Navigate to Main Menu > Set Up Financials/Supply Chain > Business Unit Related > General Ledger > General Ledger Definition and set Currency Option for Translate Ledger Exchange Rate to Inherit from Primary Ledger.
  2. Navigate to Main Menu > Set Up Financials/Supply Chain > Common Definitions > Journals > Source and open the AP Source. On the Currency Options page set Currency Balancing Option to Balance by Base Currency Only.
  3. Create a Malaysian voucher in AP with transaction in base currency of MYR.
  4. Pay this voucher in USD a month later with a new exchange rate.
  5. Post the voucher and payment transactions.
  6. Accounting entries are generated correctly for both Primary (Inherit Base Currency) and Translation (USD) Ledgers with the respective accounting dates: -
    • You can see on the voucher accounting lines table that there seem to be an imbalance in the Foreign Amounts for Payment, as the transactions do not net to zero. This is okay as the amounts are presented in both currencies (which would be equal when converted to one currency).
  7. Run Journal Generator and create the journals
  8. Run Journal Edit on the journals
  9. Journal Edit recalculates the monetary amount on the Translate Ledger for one line on the payment journal, and fails for being out of balance

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