Skip to main content

Notifications

Microsoft Dynamics GP (Archived)

budget values not loading in MR

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

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: budget values not loading in MR

    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'

  • Renee Leung Profile Picture
    Renee Leung 6,775 on at
    RE: budget values not loading in MR

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

  • EDJJR Profile Picture
    EDJJR on at
    RE: budget values not loading in MR

    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
    Renee Leung 6,775 on at
    RE: budget values not loading in MR

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

  • Suggested answer
    sueconrod Profile Picture
    sueconrod 335 on at
    RE: budget values not loading in MR

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

  • Renee Leung Profile Picture
    Renee Leung 6,775 on at
    RE: budget values not loading in MR

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

  • Suggested answer
    sueconrod Profile Picture
    sueconrod 335 on at
    RE: budget values not loading in MR

    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.

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!

Community AMA December 12th

Join us as we continue to demystify the Dynamics 365 Contact Center

New! Quick response templatesâš¡

Save time with the new custom templates!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,056 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans