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

Notifications

Announcements

No record found.

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

#1
mtabor Profile Picture

mtabor 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans