Skip to main content

Notifications

Announcements

No record found.

Small and medium business | Business Central, N...
Suggested answer

Exchange Difference in original amount

Posted on by Microsoft Employee

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

  • Suggested answer
    Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Exchange Difference in original amount

    Belen,

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

    Thanks,

    Steve

  • Suggested answer
    RE: Exchange Difference in original amount

    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.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Exchange Difference in original amount

    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
    Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Exchange Difference in original amount

    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

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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,269 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,198 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans