Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics GP (Archived)

management reporter missing data in rows

Posted on by 1,455

I was assisting a customer that has budgets in GP for all their locations.  I confirmed that I could see them in GP and that the budget vs actual inquiry showed information in both columns -actual and budget for a variety of accounts.

We setup the columns in MR for actual budget (and picked the correct budget) and ran the report.  For some reason, it ignores certain budget accounts on certain locations.  In one location the revenue budget amount does not come in, but the expense budgets do. Yet in another location everything is fine.  This is all ine one database, not using trees, so not very complex.  No matter what we tried, it does not display revenue budgets for vertain locations even though they do show fine in GP.

First we thought it was just an on-screen display problem, but when we export to Excel, the data is still missing.  This company is tryng to close and they cannot get a complete report.

By the way, I did go to Tool > Update Financial Cache and it ran through very quickly, but did not change anything.  I am at a loss.

 

 

 

*This post is locked for comments

  • Suggested answer
    RE: management reporter missing data in rows

    Hi,

    Please try the following.

    Run the checklink against budget in GP

    Remove any kind of restrictions or filter on MR

    Rerun MR and check it

  • RE: management reporter missing data in rows

    Having a similar issue (actuals not budgets are not pulling in)- can anyone share how you were able to resolve this?

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: management reporter missing data in rows

    Did you ever receive an answer on this? I am having the same issue and I have no idea what is wrong. Please let me know.

    Thanks!

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    Re: management reporter missing data in rows

    For future reference, what's the reason ?

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    Re: management reporter missing data in rows

    Hi Raoul,

    Please post your question as its own thread.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    Re: management reporter missing data in rows

    I have a similar issue.  My report is not pulling data from my OPEX accounts in GP 2010R.  MR version No is :2.0.1700.31

    Thx

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    Re: management reporter missing data in rows

    Hi Deborah,

    I have a few questions before I dig into this.

    1. What is the full version of MR that you are using?

    2. I see this was posted in the GP forums. Is the MR company you are logged into set to pull from AA?

    Thanks!

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,214 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans