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) / Management reporter in...
Microsoft Dynamics AX (Archived)

Management reporter incorrect reporting currency beginning balances for the account with different opening account

(0) ShareShare
ReportReport
Posted on by Community Member

Hi there,

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.

6011.currency-setup.PNG

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.

bs-translate.PNG

Profit & Loss accounts are setup to translate based on Average translation type i.e. average rate for the reporting period.

pl-translate.PNG

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.

opening-account.PNG

In Management Reporter, we have created a simple Account Balance report with columns displaying ZAR, BWP & calculated exchange rate for BB, Period & YTD:

mr-col-def-2.PNG

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. 

3348.output.png

Did anyone experience same problem or is there any resolution for this?

Thanks

*This post is locked for comments

I have the same question (0)
  • Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at

    Hi,

    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.

    Best regards,

    Ludwig

  • Community Member Profile Picture
    Community Member on at

    Hi,

    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.

    Regards,

    Khalid

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

    Hello Khalid,

    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.

    Best regards,

    Ludwig

  • Community Member Profile Picture
    Community Member on at

    Hi Ludwig,

    Thanks for the reply.

    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.

    Regards,

    Khalid

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

    Hello Khalid,

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

    Best regards,

    Ludwig

  • Community Member Profile Picture
    Community Member on at

    Hi Ludwig,

    Thanks for the reply.

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

    Regards,

    Khalid

  • Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at

    Hello Khalid,

    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!

    Regards,

    Ludwig

  • Community Member Profile Picture
    Community Member on at

    Thanks Ludwig.

  • Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at

    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

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
Alexey Lekanov Profile Picture

Alexey Lekanov 2

#2
Henrik Nordlöf Profile Picture

Henrik Nordlöf 2 User Group Leader

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans