Personalized Community is here!
Quickly customize your community to find the content you seek.
Choose your path Increase your proficiency with the Dynamics 365 applications that you already use and learn more about the apps that interest you. Up your game with a learning path tailored to today's Dynamics 365 masterminds and designed to prepare you for industry-recognized Microsoft certifications.
Visit Microsoft Learn
2020 Release Wave 2Discover the latest updates and new features to Dynamics 365 planned through March 2021.
Release overview guides and videos Release Plan | Preview 2020 Release Wave 2 TimelineWatch the 2020 Release Wave 1 virtual launch event
Ace your Dynamics 365 deployment with packaged services delivered by expert consultants. | Explore service offerings
Connect with the ISV success team on the latest roadmap, developer tool for AppSource certification, and ISV community engagements | ISV self-service portal
The FastTrack program is designed to help you accelerate your Dynamics 365 deployment with confidence.
FastTrack Program | Finance TechTalks | Customer Engagement TechTalks | Upcoming TechTalks
For some reason, each currency revaluation run, AX only picks up two currency to generate gain/loss (screenshot 2).
If I leave the From currency code blank and To currency code EUR, AX picks up the remaining 2 to generate gain/loss.
If I leave the From currency code EUR To currency code USD, it also picks up the remaining 2 currency code to generate gain/loss.
It seems to me that regardless of what From currency code or To currency code is, AX takes the transaction currency and convert them to the accounting currency but only two transactions at a time.
Does anyone see different results?
Can't you leave the currency code fields simply blank to get a revaluation of all currencies that you use?
I usually never make use of the currency code restrictions. Why would you?
What transaction do you currently have on this account and what is the expected outcome? Dynamics AX is evaluating the balance for the revaluation; not the individual transactions. A revaluation per currency is correct.
Do you have transactions in currencies between CHF and EUR which are skipped?
Yes, they all have transaction amounts and the gains/losses are much bigger than the rounding.
If you know you have transactions, double check the posting period. Can you share those transactions?
Can you elaborate what you mean by saying that the gains/losses are much bigger than the rounding?
Some illustrative screenprints would help.
I do a manual calculation outside of the system, in my spreadsheet, to make sure that when I run a currency revaluation, AX gives me the same gain/loss numbers. Mostly yes, AX gives me the same numbers.
To answer your question, my GL parameter rounding is .10. My gain/loss is $.06. AX does not have the $.06 in the Revaluation Report. This is what I meant, on the previous thread, that my gains/losses are higher than my rounding.
I have looked into the GL parameter and the currency setting. I guess there are not many set up to look into. It wouldn't be something technical, right?
If you think of something, anything at all, please let me know. Thanks so much!
If you round values to 0.10 then your excel calculation will never match what you see in AX.
Yet, before performing those double checks assess whether this makes really sense because at the end of the day those revaluations are unrealized profits/loss and unless you talk about really large currency fluctuation amounts, I would not worry about penny's that are not material from a financial / auditing perspective.
About your second response:
Please double check your main accounts whether the revaluation parameter is set for all of the accounts that you use. You can find it in each account in your CoA.
Business Applications communities