Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / Management Reporter - ...
Microsoft Dynamics GP (Archived)

Management Reporter - Bad data and wrong base year?

(1) ShareShare
ReportReport
Posted on by Bron 2

Greetings -

I just recently installed Management Reporter (RU5) working with GP2013 (SP1). We migrated two simple reports from FRx - a balance sheet and a P&L.

Using the management reports for first time and the data is absolutely squirrelly.

Example - GL says inventory should be 1,500,000 and the report says 34,000 - wild numbers.

I even created a brand new balance sheet (no reporting tree) with just a simple couple rows (brand new definitions)  - single column (brand new definitions) - all brand new and the data is still off.

Also - the screen shot shows that MR thinks my base year is 2014 - which is really strange since 2014 is not even setup yet.........and the report date is always 12 months before the selected period and year. Playing with default base period doesn't make a difference no matter what I select the report date is always 12 months before the selected period and year.......

Couple of questions -

1. FRx - pulled data at time of report from GL - does MR work same way or does the mgmt. reporter database actually store GL data? I suspect it pulls data but I want to confirm.........

2. I heard FRx doesn't work with GP2013 - but my install seems to be working just fine. I ran a balance sheet and looks correct - I checked two accounts and they were both correct.......any thoughts on using FRx with GP2013?

3. Why is the base year wrong in MR?

*This post is locked for comments

  • Suggested answer
    Redbeard Profile Picture
    Redbeard 12,931 on at
    RE: Management Reporter - Bad data and wrong base year?

    MR 2012 CU7 turned out to be a problem.  If you are experiencing any similar issues, and you are using CU7, upgrade to a recent release.

  • Redbeard Profile Picture
    Redbeard 12,931 on at
    RE: Management Reporter - Bad data and wrong base year?

    I ran into the same problem with MR 2012 CU7 connected to GP2010 SP4.  Inaccurate data in the wrong year in MR reports.   I tried a number of fixes based on some of the information contained in this post.  I recalculated all of the fiscal periods and ran Check-Links on the financial series (after backing up my data of course).  Interestingly enough, new numbers appeared in formerly blank cells; however, these new numbers were not entirely accurate - so while the fix changed the data, it did not make it accurate.  So, in some small part the symptoms were addressed by the recommendations above.  I went the extra mile and dumped the integration from MR to GP and recreated it, to no avail.  I am logging a technical support incident with Microsoft for this issue, and will post when/if I get a solution.  The only tool I have not run is Financial Reconcile.

  • Lisa Payment Profile Picture
    Lisa Payment 65 on at
    RE: Management Reporter - Bad data and wrong base year?

    Vote to have the DDM fiscalcalendarview match GP.  connect.microsoft.com/.../mr-datamart-use-same-periods-as-gp-on-a-4-4-5-fiscal-calendar

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Management Reporter - Bad data and wrong base year?

    had a breakthrough right after I made this post. it seems that when you change the fiscal calendar, it doesn't trickle down to existing budgets. if you look at the card, they appear correct, but the underlying data still has the "transaction" in the old beginning date. So if you have a budget in a calendar year, with data in Jan and Feb. If you change the Jan period to end on 2/1, MR will read that as 2 months in January, and nothing in Feb. we had to rebuild our future dated budget to fix. anybody know if there was a reconcile/check links routine that I should have run to correct this?

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Management Reporter - Bad data and wrong base year?

    We're having a similar issue, but with Budgets. We changed out FY14 calendar, and now MR is treating budget data (which I assumed was simply associated with the period) as a transaction on the first of the month. So us changing the end of Jan to 2/2 causes 2 months of budget to show in January. the budget in GP seems to reflect the correct begin dates for the periods, and the FiscalCalendarView in the DDM looks accurate as well. I'm baffled!

  • Kiwi Profile Picture
    Kiwi 110 on at
    RE: Management Reporter - Bad data and wrong base year?

    How did you fix the sequencing in the FiscalView table?

    I tried an update on the FiscalYear field but it wont let me.   My GP data in Sy40100 and 401010 is fine.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Management Reporter - Bad data and wrong base year?

    Yes, If you installed the Legacy, it is looking at the Fiscal periods and GL the same as FRX.  If you installed the Data Manager, it calculates its own base period .  Therein lies the issue.  In my case I needed to fix my periods in the Fiscal period file and correct the fact that my client had skipped two years (94 and 95) when they did the close for '96.  I closed the years (no effect on GP), corrected my period sequencing in the fiscal file, rebuilt the data mart and all was good.  Let me know if you need some further assistance. Be happy to help.

  • sbasye Profile Picture
    sbasye 191 on at
    RE: Management Reporter - Bad data and wrong base year?

    I not have an answer rather the same issue.  I also have additional information.  My FiscalCalendarView in my MR DDM doesn't match my FiscalYear table in my MR DDM database.  Every thing in off by one year in my FiscalCalendarView but not in GP or in the MR FiscalYear table.  Does anyone know what MR looks at?  

  • TTM NP Profile Picture
    TTM NP 280 on at
    RE: Management Reporter - Bad data and wrong base year?

    I experienced this same problem with RU5.  You will need to go into GP and recalculate all of your financial periods.  Once complete go into Management Reporter under Tools and Refresh Cached Financial Data.  We just rolled up to RU6 and recalculating the periods is not working (we are still having period information showing up incorrectly).  I would not suggest rolling up to RU6 if you don't have to.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Management Reporter - Bad data and wrong base year?

    I meant to say "not in sequence with" and (fy 1994). Sorry

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

Congratulations 2024 Spotlight Honorees!

Kudos to all of our 2024 community stars! 🎉

Meet the Top 10 leaders for December!

Congratulations to our December super stars! 🥳

Get Started Blogging in the Community

Hosted or syndicated blogging is available! ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,354 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans