Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics AX (Archived) / Currency Exchange Rate...
Microsoft Dynamics AX (Archived)

Currency Exchange Rate Difference

(0) ShareShare
ReportReport
Posted on by oldman.logan 557

Hi all! 

Our default currency is SAR (Saudi Arabian Riyal). We have a ledger account for Exchange Rate Difference and exchange rate differences for payments / transactions in SAR are shown in the account statement for the ledger account for some reason. 

You can see here in the screenshot for the journal GJ-00012082. Ledger Account 6350101003 is the Exchange Rate Difference Account. 

5850.Screenshot.png

The amount currency is 0. The transaction is in SAR. Then why is the account coming here in the first place? Our secondary currency is USD. It shows a balance of -0.010 in the journal but this does not show in the statement of Exchange Rate Ledger Account. 

So to sum it up,

1) Why is the exchange rate account showing such a transaction (even though the value is 0). 

2) Why is the secondary currency being affected as shown in the journal voucher but not appearing in the ledger account statement? 

*This post is locked for comments

  • Suggested answer
    guk1964 Profile Picture
    guk1964 10,877 on at
    RE: Currency Exchange Rate Difference

    Ax comes with two base currencies, one of which is sometimes called seonddary currency, and also sometimes called reporting currency whichis typically used for consolidation or for a fixed rate annual budget.

    Normally the Ledger exchange adjustment program will make sure the USD amount (AmountMST) is accurate based on the given exchange rate. Any profit or loss is posted to another GL account.

    In Ax 2009  the ledger exchange adjustment program does not update AmountMSTSecond values. This code was updated in Ax 2012 and the method LedgerExchAdj.calculateAndPostAdjustments() has a code comment to this effect.

    Since they are not adjusted the amount in the AmountMSTSecond field remains at the rate from when it was posted. If you then try to look at account totals in AmountMST vs AmountMSTSecond you will notice that even after an exchange adjustment all values are not at the new rate. 
    A fix for this in Ax2009 is to update the LedgerExchAdj class. The postDiff() method is the method that determines what value needs to be posted. However, you need a develoepr for that.

  • Suggested answer
    Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at
    RE: Currency Exchange Rate Difference

    Hello oldman.logan,

    I would export all lines of this voucher to Excel and then add up the lines. I would expect seeing a difference for the secondary currency amount, which might be caused by the way how your secondary currency and the rounding rules for this currency are setup. Probably try increasing the decimal rounding precision for this currency and record some test transactions to verify whether this overcomes the issue.

    Best regards,

    Ludwig

  • oldman.logan Profile Picture
    oldman.logan 557 on at
    RE: Currency Exchange Rate Difference

    Thank you Dr. Ludwig. Unfortunately the people who modified the system were previous employees who we are no longer in touch with. We do not have a consultant at the moment and it might take time to figure one out as we are also looking to upgrade from AX 2009. Is it possible to guide me on where I have to check, that might clear the issue? From your reply, shall I assume that the reason why the transaction is appearing in the "Exchange Rate Difference" account is because of the -0.010 appearing as Secondary Currency?

  • Suggested answer
    Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at
    RE: Currency Exchange Rate Difference

    Hi,

    Your system shows three decimal places and a secondary currency.

    Both are non-standard features and must be the result of a modification that has been made.

    Can you talk to one of the developers who applied those changes?

    It might simply be a rounding issue for the secondary currency but maybe there is more and your development expert should be able to find out.

    Best regards,

    Ludwig

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