Skip to main content

Notifications

Microsoft Dynamics GP (Archived)

Losing FRx is Upgrade to Dynamics GP 2013

Posted on by 3,815

We have been using FRx for over 6 years and works beautifully.  I've just discovered that FRx will not work with Dynamics GP 2013.  This is horrible news.  From what I've researched we have to use "Dynamics Management Reporter" whatever that is, yet I see it listed under our reg keys, but no license key for it. 

I checked the downloads page for this on Customersource, yet Dynamics GP 2013 is not listed as compatible.  So we use nothing???  I've also read of many features not available such as row linking, which maybe 50% of our hundreds of reports use. 

We paid over $14,000 for FRx and annually pay enhancments on it (around $2k).  Where did all that money go if it hasn't been changed in over 2 years??

*This post is locked for comments

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Losing FRx is Upgrade to Dynamics GP 2013

    Yes it will work, but it will not be supported, as long as it is using a 32bit ODBC to the SQL data. I was "told" that it really should be run on a 32bit server as well but I have not tested the differences.

    You also need to make sure it is not installed on your 2013 server, it has to on a different server for it to work correctly, but again this is NOT supported.

  • davidf. Profile Picture
    davidf. on at
    RE: Losing FRx is Upgrade to Dynamics GP 2013

    Chad,

    Could you please elaborate? I'm on GP2010 and have FRx installed on a 64-bit server & it's running fine. Are you saying it will still work after upgrading to GP2013? That would be good since trying to get MR working properly has been a complete failure for me.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Losing FRx is Upgrade to Dynamics GP 2013

    Also just an FYI.

    Although it is not "supported" FRX WILL integrate with GP 2013 and be fully functional.

    BUT it must be installed on a 32 bit sever and needs to use a 32bit ODBC.

  • Suggested answer
    cgust Profile Picture
    cgust on at
    Re: Losing FRx is Upgrade to Dynamics GP 2013

    I believe this was answered in another thread, but just to reiterate. Management Reporter is compatible with Dynamics GP 2013 and has been since Dynanics GP 2013 was released. . I believe the documentation has been updated.

  • Mattias Brunk Profile Picture
    Mattias Brunk 50 on at
    Re: Losing FRx is Upgrade to Dynamics GP 2013

    Hi mebenz.

    I just wanted to do a quick check if you are still active and still facing the same problem? My suggestion would be to look at BI360, an Excel-based reporting tool with LIVE integrations to Microsoft Dynamics AX/NAV/GP/SL. BI360 has functionalities such as automatic report distribution, self-service reporting, drill-throughs etc. It can also run on the same server without any problems, and it is just a quick client install and you are up and running within the hour.

    BI360 is a self-service reporting tool with 500+ customers that also can be used as a planning tool in your budget & forecast process.

    Please do not hesitate to contact me if you have any further questions or if you want a quick demo:

    Mattias Brunk
    mattias.brunk@solver.se
    +46 70 659 03 29
    www.solverusa.com

    Regards,
    Mattias Brunk
    BI360 Manager in EMEA

  • Mattias Brunk Profile Picture
    Mattias Brunk 50 on at
    Re: Losing FRx is Upgrade to Dynamics GP 2013

    Hi mebenzr.

    I just wanted to do a quick check if you are still active and still facing the same problem? My suggestion would be to look at BI360, an Excel-based reporting tool with LIVE integrations to Microsoft Dynamics AX/NAV/GP/SL. BI360 has functionalities such as automatic report distribution, self-service reporting, drill-throughs etc. It can also run on the same server without any problems, and it is just a quick client install and you are up and running within the hour.

    BI360 is a self-service reporting tool with 500+ customers that also can be used as a planning tool in your budget & forecast process.

    Please do not hesitate to contact me if you have any further questions or if you want a quick demo:

    Mattias Brunk

    mattias.brunk@solver.se

    +46 70 659 03 29

    www.solverusa.com

    Regards,

    Mattias Brunk

    BI360 Manager in EMEA

  • luvsql Profile Picture
    luvsql 60 on at
    Re: Losing FRx is Upgrade to Dynamics GP 2013

    We only have 1 client (a citrix server that all users log into) so I'm confused as to what these unique topologies are.  

    If it's not required that the MR services be installed on a dedicated server, where does Microsoft recommend it be installed?  What's the relationship between the MR Client, the MR service and the actual MR database and the Dynamics company databases (we have over 20)?

    If the MR database is NOT on the same sql server as the Dynamics' databases, then those clients have to purchase multiple licenses for SQL ($$$$).  How big does this MR database get?  Does it not just hold the building blocks of each report?  The data for the reports actually resides within each Dynamics company DB.

  • Suggested answer
    Jill Carter Profile Picture
    Jill Carter 1,846 on at
    Re: Losing FRx is Upgrade to Dynamics GP 2013

    It's not required that the Management Reporter services be installed on a dedicated server. Each of your clients will have a unique topology and can decide how they want to deploy Management Reporter.  In many cases we see customers that have the Management Reporter database alongside their ERP database on the same SQL Server.

    Jill

  • mebenz Profile Picture
    mebenz 3,815 on at
    Re: Losing FRx is Upgrade to Dynamics GP 2013

    For customers that have a SQL Server, Domain Controller plus terminal servers (citrix) as their clients, does it really need a separate server for the Management Reporter Services?  How much processing can they possibly use?  I'd like to avoid having to have yet another server configured for this.  

  • Kantilal Mistry Profile Picture
    Kantilal Mistry 295 on at
    Re: Losing FRx is Upgrade to Dynamics GP 2013

    Hi G1, I have to agree with you there, not having row link is big disadvantage.

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!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,188 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans