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 :
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

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

  • Suggested answer
    Community Member Profile Picture
    Community Member on at

    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

  • Suggested answer
    Sunil Profile Picture
    Sunil 763 on at

    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.

  • Community Member Profile Picture
    Community Member on at

    Hi Sunil,

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

    many thanks

  • Suggested answer
    Community Member Profile Picture
    Community Member on at

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

  • Community Member Profile Picture
    Community Member on at

    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 ?

  • Verified answer
    Community Member Profile Picture
    Community Member on at

    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.

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

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Women in Power Builds Momentum

Expanding mentorship, skilling, and AI innovation

Congratulations to the August Top 10 Community Leaders

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1
Prashant Singh Profile Picture

Prashant Singh 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans