Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / Z-US$ vs. USD for Mana...
Microsoft Dynamics GP (Archived)

Z-US$ vs. USD for Management Reporter

(0) ShareShare
ReportReport
Posted on by Community Member

Hello:

Our US companies in GP use the Z-US$ currency ID for reporting in US Dollars, while our international companies use the USD currency ID for reporting in US Dollars.

In Management Reporter column definitions (within the "Currency Display" field), I have a column for Z-US$ and a separate column for USD.  Finally, I have a column that adds these two columns together.

I have this "theme" running throughout such column definitions, so that Management Reporter captures (for each company) the correct US currency ID and therefore the correct US currency amounts.

This is the only way that I know how to do this.  I believe that the figures are generating accurately, but it is taking a long time for the reports to generate--even with using "Financial" as the Detail Level.

First, am I correct in using this column calculation?  Secondly, is there a way to make the financials generate faster?

Thanks!

John

*This post is locked for comments

  • Community Member Profile Picture
    Community Member on at
    RE: Z-US$ vs. USD for Management Reporter

    Thanks, Sean!

    I'll check on the memory.

    Someone set up our GP, before I came onboard.  For some reason, USD was set for the foreign entities while Z-US$ was set for the stateside entities.

    I wish they were all set with either just Z-US$ or just USD.  Then, I would not have to add two columns together, where I have one column for Z-US$ and the other for USD.

    By the way, this happens for a 13-month trended statement.  The tree allows you to select the entities.  When I choose the "Consolidated" branch, the report generates but takes about ten minutes.  If I choose one of the entities, I get a timeout error.  I'll have to change a setting to eliminate that timeout error.

    If on the other hand I use a "Consolidated" column definition with each column pointing to an entity (domestic or international) by way of the tree's reporting unit, the report generates within a reasonable timeframe, if I remember correctly.

    John

  • drummerboy_10 Profile Picture
    drummerboy_10 on at
    RE: Z-US$ vs. USD for Management Reporter

    Hi John -

    Given you have entities reporting in two different US dollars Currency ID's, I don't see where you have a choice but to add those two columns together like you are in Management Reporter.  However, if all the entities are reporting in US Dollars, then why can't they all use the USD currency ID?  

    As far as the reports running faster, with Management Reporter, the bigger and more complex the report, the bigger the query, thus the more time it will take to render the results.   However, I would make sure you have enough memory on the SQL box and all but 2 gb is dedicated to SQL server.   How much memory do you have on the SQL box?

    Regards,

    Sean

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

Daivat Vartak – Community Spotlight

We are honored to recognize Daivat Vartak as our March 2025 Community…

Announcing Our 2025 Season 1 Super Users!

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

Kudos to the February Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 231,436 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans