Dynamics 365 CommunityForums Microsoft Dynamics GP (Archived) Management Reporter Co...

Management Reporter Column Definition "Throwing Out" Accounts

(0) Share

Report

Posted on by Community Member Microsoft Employee

Hello:

We are using Management Reporter 2012 CU13. We have a balance sheet that shows accounts and data accurately, in local (i.e. functional currency) for our US and international entities.

Within that same report definition, when we change the column definition to a definition that instead translates amounts into US dollars (Z-US$), six accounts (and their amounts) no longer appear.

Why would changing the column definition make a difference? (This report definition uses the same row definition.)

These accounts, indeed, have amounts. The only thing that is "special" about these six accounts is that they are of the "Historical" currency translation type and are specified as such in the Account Currency window. And, we have an historical exchange table specified in the Multicurrency Setup window.

Any ideas?

Thanks! Much appreciated!

John

*This post is locked for comments

All responses (2)

Answers (1)

Bill Campbell 22,647 on at

Like (0)

Report

RE: Management Reporter Column Definition "Throwing Out" Accounts

Fun when you figure out your own problem - good to post - but now, mark your answer as 'answered my question' to close the case.
Verified answer

Community Member Microsoft Employee on at

Like (0)

Report

RE: Management Reporter Column Definition "Throwing Out" Accounts

Disregard....I figured this out. I had to use GP's Currency Translation window to update with historical exchange rates and click "Calculate".

John