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.
