Skip to main content

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Microsoft Dynamics GP (Archived)

Management Reporter--Reporting for US and Overseas Companies

(0) ShareShare
ReportReport
Posted on by Microsoft Employee

Hello:

Yesterday, for Management Reporter 2012, I switched from the Data Mart to the Legacy Provider.  I have both in place, though I'm trying to use the Legacy Provider since the figures have been more accurate.

I'm generating an income statement which, of course, contains a reporting tree pointing to all company databases.

Although each company has a functional currency assigned, of course, I'm getting an error message upon printing this statement pertaining to the foreign companies.  The error says that "Currency Z-US$ Does Not Exist".  So, no values for those foreign companies are returned.

I don't get it.  Who cares if that entity doesn't use Z-US$?  More specifically, why does Management Reporter care and what's the fix?

Now, this happens if I'm logged in to a company that has "-Curr" appended to the company ID. 

If I log into a company without "-Curr", data for the foreign companies are returned but not for the US-based companies that have Z-US$ as their functional currency.

This is strange.  I need to have consistency.

Can I not report on companies all at once, regardless of their functional currency? 

If someone could give some insights, on this, I'd greatly appreciate it!  :)

Thanks!

John

*This post is locked for comments

  • Verified answer
    Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Management Reporter--Reporting for US and Overseas Companies

    I figured this out.  I had to select "FUNCTIONAL" in the Currency Display section of the Column Layout.  That was it!

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

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Vahid Ghafarpour – Community Spotlight

We are excited to recognize Vahid Ghafarpour as our February 2025 Community…

Tip: Become a User Group leader!

Join the ranks of valued community UG leaders

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 292,494 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 231,305 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans