Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / Legacy installation of...
Microsoft Dynamics GP (Archived)

Legacy installation of Management Reporter with duplicate companies causes issues

(0) ShareShare
ReportReport
Posted on by Sheilajr 745

Somewhere during an upgrade we have ended up with duplicate companies in Management Reporter CU10 legacy implementation.  The company started with an old version of MR which did not have the -Curr appended to the database name.  I figure this is why they might still exist as I know that future versions of MR that also install a data mart will use the company ID without the -curr.  We only have one MR database called MR2012.  We do not have a data mart implemented at this site.

The first company has no issues when attempting to drill down into Dynamics but when I try a report with the other two companies (CVP-Curr or PVL-Curr) these will fail.  We are trying to keep the -Curr companies and remove the duplicates.

Is there a way to fix the database so that all of our reports is only looking at one company database so that we can remove the duplicate databases?  How do we resolve this issue?

Thank you for your help.

*This post is locked for comments

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Legacy installation of Management Reporter with duplicate companies causes issues

    It sounds like it should be working. Others may have additional suggestions otherwise I would recommend logging a support case so we can take a close look at what is happening.

  • Sheilajr Profile Picture
    Sheilajr 745 on at
    RE: Legacy installation of Management Reporter with duplicate companies causes issues

    Hello Jake,

    We did log into the same GP company before generating the report for the same company.  This user is the Controller and has rights to open the inquiry screens in all companies in Dynamics.  And she was able to drill back to one of the three companies so this is not making sense.  This is why I was thinking that it had to do with the duplicate companies causing confusion.  Any other ideas would be appreciated.

    Thanks for your suggestions Redhead - I think we have already tried what was listed in that article.

    Sheila  

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Legacy installation of Management Reporter with duplicate companies causes issues

    You need to be logged into the same company in both GP and MR in order for the drill back to work. Also, if you switch companies in GP, that could be the issue. Try closing GP and then logging directly into the company as per this article:

    mbs.microsoft.com/.../KBDisplay.aspx;en-us;2692525

    I believe the above issue was fixed with GP2010 SP3. Having that version of GP just allows you to switch companies in GP. You still need to be logged into the same company in both GP and MR.

    We also see this error when GP and MR aren't on the same machine, for example if one was running as a published app. However, if you can drill back into one of the companies, I think we can rule that out.

  • Suggested answer
    Redbeard Profile Picture
    Redbeard 12,931 on at
    RE: Legacy installation of Management Reporter with duplicate companies causes issues

    Perhaps you don't have the appropriate access.  Here's an old post. The user need local access rights on the local machine.

    community.dynamics.com/.../155230.aspx

  • Sheilajr Profile Picture
    Sheilajr 745 on at
    RE: Legacy installation of Management Reporter with duplicate companies causes issues

    Thank you so much Jack for this solution.  I was able to locate about 7 report definitions that had the incorrect company ID and once they were fixed I was able to remove the duplicate companies.

    I still have the problem though in drilling back into Dynamics from the Report Viewer.

    1. We login to Dynamics to the company that we are running the report for
    2. Generate the report to the Report Viewer
    3. Highlight the amount we wish to drill back to from the Account level report.
    4. The Dynamics Drill icon is active, after clicking on the drill icon there is a delay and then I'm getting the error message that it can't connect to my company.

    I thought that getting rid of the duplicate companies would resolve this issue but it has not.  There are three companies and only one will let us drill back the other 2 do not.

    I hope you have some other ideas for me.

  • Verified answer
    Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Legacy installation of Management Reporter with duplicate companies causes issues

    First back up the ManagementReporter SQL database and then modify and use the following scripts to quickly change all Report and Tree formats to use the correct company names. This should allow you to remove the duplicate companies from the MR Configuration Console.

      --Update Reports currently set at 'TWO' to 'TWO-Curr' company

    Update ControlReport set CompanyID=

    (SELECT [ID] FROM ControlCompany WHERE [Code] = 'TWO-Curr')

    where CompanyID=

    (SELECT [ID] FROM ControlCompany WHERE [Code] = 'TWO')

      --Update Trees currently set at 'TWO' to 'TWO-Curr' company

    Update ControlTreeDetail set CompanyID=

    (SELECT [ID] FROM ControlCompany WHERE [Code] = 'TWO-Curr')

    where CompanyID=

    (SELECT [ID] FROM ControlCompany WHERE [Code] = 'TWO')

  • Suggested answer
    Redbeard Profile Picture
    Redbeard 12,931 on at
    RE: Legacy installation of Management Reporter with duplicate companies causes issues

    I would recommend against using SQL to removing conflicting data from the Management Reporter database, without engaging Microsoft Technical Support to ensure you get it right the first time.  I would also strongly suggest creating a TDBX file by exporting all your Building Blocks, as well.

    I ran through the process of Exporting to a TDBX, then dumping everything and recreating it, which would work, but seems a bit extreme for your particular situation.

  • Sheilajr Profile Picture
    Sheilajr 745 on at
    RE: Legacy installation of Management Reporter with duplicate companies causes issues

    Yes, that is where I attempted to delete the company but it does not allow it.  Says that I have report definitions or reporting trees using this company but we don't.  I'm not sure at this point how to fix that.

  • Redbeard Profile Picture
    Redbeard 12,931 on at
    RE: Legacy installation of Management Reporter with duplicate companies causes issues

    I don't believe you need to use SQL to delete a company.  You should be able to use the Management Console to remove companies you don't want to use.  

  • Sheilajr Profile Picture
    Sheilajr 745 on at
    RE: Legacy installation of Management Reporter with duplicate companies causes issues

    Thanks for looking for a solution but I don't think that anything that I read in those posts clarified the issue that I am having.  I cannot drill back to these companies that have duplicates.  I understand that initially when they used the -Curr it was to indicate that multicurrency was to be used and this is not the case with this company.  When upgrading their system it automatically created those company ID's without asking if I am to use MC.  They are now on CU10 and I believe that any company you create for the legacy system it automatically names it with the -Curr (not in first versions) and if the DM is used it just uses the company ID.  

    At this point we are trying to remove all references to the duplicate ID but it still says that there is report definition or tree using that ID.  We can't see it so I'm wondering if there is a SQL script that I can run that would locate those ID's.

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