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

Community site session details

Session Id :
Microsoft Dynamics 365 | Integration, Dataverse...
Suggested answer

Exchange Rate differences

(0) ShareShare
ReportReport
Posted on by
Hi. We usually update exchange rates at month end. We noticed that a realised exchange rate gain/loss can be created, even if both invoice date and payment date (entered in via payment journal) are the same date. 
 
What could be the possible causes of this? 
Categories:
I have the same question (0)
  • Jonas "Jones" Melgaard Profile Picture
    Super User 2025 Season 2 on at
    Exchange Rate differences
    Hi @CU07080632-5,
    Can you mention the Dynamics product you are using? Then I'll move it to the product specific forum (-:
     
    Great you have answered this;  I think your reply might be an AI-assisted post, but I do not see any tools or sources cited.
     
    The reason why is is that it's getting flagged by the tools I'm using to identify generative AI, we don't know the product yet, and the different background color of the bullet points.
     
    Can you update the post to include your sources, or confirm this was not produced using AI?
     
    Please refer to the article about writing replies in the community: Writing effective responses in the community
    You should also find the guidelines in the private moderator forum.

     
  • Suggested answer
    DAnny3211 Profile Picture
    Moderator on at
    Exchange Rate differences

    Hi CL007080632-5,

    This is a good observation, and it can definitely be confusing when exchange rate differences appear even though the invoice and payment dates are the same.

    Possible causes include:

    1. Exchange Rate Timing

    Even if the dates match, the exchange rate used for the invoice and the payment might differ if:

    • The rates were updated between the time the invoice was posted and the payment was made.
    • The system uses different rate types (e.g., spot vs. average) for invoices and payments.

    2. Currency Rounding Differences

    Minor rounding differences in currency calculations can sometimes trigger small gains or losses, especially in high-volume or multi-currency environments.

    3. Posting Date vs. Document Date

    Ensure that both the posting date and document date are aligned. If they differ, the system might apply different exchange rates based on the posting date logic.

    4. Manual Rate Overrides

    If someone manually entered an exchange rate during either transaction, it could override the default rate and cause a discrepancy.


    Let me know if you'd like help checking your exchange rate setup or journal configurations.

    If this answer was helpful, please consider marking it as accepted.
    Best regards,
    Daniele

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

Mansi Soni – Community Spotlight

We are honored to recognize Mansi Soni as our August 2025 Community…

Announcing our 2025 Season 2 Super Users!

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

Congratulations to the July Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Microsoft Dynamics 365 | Integration, Dataverse, and general topics

#1
Amitsb1980 Profile Picture

Amitsb1980 17

#1
CU06061003-0 Profile Picture

CU06061003-0 17

#1
LR-09071359-0 Profile Picture

LR-09071359-0 17

Product updates

Dynamics 365 release plans