I recently did a Microsoft Dynamics GP and Management reporter upgrade for a client which incuded migrating the databases to a new server. After performing the upgrade, users were unable, in some companies, to see the reports in Management Reporter. When we looked into it, some of the companies had reverted to the Default building block group.
To easily identify the companies which had reverted, I created the below script which coud be rn on both the original and upgraded Management reporter databases; it lists all the companies and the assigned building block group:
/*
Created by Ian Grieve of azurecurve | Ramblings of an IT Professional (http://www.azurecurve.co.uk)
This code is licensed under the Creative Commons Attribution-NonCommercial-ShareAlike 4.0 International (CC BY-NC-SA 4.0 Int).
*/
SELECT
['Case Control'].Code AS 'Company ID'
,['Case Control'].Name AS 'Company Name'
,['Control Specification Set'].Name AS 'Building Block ID'
,['Control Specification Set'].Description AS 'Building Block Name'
FROM
Reporting.ControlCompany AS ['Case Control']
INNER JOIN
Reporting.ControlSpecificationSet AS ['Control Specification Set']
ON
['Control Specification Set'].ID = ['Case Control'].SpecificationSetID
ORDER BY
['Case Control'].Code
What should we write about next?
If there is a topic which fits the typical ones of this site, which you would like to see me write about, please use the form, below, to submit your idea.
Looking for support or consultancy with Microsoft Dynamics GP?
I no longer work with Microsoft Dynamics GP, but the last company I worked for was ISC Software in the UK; if you’re looking for support or consultancy services with Microsoft Dynamics GP you can contact them here.