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

Announcements

News and Announcements icon
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

I have the same question (0)
  • Verified answer
    NorK Profile Picture
    334 on at

    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

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Women in Power Builds Momentum

Expanding mentorship, skilling, and AI innovation

Congratulations to the June Top 10 Community Leaders

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans