Hi,
We have multiple legal entities and one of it have 4 branches [FD] with different currencies. We set the 'current' currency translation for balance sheet accounts and 'transaction date' for P&L accounts.
In Finacial reports [MR reports] we used the currency display and filtered on currency to get branch vice P&L, BS and TB.
P&L works fine, how ever TB is not getting balanced and balance sheet also not getting balanced.
We identified it is due to the exchange rate translation.
Is there any way in financial reports to take the exchange rate from last day of the period for all accounts and convert other currencies with this rate.
Regards
Shijith