Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics NAV (Archived) / Share Exchange Rate in...
Microsoft Dynamics NAV (Archived)

Share Exchange Rate in all companies

(0) ShareShare
ReportReport
Posted on by Mitr 182

Hello Experts,

I have a situation below:

Shared Exchange Rate
After input Exchange Rate in one Company, all companies will be able to use it.
But note that not all the companies have the same LCY.

To get this done I thought changing data per company to NO in currency exchange rate table but I don't think it would be a better solution.

Second thought was to create a webservice of Page : 483-->Currency Exchange Rates & then sync the data to other companies. But not sure how to proceed on this.

Can please help me guide on this.

Thanks

*This post is locked for comments

  • Mitr Profile Picture
    Mitr 182 on at
    RE: Share Exchange Rate in all companies

    Hello Stefano,

    Thanks for your help on this issue.

    Currently I am facing another issue but that in report.

    Can you please provide your comments on this, below is the link for it:

    community.dynamics.com/.../283365

    Thanks

  • Suggested answer
    Mitr Profile Picture
    Mitr 182 on at
    RE: Share Exchange Rate in all companies

    Hello Stefano,

    Thanks for response again.

    Yes agreed, I will go ahead with it.

    Thanks again for help me out.

  • Suggested answer
    Stefano Demiliani Profile Picture
    Stefano Demiliani 37,162 Most Valuable Professional on at
    RE: Share Exchange Rate in all companies

    If the companies have different base currencies having DataPerCompany = NO I think it could be a problem. The Exchange Rate Amount is related to the base currency, so replication is not good.

    If Company A has base currency = EUR and you enter here the currency rate to GBP = X, how this must be replivcated in company B where the base currency is for example USD? You cannot write the currency rate for GBP = X because it's incorrect. Jens has suggested the right thing in this case.

  • Suggested answer
    Mitr Profile Picture
    Mitr 182 on at
    RE: Share Exchange Rate in all companies

    Hello Jens,

    Thank you so much for your response & resolving my confusion.

    I got it now.

    I know financials most less that's why needed suggestion.

    This makes things very clear:-

    "What I wrote about the relational exchange rate applies in this case as well. Meaning, when you copy the exchange rate and the target has a differing LCY, you need the LCY code of the origin as the relational currency code. NAV can handle relational exchange rates and calculates the whole chain to get the right currency factor."

    I will go ahead with your suggestion & remind customer once more.

    I told them once but they still want that manual.

    Thanks for your help again.

  • Verified answer
    Jens Glathe Profile Picture
    Jens Glathe 6,092 on at
    RE: Share Exchange Rate in all companies

    Hi Mitr,

    no, it won't. The underlying question is why does the customer want to use manually entered exchange rates... Anyway. I would create a batch job that does the distribution and put it in the menu. Main reason is that you usually have more than one currency to maintain, and typing errors are not unusual. That way the user has to make a conscious decision when he's done editing and does the distribution. You can remind him if he's leaving the page without distributing them, though.

    What I wrote about the relational exchange rate applies in this case as well. Meaning, when you copy the exchange rate and the target has a differing LCY, you need the LCY code of the origin as the relational currency code. NAV can handle relational exchange rates and calculates the whole chain to get the right currency factor. Since it is the more complicated version of setup, I would make the customer aware of it.

    with best regards

    Jens

  • Mitr Profile Picture
    Mitr 182 on at
    RE: Share Exchange Rate in all companies

    Hello Jens,

    Thank you very much for your response, I saw that in many blogs.

    Howevr the user wants to modify the exchange rate manually and upon that the rates should be updated automatically in other companies.

    I am sorry I missed to mention that user wants to enter exchange rate manually in one company and updated to other companies automatically.

    Will the above work for this situation as well ?

    Thank you very much for your response again.

  • Mitr Profile Picture
    Mitr 182 on at
    RE: Share Exchange Rate in all companies

    Hello Stefano,

    Thank you very much for your response.

    For data per company= NO, If we have multiple companies and every companies base currency is different then will it work?

    Else I would go for second option.

    Thanks for your fast response again.

  • Suggested answer
    Jens Glathe Profile Picture
    Jens Glathe 6,092 on at
    RE: Share Exchange Rate in all companies

    Hi Mitr,

    interesting setup. Changing the exchange rates table to global is not a good idea. Syncing the data via batch job would be my choice, however I would try to avoid automated syncing on every modification. The newer versions of NAV have currency exchange rates services that can be scheduled as batch job, why don't you use these? You can set them up per company (okay, multiple requests to the provider but if you use these numbers anyway, who cares). The advantage is that you don't need much coding, no coding in the best of all cases. And you can use the same provider even if the LCY is different - the only thing to do is set up the field mapping with a relational currency code (the one of the provider, like EUR for ECB). Add a schedule, and you're good. Took me half an hour to add ECB rates in a W1 demo setup (LCY there is GBP), there was no coding required.

    with best regards

    Jens

  • Suggested answer
    Stefano Demiliani Profile Picture
    Stefano Demiliani 37,162 Most Valuable Professional on at
    RE: Share Exchange Rate in all companies

    DataPerCompany = NO could be the better solution if data in this table must be shared between all companies (and also the easy way).

    Otherwise, you could create a solution to replicate the data via C/AL (for example, in OnAfterInsert event or OnAfterModify event of a company, you could trigger a function (event subscriber) that performs a CHANGECOMPANY and writes the record also to the other companies.

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,253 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,188 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans