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

Exchange Difference in original amount

(0) ShareShare
ReportReport
Posted on by

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 functional amount and original amount (it creates a pending amount in EUR). I understand why the exchange difference is created, what I don't understand is why it causes a change in the original amount.

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

    Belen - Your customers scenario was a previous post in the community. Here is the link:

    community.dynamics.com/.../exchange-difference-calculate-in-original-amount

    Hope this helps.

    Thanks,

    Steve

  • Community Member Profile Picture
    on at

    Hello Steve, Thank you! Yes, I've seen it, but the suggestion there is to re-do the document using the same exchange rate. The problem is not the exchange difference, but that the calculation modifies the original currency amount.

    I had an original transaction of 1.000 Euros and the credit memo for 1.000 Euros (the only thing that differs is the exchange rate for Dollars). But when I choose the preview posting, it calculates not only the exchange difference in functional currency, but in original currency as well.

    Besides that, when I do the same transaction using journals, it calculates the same exchange difference, but only in functional amount (the original currency amount stays the same).

    I hope to have explained myself and that you can help me. Thank you!

  • Suggested answer
    Laeticia Cunha Profile Picture
    Microsoft Employee on at

    Hello Belen,

    To be sure that I understood your issue, let me try to share an example:

    1. I created an Invoice in EUR 1000 with an Exchange Rate of 0.6458 so the Local Currency will be 645.80

    2. Then I create a credit memo for this Invoice, however, the Exchange Rate has changed to 0,90, so in EUR the Credit Memo is still 1000 EUR and in the Local Currency I have now 900.00

    3. With this scenario I will have the following entries in the Vendor Ledger Entries:

    pastedimage1612806813603v1.png

    • Original Amount - This field shows the original value of the purchase document, so in both documents, the Original Amount is 1000 EUR.  The amount is not updated by any subsequent application or exchange rate adjustment.
    • Original Amt. (LCY) - This field shows the original value of the purchase document, in the local currency. In this field it is possible to have different values, because of the Exchange Rate, that is why we have the Amount 645,80 (Invoice) and 900.00 (Credit memo). The amount is not updated by any subsequent application or exchange rate adjustment.

    • Amount – This field will present the Amount of the document in the Currency Code posted in the corresponding document. 
    • Amount (LCY) – It will show the actual Amount of the Document in the Local Currency. This field is a FlowField, so it can be updated due to the exchange rate adjustment or Realized Gain/Loss in this case, for example. This way, it will be possible to control correctly the balance of the Vendor.

    In this example, the Amount (LCY) field shows the same value, because of the Realized Loss that the system posted and recognized when both documents are applied. What does this mean?

    If you click in the Amount (LCY) files, you will see that a Realized has been posted, so the document can be closed and a loss has been recognized to the company, due to the exchange rate.

    pastedimage1612805583825v4.png

    In summary, we can have different values in the Original Amount due to this scenario, this field is informative about the original amount of the document.

    I hope that I understood correctly your question if not let me know.

    Thank you in advance for your understanding.

    Kind Regards, 

    Laeticia Cunha

     

    Please see our Dynamics 365 Business Central Support Team Blog for helpful information:

    https://dynamics.microsoft.com/en-us/business-central/capabilities/

    Don't forget to help the community by verifying the answer or at least like the suggestion if it did help in any way. It will let others know that the topic has verified the answer and was beneficial to you.

  • Suggested answer
    Community Member Profile Picture
    on at

    Belen,

    I hope Laeticia's explanation answered your question off your reply to me. If we've not answered correctly, please advise.

    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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Congratulations to our 2025 Community Spotlights

Thanks to all of our 2025 Community Spotlight stars!

Leaderboard > Small and medium business | Business Central, NAV, RMS

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 2,055 Super User 2026 Season 1

#2
YUN ZHU Profile Picture

YUN ZHU 1,063 Super User 2026 Season 1

#3
Dhiren Nagar Profile Picture

Dhiren Nagar 1,014 Super User 2026 Season 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans