Skip to main content
Post a question

Notifications

Announcements

No record found.

Microsoft Dynamics GP (Archived)

Management Reporter not showing Full Years Budget Columns

Posted on 24 Sep 2019 18:09:18 by 5

I am trying to get Management Reporter 2012 to show a full years budget in my periodic monthly actual report. All data is flowing in correctly but the Full Years budget doesn't pull in anything. I have looked at other posts and think my parameters are correct (see below). And I have tried various other parameters to see if those worked. 

Anyone have any idea why this column would be blank/not show up at all? Its the last column on the right. 

pastedimage1569348322461v1.png

*This post is locked for comments

  • Suggested answer
    Jennelle Profile Picture
    Jennelle 5 on 26 Sep 2019 at 13:49:57
    RE: Management Reporter not showing Full Years Budget Columns

    The print controls fixed my issue and the full years budget is now showing! Thank you so much for your help! 

  • Verified answer
    Greg Byer Profile Picture
    Greg Byer 2,586 on 26 Sep 2019 at 12:52:06
    RE: Management Reporter not showing Full Years Budget Columns

    Hi Jennelle,

    The format of the column looks good.  If you remove the print control, do you get data then?  

    You could also check the budget table in the company database.  In the GL00200 and GL00201 tables, the YEAR1 column needs to be populated.  If it is blank, MR won't read the budget correctly.  You could run these two statements:

    select * from GL00200 where YEAR1 = ''

    select * from GL00201 where YEAR1 = ''

    If you get results for them, you'd need to update the YEAR1 to reflect the correct year for the budget.  

  • Jennelle Profile Picture
    Jennelle 5 on 25 Sep 2019 at 18:20:35
    RE: Management Reporter not showing Full Years Budget Columns

    I am using Dynamics GP 2010

  • EDJJR Profile Picture
    EDJJR on 25 Sep 2019 at 18:16:15
    RE: Management Reporter not showing Full Years Budget Columns

    Hello Jennelle, 

    Are you using Management Reporter with Dynamics AX2012 or Dynamics GP?

    Thank you, 

    Erik Johnson

    Microsoft

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,280 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,235 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans