Hi all, in need of some help regarding intercompany multi-book and multi-currency reporting. We have a business where they created a local book 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

did you create your ACJE in Primary book? what are the names of the account 1 and account 2?

Not very familiar with adv intercompany journals, but it looks to me to have been created in the secondary book? accounts: Restricted Cash and Intercompany, net

if the journal is created in the secondary book only that’s where it stays. it does not get copied into the primary book and is book specific. Only book generic journals get copied from primary book into a secondary book. that’s why you do not have anything in primary book.

Okay, then it is created in the primary book, because it is there, but it looks like there is a difference in the reported exchange rate, as there is a 0 amount balance in one book and a positive balance in the other

if the transaction was created as a general ACJE (not book specific ACJE) it must be in both books. They only logical reason it would not be available in the primary book is that there was already a balance on that account in the same exact amount and the ACJE in question cleared it. See activity/details for Account 1 in the US book. not sure for what time period you are reviewing your TB, look for activity in that time period.