Historical foreign currency GL balance data migration
Hi Professionals,
Hope someone can advice me on foreign currency GL balance data migration.
We have 15 bank accounts in foreign currency. We need to have those foreign currencies into the Cloud due to use a standard functionality for revaluing those bank account balances later in Production.
Those foreign bank accounts have entered amount in foreign currency and accounted amount in a ledger currency in a FBDI template.
This means that entered amount is not in balance. Accounted amounts are in balance. Cloud creates journal lines for those unbalance foreign currency lines as well accounted amount in the ledger currency into a suspense account which is incorrect.