Hi there,
I am relatively new to Business Central - we're in the middle of implementing it. We have several companies using NZD currency and 1 company using AUD currency. We need to consolidate them all to NZD.
Now when consolidating, I notice that BC is only translating net movement from our P&L accounts in any given month. Per accounting standards, we need to translate our YTD result though.
I.e. if I run it right now, it only translates transactions for January 2024 and adds them onto the opening balance. I need it to translate the transactions for January AND the opening balance at the new rate.
Are we missing a setting here or is there a workaround to this? I understand we could potentially rerun the consolidation for every period using the new YTD average FX rate, but that is tedious.
Any thoughts are much appreciated!
Rahel
