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

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Microsoft Dynamics GP (Archived)

"Migrating" from MR Legacy Provider to Datamart

(1) ShareShare
ReportReport
Posted on by 1

I'm asking & answering my own question, so hopefully I can help someone else who needs this info!

When switching a client from the Legacy Provider to the Datamart, you then need to update all the company references in both the Trees and the Report Definitions.

When you have a large set of databases, and different Building Block Groups for each, this can be quite tedious to do within the UI.

I have here a set of scripts (from Microsoft support) that allow you to perform the update from SQL.  Please note, use these scripts at your own risk, and please be sure to make a backup before you begin!

Run all scripts against the ManagementReporter database.

*Please make a backup of the Management Reporter Database

  --Selects list of Companies

select ID, Code, Name from ControlCompany

--Select a list of Reports and Tree’s that will be affected

select * from ControlReport where CompanyID=(SELECT [ID] FROM ControlCompany WHERE [Code] = 'TWO')

select * from ControlTreeDetail where CompanyID=(SELECT [ID] FROM ControlCompany WHERE [Code] = 'TWO')

  --Update Reports currently set at 'TWO-Curr' to 'TWO' 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-Curr' to 'TWO' company

Update ControlTreeDetail set CompanyID= (SELECT [ID] FROM ControlCompany WHERE [Code] = 'TWO-Curr') where CompanyID= (SELECT [ID] FROM ControlCompany WHERE [Code] = 'TWO')

*This post is locked for comments

I have the same question (0)
  • Verified answer
    Lyn Barr Profile Picture
    1 on at

    These scripts solved my problem.

  • Suggested answer
    Mark101 Profile Picture
    139 on at

    Lyn,

    This is great. FYI for CU13 and higher, you need to add "Reporting." in front of your table names. I have used this in multiple conversions. Both directions.

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Congratulations to our 2025 Community Spotlights

Thanks to all of our 2025 Community Spotlight stars!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans