Skip to main content

Notifications

Announcements

Check out the New Agent Creator Community
News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Finance | Project Operations, Human Resources, ... / Management Reporter Is...
Finance | Project Operations, Human Resources, ...
Answered

Management Reporter Issue - Adjusting G/L Entries on Historical Year

(0) ShareShare
ReportReport
Posted on by RSM_RCarrillo 341

Hello everyone,

I have encountered an issue with Management Reporter.  A client of mine has closed 2021 Fiscal Year and everything seemed to be perfect on their financial statements in MR.  They recently had to do a post-close adjustment on 2021 (which GP manages just fine, as it is the most recent historical year).  However, when they generate de balance sheet for 12/31/2021, the accounts that were adjusted are not reflecting the correct balance, particularly when converting from the functional currency to USD.

Here's a couple of things I have done:

1) Checked balances on Summary Inquiries, Trial Balance Report on GP and the balances are correct.

2) I checked Multicurrency Exchange Table and it is fine. The country has a fixed exchange rate between Functional to USD that doesn't change throughout the years.

3) I have done Datamart rebuild.

4) I have run the Balance Sheet for the functional currency and the balances are how they are supposed to be.

So the issue seems to be Currency Translation on adjusting entries on a Historical year.  Is that a known issue (have other clients that do currency translation and have never reported an issue)?  Am I missing something?

GP version is 2018 R2.  Management Reporter version is 2.12.16003.25

Thanks in advance for any help you can provide.

Categories:
Microsoft Dynamics GP
  • Beat Bucher GP Geek GPUG All Star Profile Picture
    Beat Bucher GP Gee... 28,058 Moderator on at
    RE: Management Reporter Issue - Adjusting G/L Entries on Historical Year

    Thank you very much Ricardo for posting the solution.

    I'm sure that can possibly be helpful in the future if someone else stumbles on the same problem.

    Agree that MR should better handle this type of transactions, but it is what it is :-)

  • Verified answer
    RSM_RCarrillo Profile Picture
    RSM_RCarrillo 341 on at
    RE: Management Reporter Issue - Adjusting G/L Entries on Historical Year

    Hello Béat,

    Thank you for the suggestion! However, I was able to resolve it another way.  What I found was that the client had done some JE's that hit the Retained Earnings account and were made while the year was closed (Historical).  For some reason, all accounts that were part of those JE's had balance discrepancies in MR (only with Currency Translated statements).

    So we reversed year-end close for 2021, reconciled all open years, then reversed year-end close for 2020, reconciled again.  Finally proceeded to close the years (no adjustments) and for some reason, that seemed to completely fix the issue. My guess is that MR does not like adjustments to RE while the year is closed. As a best practice, I recommended the client to avoid that in future ocassions.

    Hope this helps someone that might be experiencing the same issue.

  • Beat Bucher GP Geek GPUG All Star Profile Picture
    Beat Bucher GP Gee... 28,058 Moderator on at
    RE: Management Reporter Issue - Adjusting G/L Entries on Historical Year

    HI Ricardo,

    It might be worth giving it a try, but you could install the MR Legacy Connector for GP and run the same report by selecting the Legacy company (-Curr) instead of the DM company.

    I've seen cases where the 2 connectors would not return the same results in MR due to the way the data is collected..

  • RSM_RCarrillo Profile Picture
    RSM_RCarrillo 341 on at
    RE: Management Reporter Issue - Adjusting G/L Entries on Historical Year

    Hi Greg Byer,

    Still need an answer on your proposed solution, as it did not work.  Any other possible bugs or issues with Currency Translation from historical balances?

    Thanks.

  • Ricardo Carrillo Profile Picture
    Ricardo Carrillo 10 on at
    RE: Management Reporter Issue - Adjusting G/L Entries on Historical Year

    Hi Greg,

    Still need advice on this.  The script did not return any results and I don't understand why MR is not translating correctly when balances are correct in GP and when run on the functional currency.

    Thanks.

  • RSM_RCarrillo Profile Picture
    RSM_RCarrillo 341 on at
    RE: Management Reporter Issue - Adjusting G/L Entries on Historical Year

    Hi Greg,

    First of all, thank you for your reply.  I ran the script and got no results.  Does this mean that my issue is not related to this issue?

    If not, I read somewhere that there were issues related to affecting the Retained Earnings account directly (in a J/E).  In my client's case, they indeed did adjustments that affected the RE account.  However, that issue should have been resolved in recent MR updates.  I upgraded to the latest version last night and no changes to the results...

  • Greg Byer Profile Picture
    Greg Byer 2,586 on at
    RE: Management Reporter Issue - Adjusting G/L Entries on Historical Year

    There is an issue with adjusting entries made to historical years.  The SEQNUMBR field should increment by 10000000 and if it doesn't MR won't read it correctly.  You can run this script to check for this data condition:

    select * from GL20000 inner join GL30000 on GL20000.JRNENTRY = GL30000.JRNENTRY where GL20000.SEQNUMBR = GL30000.SEQNUMBR and GL20000.TRXSORCE like 'GLTHS%'

    The recommended fix is to re-open and re-close the year.  

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

News and Announcements

Check out the New Agent Creator Community

Quick Links

Jainam Kothari – Community Spotlight

We are honored to recognize Jainam Kothari as our June 2025 Community…

Congratulations to the May Top 10 Community Leaders!

These are the community rock stars!

Announcing the Engage with the Community forum!

This forum is your space to connect, share, and grow!

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

#1
Martin Dráb Profile Picture

Martin Dráb 601 Most Valuable Professional

#2
Abhilash Warrier Profile Picture

Abhilash Warrier 416

#3
Adis Profile Picture

Adis 384 Super User 2025 Season 1

Last month Overall leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans