Loading Legacy GL Balances into a new EBS Ledger with some foreign currency balances.
I'm looking for a best practice to initialize GL Balances brought over from Netsuite into EBS. The functional currency is EUR, but there are some accounts that have balances converted from foreign currencies. Some AR, AP and Equity accounts. For AR and AP we will bring the open transactions in in the entered currency and use a user rates from Netsuite so they match in both systems. For GL balances we are not going to load historical data, but at of the beginning of the year (31-DEC-2020).
How do we load the balances to ensure revaluations will be correct of the non-subledger balances? can this be done without loading each historical debit and credit on the foreign currency?