Let's Reconnect, thank you for making 2022 our best year yet.

Look Back
unbalance amount in functional currency — Cloud Customer Connect
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

unbalance amount in functional currency

Accepted answer
edited Jan 7, 2020 9:22AM in General Ledger & Intercompany 9 comments


unbalance amount in functional currency


Dear all,

We have external system to generate GLJournalLine.csv and upload to Oracle GL (ledger currency is TWD).

The source system only pass journal currency and amount to Oracle if journal is in foreign currency.The issue may happen on foreign currency with one line with DR/CR against with multiple DR/CR lines. Total debit and credit are balance if If you sum-up in foreign currency because there is a checking in source system.  However, the ledger is in TWD, Oracle engine will put the corporate exchange rate (pre-defined in the system) * journal currency amount to calculate functional currency for those foreign currency journal (This is Oracle standard function).


Howdy, Stranger!

Log In

To view full details, sign in.


Don't have an account? Click here to get started!