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) / AP/AR foreign currency...
Microsoft Dynamics AX (Archived)

AP/AR foreign currency revaluation by dimensions

(0) ShareShare
ReportReport
Posted on by yetxxx 55

Hi , guys, 

We have  problem  when running  AR/AP currency revaluation .

If there are more than 1 kind of currency, run the AR/AP currency revaluation with dimension method , the data is incorrect
AX version : R3 Cu10
Point:
1,the VourchNum is the same.
2, contains different currency
Here is the Journal I used to test

8863.1.JPG

the rate I used to test

6735.2.JPG

then run  the currency revaluation in AR

3630.3.JPG

The resut AX run
the value in Main account 660303 is correct, Because 100(EUR)*900(NewRate)-100(EUR)*800(oldRate)= 100 (CNY)
but there are 2 lines in 11220101 main account is incorrect, I only have 1 line that has foreign currency, it seems the other line CNY is also revalued.

1512.4.JPG

I asked our developer why it happens like the , he traced the code , it seems AX did the distribution on purpose
the logic is 100(EUR)+1000(CNY)=1100, so euro is 100/1100, and CNY is 1000/1100
So 100/1100* 100 = 9.09
and 1000/1100 = 90.91
this is the logic our developer traced the code and explained for me.

Here is  the functions list.

7041.5.JPG

From the financial side, this logic is not correct.

and this case is only happened different currency in the same voucher and run
AP/AR foreign currency revaluation with dimension method
Maybe the AX designer the didn’t consider the case that different currency in the same voucher, then i  think  this is  a bug , or if  there any parameters to control this but we don't  know.

Pls  kindly advise.

*This post is locked for comments

I have the same question (0)
  • yetxxx Profile Picture
    yetxxx 55 on at

    the impact is very  big for our users. Although we  can advise  users  not use such kind of input method, the initial financial data we import  was  in the same voucher ,which can not  be easily cleared.

    And we cant even use cust/vend transaction settlement. because the foreign currency revaluation will be executed  automatically, and the result will  be incorrect.

  • Suggested answer
    ZvikaR Profile Picture
    ZvikaR 184 on at

    Your suspicions might be right.

    I think the scenario of 2 currencies in the same voucher is quite rare, at least with users using Dynamics AX.

    Personally  I have not seen in past any client on Dynamics AX using multi-currency vouchers.

    .

    Furthermore, your scenario takes it one step further and creates a customer invoice broken by 2 currencies - that's a more obscure way to record things in the AR module.

    It is quite possible the Microsoft design did not take such scenario into account, and in effect the product does not support this scenario.

    You can register that as a defect with Microsoft try to convince them they need to improve the logic to support it.

    On the other hand, can you elaborate what is the business scenario that leads you to record a customer invoice with 2 currencies?

    maybe you'll be better off moving to a more "standard" way of recording your transactions.

  • Suggested answer
    Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at

    Hi,

    Have you already checked LCS for an available hotfix?

    Can you replicate the issue in one of your demo environments?

    Best regards

    Ludwig

  • yetxxx Profile Picture
    yetxxx 55 on at

    I didnt find any hotfix  in lcs, I test this case in R2 and in R3 of some other AX server, It's just the same result

    By the way , I dont know how to report bug  to MS yet. I heard some "rumors" from our develop consultant if you  want to report a bug to MS, you  need to prepare 100$ for investigation， until MS admit this is  a real bug, they will  gave  you the 100$ back, If they dont think it is a bug, the 100$ will  be  taken away. Is this true? 

    Actually  I found another bug for ax, but I found a workaround, so it's  not  so critical. 

    would you advise  how to report bug to MS?  

  • Suggested answer
    Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at

    Hi yetxxx,

    I have not heard about this $100 thing. You should be able to report a bug through LCS.

    Best regards,

    Ludwig

  • yetxxx Profile Picture
    yetxxx 55 on at

    I did notice it too.  if in AP/AR, currency is in table head which can perfectly stop this scenario.but in GL, currency is in trans table, which technically  support this case.

    It's easy to ask our finance team to input the data in a "standard" way,  but its really a headache to clean those transaction that already happened.

  • Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at

    Hi,

    An important question is whether you need to run the foreign currency revaluation in GL. Do you have ledger accounts for which you need to run the reval. process?

    Best regards

    Ludwig

  • yetxxx Profile Picture
    yetxxx 55 on at

    Yes ,I need to run  foreign currency revaluation in GL, but only for those none AP/AR related main account.

    In other  words , the main accounts for AP/AR  will not be consider to run  in GL( (mainaccount.exchageAjusted fied is not checked )

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Meet the Microsoft Dynamics 365 Contact Center Champions

We are thrilled to have these Champions in our Community!

Congratulations to the March Top 10 Community Leaders

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1
Joris dG Profile Picture

Joris dG 5

#2
Andrew Jones a1x Profile Picture

Andrew Jones a1x 2

#3
Basit Profile Picture

Basit 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans