Fixing Reports Not Implemented Error After Upgrade

March 14th, 2017 by

Microsoft Dynamics GPWe’ve been doing a number of upgrades recently and I encountered an old error when trying to deploy the SQL Server Reporting Services (SSRS) and Excel Reports through the Reporting Tools Setup window (Administration >> Setup >> System >> Reporting Tools).

This particular client is being upgraded from Microsoft Dynamics GP 2013 SP2 to 2016 R2.

The problem is that some of the companies are showing as Not implemented. The companies showing this way are the oldest; TEST2016… is actually the main company renamed for testing.

Reporting Tools Setupcaption

The following script will remove the entries from the Deployed Reports (syDeployedReports) table which is causing the problem.

Change the highlighted sections to change the system database (if using a named system database) and add in the INTERIDs which are showing as Not implemented:

/*
Created by Ian Grieve of azurecurve|Ramblings of a Dynamics GP Consultant (http://www.azurecurve.co.uk)
This code is licensed under the Creative Commons Attribution-NonCommercial-ShareAlike 2.0 UK: England & Wales (CC BY-NC-SA 2.0 UK).
*/
USE DYNAMICS
GO
DELETE
	DYNAMICS..syDeployedReports
WHERE
	CompanyID IN ('{INTERID}' ,'{INTERID}')

As always when running scripts, make sure there is a good backup of the database begin affected (in this case your system database).

Read original post Fixing Reports Not Implemented Error After Upgrade at azurecurve|Ramblings of a Dynamics GP Consultant

Source: azurecurve

Leave a Reply