Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics AX (Archived) / MR shows all values in...
Microsoft Dynamics AX (Archived)

MR shows all values in accounting currency and not reporting currency (USD)

(0) ShareShare
ReportReport
Posted on by ram76.erp 75

MR shows all values in accounting currency (INR) and not reporting currency (USD).
In browser, when I change the currency the report in other currency (GBP, EUR, JPY etc.) runs correctly.
The problem is only when running with reporting currency USD.
This is happening with all accounting currencies in different companies.
Version info: Ax 2012 R2 CU6, MR 2012 CU16.
GL main account MR setup: ExchRateType: Default; CurrTransType: Current
(With or without the below setup the error occurs still).
In MR, include all reporting currencies is marked.
In MR column definition: Currency Display: 'USD'.
For sample, I am only running Trial Balance (TB) in MR.

*This post is locked for comments

  • Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at
    RE: MR shows all values in accounting currency and not reporting currency (USD)

    Hi,

    Is there any update on this?

    Did you make any progress or does the issue still exist?

    Best regards,

    Ludwig

  • Suggested answer
    Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at
    RE: MR shows all values in accounting currency and not reporting currency (USD)

    Hi Ram,

    Do you know what might have changed in your system for the last 3 months?

    Has the reporting currency been changed or have some other modifications been made that finally made the MR report running correctly in USD for the last 3 months?

    Have you checked the MR log files to identify what problems might have occured?

    As a last means of resort you can possibly reset the data mart to get the data refreshed and hopefully correctly reported.

    Best regards,

    Ludwig

  • ram76.erp Profile Picture
    ram76.erp 75 on at
    RE: MR shows all values in accounting currency and not reporting currency (USD)

    To add, the MR report for USD is running correctly for last 3 months (Jun, Jul, Aug 2018).

    Any months before that the report is not translating the amount.

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,280 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,214 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans