Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics AX (Archived) / question about the exc...
Microsoft Dynamics AX (Archived)

question about the exchange rate

(0) ShareShare
ReportReport
Posted on by Community Member Microsoft Employee

Hi There

My client has a requirement like below:

At the begin of each month, they estimate an "Exchange Rate", and all the transaction will be posted by this exchange rate, but by the end of that month, they will get another "Exchange Rate" from the bank. if the "Exchange rate" from bank is higher than the "estimated exchange rate", then the variance will be posted into a gain account, but if the "Exchange Rate" from bank is lower than the "estimated exchange ate", then the variance will be posted into the loss account.

How to meet this kind of requirement in the AX system?

many thanks.

*This post is locked for comments

  • Verified answer
    Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: question about the exchange rate

    Hello Jianrui,

    In the form you select the date from 1 july till 31 July. Then you select the ledger accounts you want to revaluate (not customer or supplier balances!) Then you select the currency rate date which is July/30/2014. Then you execute.

    If something has been posted on the selected ledger for example 100 USD valued 800 CNY the executing the revaluation will value the posting at 850 CNY. If you selected both ledger accounts (so the original debit and credit) this will result in a gain and loss.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: question about the exchange rate

    Hi Carla

    Suppose i do something as below:

    i configured a exchange rate

    1. from July/01/2014 to July/30/2014, (USD to CNY rate : 8)

    2. from July/30/2014 to July/31/2014, (USD to CNY rate : 8.5)

    and suppose i run the "Foreign Currency Revaluation" job, what will happen ?

  • Suggested answer
    Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: question about the exchange rate

    General Ledger/Setup/Currency/Currency exchange rates. There is a from and to date there.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: question about the exchange rate

    Hi Sunil,

    Where i can enter the month end rate? how the system know where is the month end rate?

    many thanks

  • Suggested answer
    Sunil Profile Picture
    Sunil 755 on at
    RE: question about the exchange rate

    First ensure that you have both the gain account and loss account defined in the chart of accounts.

    The specify these account per currency under General Ledger > Setup > Currency > Currency revaluation accounts

    Enter your estimated rate at the beginning of the month and all the transaction will be captured on that rate. 

    At the end of the month, enter the month end rate (the one provided by the bank and the one you use for revaluation)

    Run the revaluation function (General Ledger > Periodic > Foreign Currency Revaluation) and the exchange gain / loss shall be automatically written to the corresponding accounts.

  • Suggested answer
    Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: question about the exchange rate

    Hello Jianrui,

    AX is very capable of handling exchange rates and revaluating at certain times, the only question I have is: what do you want to revaluate? Because if it is customer balance or supplier balance you have to do it from those modules. (and it will only revaluate what is still open) If you want to revaluate on ledger accounts the next question is: which ones? Because if you do all accounts there won't be a profit or loss, because all posting have a debit and credit side.

    The Gain or loss account can be found under General Ledger/Setup/Ledger

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,214 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans