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 :
Small and medium business | Business Central, N...
Suggested Answer

Exchange Difference calculate in original amount

(0) ShareShare
ReportReport
Posted on by 15

Hello everyone,

I'm working with a customer who did the following: 

- Posted an Invoice on may 2020 in EUR (with functional currency USD)

- Posted a credit memo on december 2020 in EUR (with a different exchange rate).

When they try to apply both documents through vendor movements, it calculates exchange differences in functinal amount and original amount (it creates a pending amount in EUR). 

If I try to apply them using general journal, it doesn't calculate any exchange difference in original amount. Only calculates the exchange difference originated by using 2 exchange rates (one in the invoice and one in the credit memo). 

Could anyone help me understanding this procedure?

Thank you. 

Regards

I have the same question (0)
  • Suggested answer
    Community Member Profile Picture
    on at

    Rolando,

    Each document will calculate check what Exchange Rate it uses at time of posting. You noted you have 2 different rates, but the EUR stayed the same. That is logical since you posted 2 separate documents using 2 different rates to USD. The 2 documents will not 100% match and therefore result in an exchange rate difference. May I recommend that when you want to reverse the entire invoice you can update the document Exchange Rate to match the one used by clicking the 3 dots next to the Currency Code.

    pastedimage1612397747544v1.png pastedimage1612397766997v2.png

    Since you have posted the documents, I would reverse the Credit Memo (Correct) and then process the same document with the same Exchange Rate that the Invoice used so the 2 documents can be applied-to. You can also, in the Credit Memo, enter the Applies-to No. so it self-applies.

    Hope this helps.

    Thanks,

    Steve

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 > Small and medium business | Business Central, NAV, RMS

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 3,151

#2
Jainam M. Kothari Profile Picture

Jainam M. Kothari 1,443 Super User 2025 Season 2

#3
YUN ZHU Profile Picture

YUN ZHU 1,092 Super User 2025 Season 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans