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
The FastTrack program is designed to help you accelerate your Dynamics 365 deployment with confidence.
FastTrack Program | Finance TechTalks | Customer Engagement TechTalks | Upcoming TechTalks
We are using Management Reporter 2.12.16000.17 (CU16) with Dynamics AX 2012 R2 CU7.
In one of the companies we have BWP as accounting currency and ZAR as reporting currency.
Default exchange rate is updated daily for BWP & ZAR.
Balance sheet accounts are setup to translate based on Current translation type i.e. to take last exchange rate of the reporting period.
Profit & Loss accounts are setup to translate based on Average translation type i.e. average rate for the reporting period.
Some of the balance sheet main accounts are setup with different opening account i.e. during year end process, move the balance to opening account.
In Management Reporter, we have created a simple Account Balance report with columns displaying ZAR, BWP & calculated exchange rate for BB, Period & YTD:
When we run Account balance report in Management reporter (include all reporting currencies checked). Only the main accounts where opening account is different have the problem with BB columns i.e. it is showing the balance for the reporting currency but showing 0 for accounting currency. Accounting currency balance of 0 is correct & reporting currency balance should also be 0 - since year end process moves the balance to different opening account. This is having an impact on YTD balance also, whereas Period balance is correct. You can see how the exchange rate moves for the problematic accounts.
Did anyone experience same problem or is there any resolution for this?
Does it make a difference if you remove the ZAR reporting currency filter in the columns shown?
Irrespective of that, I am not sure if this will give you the correct result because in AX2012R2 the reporting currency amounts are calculated and converted through the accounting currency transactions. This has changed in D365FO where you can specify a separate currency exchange rate for the reporting currency. Yet, please try to test removing the currency display and try using the currency filter options to see if this makes a difference.
Thanks for the reply.
Original report does not have the currency filter, I just added it to explain the issue. Problem persists regardless of display currency. If you change the currency in web viewer it will give the same output. Problem is with the accounts which have different opening account setup in the GL. All other accounts are fine.
The reporting currency amounts in AX will differ to Management Reporter because AX stores the reporting value against transaction whereas Management Reporter translates based on GL account setup (Balance Sheet at cut off & Profit & Loss at average). For foreign currency translation of reports we don't look at AX.
I looked further and found the value in Management Reporter Datamart database in the ConvertedAmount table. Same values don't exist in AX because AX will hold values without translation. Looks like Management reporter is pulling the reporting currency values for the accounts with different opening accounts - whereas it should be 0.
That's what I feared. I think your scenario is currently not supported in MR.
You can report this and suggest MS to change it in the future.
Here is the platform for doing that: experience.dynamics.com/ideas
Yet, there is no guarantee whether and when MS will provide such an enhancement.
For the moment, I would say that you cannot use this opening account functionality if you want to use the MR report.
I had the same feeling. We thought of few workarounds e.g. to create a consol company and do translation during AX consol but that might be cumbersome. Probably we will remove the different opening accounts and do a customization i.e. to specify opening account in custom fields and then do a automated journal after year end process to move the balances.
Do you really need a new custom field? Can't you just summarize the opening balances of the different accounts for which you use the same opening account in a MR line or column with the help of a calculation?
It might be possible if you use the Tot calculations and some non printing lines/columns.
Please test this first. If it does not work then you can still make the modification :-)
If we calculate in MR only then basic reports like TB will have different output in AX & MR (even for accounting currency). We could probably try and load account transactions in GL transactions and then move the balance manually.
Only sad part is that this bug (if I can call it that) renders standard AX functionality (opening accounts) not usable for companies needing translation - and we have single chart of account for all the entities :)
Agree with that and therefore it is very important that you inform MS about this via the ideas/expierence website.
Otherwise, they might not even know and never fix it.
Would be great if you could create a small note in this portal and possibly use the link to this thread to avoid that you have to write things twice ;-)
Many thanks for your help here!
If there is nothing else open, lets please verify answers to get this closed even if there is no solution available at the moment and we have to ask MS for enhancing the standard product. There is currently nothing else we can do at the moment. Many thanks and best regards, Ludwig
Business Applications communities