Skip to main content

Notifications

Microsoft Dynamics GP (Archived)

Can't View Current Fiscal Year in MR

Posted on by 14,849

Dear 

We installed MR in 2014 with Dynamics GP, now our 2014 fiscal year is still open (we didn't close it yet) and we can't view 2015 Base Year when generating reports. all i can choose is 2014 in the Base Year

is there some sort of refresh i should be running to view all fiscal years ? 

Regards

*This post is locked for comments

  • Mahmoud Saadi Profile Picture
    Mahmoud Saadi 32,738 on at
    RE: Can't View Current Fiscal Year in MR

    You are most welcome,

    Never hesitate to share any further inquiries,

  • Abdo Khoury Profile Picture
    Abdo Khoury 14,849 on at
    RE: Can't View Current Fiscal Year in MR

    Disregard this , it seems i have a difference between the GL and the Module that is why there is a difference here

  • Abdo Khoury Profile Picture
    Abdo Khoury 14,849 on at
    RE: Can't View Current Fiscal Year in MR

    Mahmoud

    There are small differences between GP and MR, sometime the difference 20$ and in order cases $40,

    do you think the CU12 will fix this , or is this not related issue  

  • Abdo Khoury Profile Picture
    Abdo Khoury 14,849 on at
    RE: Can't View Current Fiscal Year in MR

    Mahmoud ,

    I followed your above instruction and reconfigured MR and it worked like a charm, thank you very much , Very much appreciated

  • Bill Campbell Profile Picture
    Bill Campbell 22,647 on at
    RE: Can't View Current Fiscal Year in MR

    Is this not the same kind of issue that we encounter with GP Reporting when a New Year is open and the year is not done to close the prior year.  Is it due to how the data is populated in the GL tables that also can cause MR / FRx and GP Reporting to not report correctly?

    Just wondering if this is even related.

  • Verified answer
    Mahmoud Saadi Profile Picture
    Mahmoud Saadi 32,738 on at
    RE: Can't View Current Fiscal Year in MR

    Here is the link for Management Reporter CU 12

  • Abdo Khoury Profile Picture
    Abdo Khoury 14,849 on at
    RE: Can't View Current Fiscal Year in MR

    Sorry to bother you , I have been searching since yesterday to find a link to download CU12 (2.1.12000.26) but I couldn't find anything.

    can you kindly provide the link, thank you very much

  • Mahmoud Saadi Profile Picture
    Mahmoud Saadi 32,738 on at
    RE: Can't View Current Fiscal Year in MR

    Well, you may consider CU12 (2.1.12000.26). It is the most recent release.

  • Abdo Khoury Profile Picture
    Abdo Khoury 14,849 on at
    RE: Can't View Current Fiscal Year in MR

    Thanks Mahmoud

    do you recommend that i install ManagementReporter2012-CU11-en-us ? i just downloaded it

    I will keep you posted 

    Thank you

  • Verified answer
    Mahmoud Saadi Profile Picture
    Mahmoud Saadi 32,738 on at
    RE: Can't View Current Fiscal Year in MR

    Hello again,

    Your screen shot shows two types of integration, data mart and legacy. You may remove both of them and start with a new integration as per the steps I mentioned above.

    Remember to delete the ManagementReporterDM database. In SQL Management Studio, you will find two databases which are:

    1- ManagementReporter

    2- ManagementReporterDM

    Don't delete ManagementReporter. You should delete the DM one which is built for the data mart.

    Let us know how this goes,

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!

Community AMA December 12th

Join us as we continue to demystify the Dynamics 365 Contact Center

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,240 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,149 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans