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

Fixed Price Project - Estimation Revenue Recognition - Exchange rate

(0) ShareShare
ReportReport
Posted on by 200

Hi, 

I need to know more about the estimates process in a Fixed Price project with a contract in a sales currency different than the base currency of the legal entity.

I observe that when the project has different on account transactions with future dates and changing my exchange rate, the contractual value changes but that change is posted in the Revenue account.

For example, I have two lines of transactions on account in my project:

10/31/2019 10,000 USD
11/30/2019 10,000 USD

In my table of Exchange Rates in General Account on the date of October I have an exchange rate 1 USD - 60 MXN

Therefore, when I am going to make my first estimate dated October, I can see that the total contractual value is 1,200,000 MXN, ( 20,000 x 60 calculation ). And the porcentage of progress indicated by 10%, therefore I recognize 120,000 MXN.

Then, in November change the exchange rate to 1 USD - 65 MXN

When I am going to make my second estimate in November, it can be seen that this 10% advance is no longer MXN 120,000 because my contractual value changed to MXN 1,250,000. Its no more 1,200,000 MXN.

And those 5,000 MXN difference (between 120000 and 125000) D365FO wants to recognize as if it were revenue...but it is simply the product of the exchange difference from one month to another.

Any ideas?

Thanks!!

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

    Hi,

    At the project contract level, you can define a fixed exchange rate.

    Wouldn't this be an option to get rid of the currency fluctuation effects?

    Best regards,

    Ludwig

  • Macarena Presa Rinaldi Profile Picture
    200 on at

    Hi Ludwig! Thanks for your answer.

    I dont need to avoid exchange rate fluctuations. I require that exchange rate differences be sent to allocated an account of "exchange difference" and not to the revenue account.

    Any idea of a set up?

    Thanks!!

  • Suggested answer
    Ludwig Reinhard Profile Picture
    Microsoft Employee on at

    Hello Macarena,

    Can you test the following:

    For the account that is used for posting the revenue accruals with the estimates, run a foreign currency revaluation in GL.

    The rate that you use should be the one that was valid in October.

    As a result, the November revenue of 125k should be corrected by this foreign currency revaluation by 5k and result in a total revenue of 120k in MXN.

    The posting at the project level will of course not be affected but in your financial reports you should be able to identify the foreign currency revaluation for the different projects that you run provided that you use a project financial dimension.

    Would be great if you could check this out and let us know if it fixes your problem.

    Best regards,

    Ludwig

  • Suggested answer
    Eugen Glasow Profile Picture
    6,359 on at

    Hey Macarena ;)

    Sadly, you are describing a known but "orphaned illness" of the Project module. You can vote for the below suggestion:

    https://experience.dynamics.com/ideas/idea/?ideaid=8a0d7b4d-0b31-e711-80c0-00155d460d59

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
Martin Dráb Profile Picture

Martin Dráb 559 Most Valuable Professional

#2
André Arnaud de Calavon Profile Picture

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

#3
Sohaib Cheema Profile Picture

Sohaib Cheema 250 User Group Leader

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans