web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Finance | Project Operations, Human Resources, ...
Suggested Answer

Foreign Currency Revaluation - Accounts Payable

(0) ShareShare
ReportReport
Posted on by 35

Hello,

I have a company setup with the following currency information-:

Accounting Currency - CAD

Reporting Currency   - USD

All my Vendor Invoices are in CAD and I don't have any other foreign currency transactions in this entity. 

When I run my Foreign Currency Revaluation at the month end, I have foreign currency gain or loss getting posted for difference in Exchange rate based on my Reporting Currency which is USD. 

According to my client, the system should not post any exchange gain or loss for Reporting Currency (USD) as that is actually a translation difference and not Exchange Gain or Loss. 

I understand that if we had any Invoices posted in EUR of any other currency, then the system would revalue to new accounting currency rate Vs exchange at the time of accounting the Invoice and post the difference to Forex Gain or Loss Account. 

Any thoughts here on D365F&O booking the Gain or Loss for Reporting Currency (USD) which actually is a kind of translation.

Narasimha.

I have the same question (0)
  • Suggested answer
    Ludwig Reinhard Profile Picture
    Microsoft Employee on at

    Hi Narasimha,

    I agree with you on the translation issue and would say that there should be no exchange rate gain/loss recorded from a pure finance & accounting perspective. Yet, when you have USD setup as the accounting currency, all transactions in the reporting currency will actually be subject to this translation issue.

    The bad news is that there is no configuration or setup that would allow D365FO to stop this kind of behavior. The good news is that you can report and discuss this with Microsoft via the dynamics ideas/experience portal. Just enter a product suggestion there.

    Best regards,

    Ludwig

  • NarasimhaM Profile Picture
    35 on at

    HI Ludwig,

    Thanks for your update but just to confirm you are referring to USD as reporting currency (you mentioned Accounting above), because in my case Accounting Currency is CAD & Reporting is USD.

    Narasimha

  • Ludwig Reinhard Profile Picture
    Microsoft Employee on at

    Good Morning Narasimha,

    Sorry, mixed USD and CAD. I am used to having USD as the accounting currency :-)

    The answer remains just 'switch' USD with CAD in my previous reply.

    Is there anything else the community can help you with in regards to this issue or is everything clear/answered?

    Best regards,

    Ludwig

  • Thomas Tian Profile Picture
    on at

    Hi, NarasimhaM

    do you mean that you set cad as a accounting currency and all then transaction use the CAD. but  have foreign currency gain or loss when running Foreign Currency Revaluation?

    can you just give a repro steps for 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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 456 Super User 2025 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 429 Most Valuable Professional

#3
BillurSamdancioglu Profile Picture

BillurSamdancioglu 239 Most Valuable Professional

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans