Skip to main content

Notifications

Community site session details

Community site session details

Session Id :
Microsoft Dynamics GP (Archived)

Management Reporter- Missing Data issue with GP2016

(0) ShareShare
ReportReport
Posted on by 334

Hello,

We recently migrated from FRx to MR CU16 and upgraded to GP2016.  We started testing reports and found missing data for prior years.  I can run a more recent year with correct data with the same report.  When I run a consolidated for a prior year, an entire companies data does not appear and other companies are missing data.  The DM Integration only takes 5 minutes or so.  We have 10 companies with history going back to 2004.  It seems like it would take longer to pull in that history.

I have reset the DM multiple times with the same results when running prior reports.

Is there a way to restrict the years to pull?  For an SL Integration, I updated the MRServiceHostSettings.config file to include the following:

<add key="IntegrationFiscalYearStart" value="2013" />

When I make this change, I can't launch the configuration console, it errors

How can I troubleshoot the missing data?

Thanks!

*This post is locked for comments

  • Verified answer
    NorK Profile Picture
    334 on at
    RE: Management Reporter- Missing Data issue with GP2016

    The GL30000 table is empty for the company.  Opening a new post to troubleshoot.

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

Jainam Kothari – Community Spotlight

We are honored to recognize Jainam Kothari as our June 2025 Community…

Congratulations to the May Top 10 Community Leaders!

These are the community rock stars!

Announcing the Engage with the Community forum!

This forum is your space to connect, share, and grow!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

#1
Almas Mahfooz Profile Picture

Almas Mahfooz 3 User Group Leader

Featured topics

Product updates

Dynamics 365 release plans