web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Microsoft Dynamics GP (Archived)

budget values not loading in MR

(0) ShareShare
ReportReport
Posted on by 6,775

The budget values for some departments are no loading in MR. The column definition is mapped to the correct budget id.

*This post is locked for comments

I have the same question (0)
  • Suggested answer
    sueconrod Profile Picture
    337 on at

    Did you run checklinks for Financial>>Budget Master in Great Plains after you loaded all the budgets?  I've run into this issue in the past and although it looked like all the Budget information had loaded, it was not all showing in MR.  Ran the checklinks and it resolved the issue.

  • Renee Leung Profile Picture
    6,775 on at

    No unfortunately that did not work, running Check Links found no errors.

  • Suggested answer
    sueconrod Profile Picture
    337 on at

    Normally doesn't find errors, but then the accounts are available in MR.  

  • Renee Leung Profile Picture
    6,775 on at

    Not sure I follow. The accounts were already chosen / available in the row definition, so not sure how this affects anything?

  • EDJJR Profile Picture
    Microsoft Employee on at

    Hello,

    I wanted to follow-up with you to see if you were still having an issue with Budgets not displaying in MR.

    Thanks,

    Erik

    Microsoft

  • Renee Leung Profile Picture
    6,775 on at

    No the issue still persists. I have opened a MS ticket but no reply yet...

  • Community Member Profile Picture
    on at

    Hello,

    I've seen this issue a number of times when the YEAR1 column is not filled in for the GL00201 table.  In order for MR to pull the data that column needs to be filled in with an update statement. 

    update gl00201 set YEAR1 = 'XXXX' where budgeted = 'xxxx'

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Congratulations to our 2025 Community Spotlights

Thanks to all of our 2025 Community Spotlight stars!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans