Can’t Delete Company In Management Reporter

We recently took on a new client who already had Microsoft Dynamics GP and had been migrated to Management Reporter before we took them on for support.

I did a little exercise of checking configuration and tidied up where needed. One item I found was two companies in Management Reporter which were not needed; these were the FW and FWC companies.

When I selected the first of them and hit delete, I received the following message:

Management Reporter 2012 – This company is referenced by an existing report definition or reporting tree definition. Remove these associations before deleting the company.

I’ve experienced a number of errors in Management Reporter where the one reported on via the application does not match the one behind the scenes so I fired up the Windows Event Viewer to take a look for the error:

In this case, the error on screen was fairly accurate but the Windows Event Viewer narrowed the error down to the ControlTreeDetail table which meant I only needed to check through the trees to see where it was used. But I found it wasn’t used anywhere.

Trying to save a little time, I opted to do an online search to see if anyone else had seen a similar issue before. I found a post by fellow GP blogger Janakiram MP where he had a similar issue.

Using Janakiram’s post, I explored the Management Reporter SQL database before narrowing the issue down to the Specification Sets:

Obvious in hindsight, that if there was no report or tree in the company I was looking at (the live GP company, that there must be one in another company using a different specification set.

I opened the Building Block Groups window (Company | Building Blocks) to confirm:

I tried to delete the FRxDemo building block group and found I couldn’t as it was in use. A quick realisation that the FW and FWC companies were using the building block group so I can’t just delete it. Instead I had to go to the Companies window and modify FW and FWC to change the Building block group to Default by clicking the Modify button:

Once done, I returned to the Building Block Groups, selected the FRxDemo specification set and hit Delete.

I was then able to return to the Company window and delete both the FW and FWC companies without receiving an error.