Hi All,
My company just switched to Dynamics 365 F&O about 7 months ago. We have several companies with different currencies that roll up into the parent company that reports in USD. With our old system we did our financials in Excel and used average historical rates for each company for their Retained Earnings account. We need to tie out our Dec 2021 audited financials to the financials in D365 but because of the varying currency rates over time we have a significant difference using the current rate set up in D365. When our companies were set up in D365 the Retained Earnings account was set up to be at Current Rate. I know we can change that to be at Transaction date, however, our companies have been around for different amounts of time and thus have different rates that were used for the retained earnings in our Excel reporting. Also we only migrated data in the system back to Dec 2020, but many of our companies are decades old and thus the average historical rate goes back too far to use Transaction date.
Any suggestions on how we can get reporting to match our historical reporting when converted to USD? All the amounts are correct in their local currency so it is just rolling up the reports into USD that is the issue.
I did some testing but it ends up giving us a large CTA (currency translation adjustment) doing this unfortunately. Thanks for the suggestions though.
Have you thought about creating an exchange rate type specifically for historical rates? This way, you can configure it in the main account for retained earnings and utilize it.
André Arnaud de Cal...
291,965
Super User 2025 Season 1
Martin Dráb
230,817
Most Valuable Professional
nmaenpaa
101,156