Skip to main content

Notifications

Finance | Project Operations, Human Resources, ...
Suggested answer

Currency Exchange Rate with Retained Earnings in Management Reporter

(0) ShareShare
ReportReport
Posted on by 9

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. 

  • SusanR_Boumatic Profile Picture
    SusanR_Boumatic 9 on at
    RE: Currency Exchange Rate with Retained Earnings in Management Reporter

    I did some testing but it ends up giving us a large CTA (currency translation adjustment) doing this unfortunately.  Thanks for the suggestions though.

  • Suggested answer
    Magno Pereira Profile Picture
    Magno Pereira 2,429 Super User 2025 Season 1 on at
    RE: Currency Exchange Rate with Retained Earnings in Management Reporter

    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.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Vahid Ghafarpour – Community Spotlight

We are excited to recognize Vahid Ghafarpour as our February 2025 Community…

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,965 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 230,817 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Product updates

Dynamics 365 release plans