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

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics AX (Archived) / Exchange rate fluctuat...
Microsoft Dynamics AX (Archived)

Exchange rate fluctuation in Project accounting module

(0) ShareShare
ReportReport
Posted on by Community Member

Hi All,

While invoicing the hour journal, User invoiced with different date.According to the Hour journal date,they did not post the invoice. Exchange rate value is having different values between the two dates. So, Some variations is displaying in the Voucher transactions and in the report.

Can you please any body give me the advice to solve this exchange rate fluctuation  for Time and material project.

Thanks & Regards,

G. Abila

*This post is locked for comments

I have the same question (0)
  • André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 303,730 Super User 2026 Season 1 on at

    Hi Abila,

    Can you explain a bit more on your requirements and the difference with current behavior? Note that you can set a fixed exchange rate for the complete project on the Project contract but this might not be your requirement.

  • Community Member Profile Picture
    Community Member on at

    Hi Andre,

    Thanks for your reply.

    (E.g): In the currency master, Exchange rate value is fixed as Different exchange rate value for different date.

    While invoicing the hour journal by on account, User has invoiced for different date.

    So, While running the Project WIP Report, WIP-Sales value is  displaying the variation amount. But, Hour qty is displayed as Zero value. The project was invoiced completely . But, still some variation is displayed in the report. I want zero value in the report. Please give me advice how to solve the exchange rate fluctuation in the AX 2009 environment.

    Thanks & Regards,

    G. Abila

  • Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at

    Hello Abila,

    What I got is that you have a remaining balance on your WIP sales value account caused by a foreign currency fluctuation. Is that right?

    Can you check what the project WIP reconciliation report shows you? (GL/reports/Project/Reconciliation/Ledger reconciliation - WIP).

    Have you run foreign currency revaluations in AP, AR and GL?

    Ludwig

  • Suggested answer
    Community Member Profile Picture
    Community Member on at

    Hi, Thanks to all.

    Yes. It was happened, due to foreign rate fluctuation. I gave the advice as raise the credit note and create new invoice proposal for corresponding hour journal.

  • Community Member Profile Picture
    Community Member on at

    Hi Ludwig. I have the same issue and the discrepancy amount does appear on the Ledger reconciliation – WIP report. I ran foreign currency revaluations, but I didn’t run it on the WIP account. When I try running it on the WIP account through GL FX, it only updates GL, it doesn’t change the WIP amount on the Project itself. Is there way to fix the project side?
    Tatyana

  • Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at

    Hi Tatyana Wentzel,

    The GL FX revaluation does not affect your projects.

    Why do you need to run a foreign currency revaluation for your projects?

    Can you be sure that the report data are correct because a couple of hotfixes have been released for the Ledger-WiP reconciliation report.

    Probably check the hotfixes on LCS first.

    If you cannot find something on LCS can you analyze the transactions and their origin to identify what caused the issue?

    Best regards,

    Ludwig

  • Community Member Profile Picture
    Community Member on at

    When timesheet was posted, WIP was posted at one exchange rate, and when timesheet was later invoiced, WIP was cleared at the different exchange rate. So, even though, in the transactional currency WIP is cleared, in the reporting currency , there is an amount sitting on the project WIP. I'm just looking for ideas of how to clear it.

  • Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at

    Hi Tatyana,

    Why do you want to clear this at all?

    For what purpose do you use the secondary currency?

    Best regards,

    Ludwig

  • Community Member Profile Picture
    Community Member on at

    Hi Ludwig. We have USD contract in India company, which has INR as a reporting currency. So, WIP is posted in USD, while INR is the reporting currency. The reason we want to clean is because it's showing on the project statement. When project is complete, WIP should be 0. But in this case, it's showing an amount that we can't zero out. 

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Meet the Microsoft Dynamics 365 Contact Center Champions

We are thrilled to have these Champions in our Community!

Congratulations to the March Top 10 Community Leaders

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1
Joris dG Profile Picture

Joris dG 5

#2
Andrew Jones a1x Profile Picture

Andrew Jones a1x 2

#3
GL-01081504-0 Profile Picture

GL-01081504-0 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans