Multi book, trail balance differences
Hi all, in need of some help regarding intercompany multi-book and multi-currency reporting.
We have a business where a local book was created for reporting in a different currency (I know this is not the way to do it, and hope to correct this in the future)
The issue is the trail balance. when running the report in local book, there is a balance of 850 DKK, but when running it on the primary book, there is a balance of 0 USD
Subsidiary A: base currency USD, Primary book USD, Local book DKK
Subsidiary B: base currency USD, Primary book USD, Local book USD
an advanced intercompany journal has been created:
Sub A: account 1, debit 740 USD
Sub A: account 2, credit 740 USD
Sub B: account 2, debit 740 USD
Sub B: account 1, credit 740 USD
the GL impact looks correct:
Local book: Sub A: account 1, debit 5200 DKK
Local book: Sub A: account 2, credit 5200 DKK
Local book: Sub B: account 2, debit 740 USD
Local book: Sub B: account 1, credit 740 USD
Primary book: Sub A: account 1, debit 740 USD
Primary book: Sub A: account 2, credit 740 USD
Primary book: Sub B: account 2, debit 740 USD
Primary book: Sub B: account 1, credit 740 USD