Skip to main content

Notifications

Announcements

No record found.

Finance | Project Operations, Human Resources, ...
Unanswered

Management Reporter Companies Refresh doesn´t work

(1) ShareShare
ReportReport
Posted on by

Hi team,

   I just installed MR 2.12.16013.0 for GP2018 R5, but when I try to refresh companies dont do anything, I can´t add the companies to MR. Is this a bug?

Recently we migrate GP2015 R2 to GP2018 R5.

Regards

Julia Gallegos

Categories:
  • Greg Byer Profile Picture
    Greg Byer 2,586 on at
    RE: Management Reporter Companies Refresh doesn´t work

    In the MR Configuration Console, click the integration and then on the right side, click Reconfigure change tracking.

    pastedimage1678195735160v1.png

    You'll be prompted for credentials.  Enter the sa user and password, and then click OK.  You won't get a message saying it was completed or successful.  You'll only get a message if the credentials are wrong.  

    After that, monitor the data mart integration logs for any errors.

  • Richard Wheeler Profile Picture
    Richard Wheeler 75,730 on at
    RE: Management Reporter Companies Refresh doesn´t work

    In MR YOU need to enable change tracking on all databases including DYNAMICS. if this is not in MR then use SSMS and the properties of the DYNAMICS database.

  • RE: Management Reporter Companies Refresh doesn´t work

    Thanks Richard...

    But now in the configuration company appear a message:

    [SQL Server]Change tracking must be enabled on database before it can be enabled on table 'MC00200'

    Is required for MR2012 CU16?

    If I enable the change tracking in  the DB, in the MR show some message like this, in differents tables:

    Change tracking is not enabled for the DYNAMICS database. To enable the raeding of data, enable change tracking in the Configuration Console.

    Regards

    Julia

  • Richard Wheeler Profile Picture
    Richard Wheeler 75,730 on at
    RE: Management Reporter Companies Refresh doesn´t work

    The box needs to be checked.

  • RE: Management Reporter Companies Refresh doesn´t work

    The box in GP is uncheked.

    MR does not show any company.

    Regards

    Julia

  • Richard Wheeler Profile Picture
    Richard Wheeler 75,730 on at
    RE: Management Reporter Companies Refresh doesn´t work

    In each company. go to Tools->Setup->Company-->Company->Options and make sure 'Link to General Ledger' is checked. If it is, unclick the box, save and then check it back.

    Do any of the companies appear in MR?

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

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Product updates

Dynamics 365 release plans