Open Forum

Like what you see? Discover the benefits of the GPUG Community. Learn More

Management Reporter is only providing sporadic data for current month...not sure why?!?!

  • 1.  Management Reporter is only providing sporadic data for current month...not sure why?!?!

    Posted 5 days ago
    We are in the process of running our November Month-end reports and for some reason certain accounts are pulling balances in and other accounts are not. The data in all the prior months appear to be pulling in correctly, so not sure why November is not pulling in for all accounts. We did confirm the entries were indeed posted in GP, so it is not a posted vs. not posted issue. Any thoughts on this?​

    ------------------------------
    Brenda Schultz
    Forefront Dermatology
    Manitowoc WI
    ------------------------------


  • 2.  RE: Management Reporter is only providing sporadic data for current month...not sure why?!?!

    TOP CONTRIBUTOR
    Posted 5 days ago
    Edited by Jo deRuiter 5 days ago
    Hi @Brenda Schultz

    The symptoms you describe lead me to believe you just need to rebuild the Data Mart for GP - it's a common issue.

    Here is an article by Logan Consulting that is pretty thorough in why it happens and how to rebuild the DM - it usually takes just a few moments to do, but if you are not comfortable doing it, please reach out to your IT people or your GP Partner to assist you.

    Management Reporter - Rebuilding the Data Mart - Logan Consulting
    Logan Consulting remove preview
    Management Reporter - Rebuilding the Data Mart - Logan Consulting
    The Data Mart is a way for Management Reporter to access the data required to create the financial reports for Microsoft Dynamics GP. Most people may not know too much about the data mart itself, but most people have had to get their data mart recreated.
    View this on Logan Consulting >


    ------------------------------
    Kindest Regards,
    Jo deRuiter , MCP, DCP
    "That GP Red Head"
    AISLING DYNAMICS CONSULTING, LLC
    WEBSITE: https://aislingdynamics.com/
    BLOG: https://community.dynamics.com/gp/b/gplife
    GPUG Academy Instructor
    Dynamics GP Credentialing Council-Vice Chair
    770-906-4504 (Cell)

    ------------------------------



  • 3.  RE: Management Reporter is only providing sporadic data for current month...not sure why?!?!

    TOP CONTRIBUTOR
    Posted 4 days ago
    ​...and here is some additional information from Microsoft on rebuilding data mart:
    Resetting the Management Reporter data mart
    Dynamics Financial Reporting remove preview
    Resetting the Management Reporter data mart
    There have been a few questions around troubleshooting the data mart and how to rebuild or reset the data mart when required. In this post, We'd like to clarify when resetting the data mart is required, and hopefully clear up some misunderstandings around the process. We've been hearing, pretty consistently, that customers are rebuilding the...
    View this on Dynamics Financial Reporting >


    ------------------------------
    Derek Krebs
    Sr Consultant
    MSX Group
    derek.krebs@msxgroup.com
    ------------------------------



  • 4.  RE: Management Reporter is only providing sporadic data for current month...not sure why?!?!

    Posted yesterday
    We had a similar issue last month when our budget numbers for a specific period would not show on our financial reports. Reloading the data mart fixed our issue.  One word of caution since the original instructions provided to me was missing one important step. The instructions I had did not include the step to stop and start the services which I see is included in the resolution provided by Jo deRuiter.  5. Stop the MR services at the top level of the Configuration Console.My support vendor made the assumption that I would have done this. If you don't complete this step you may have another issue (error window pops up) when you drill down to the transaction level on your reports. I'm a newby with Dynamics GP and this was a very simple process to follow.

    ------------------------------
    George Sheppard
    IT Manager
    Newfoundland and Labrador Liquor Corporation
    St. John's
    ------------------------------