.net error when opening reporting trees from report designer

From Sage Intelligence Knowledgebase
Revision as of 07:26, 12 September 2019 by Keeveshin (Talk | contribs)

(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to: navigation, search


Sage 50 US desktop

Sage 100

Sage 300

Sage 500

Microsoft office 2016 and 2019


When clicking on edit/add in the reporting tress menu, the user receives the below error:



A Microsoft update to Excel broke .NET functionality thus affecting Sage Intelligence reporting tree functionality.


After extensive testing, we found the customer was using different versions of Excel, and the new update was causing issues within Microsoft Windows.

In some cases an uninstall (using Revo) and reinstall of Excel to the latest version would fix, whilst in other cases the issue would remain. This is due to updates released by Microsoft which corrupts the Windows registry.

In a similar case, we had a customer with the issue persisting. We asked the customer to format (wipe their PC clean) then reinstall windows. This worked. The clean install wiped out all of the corrupted files in the registry, the ERP software and Excel (latest version was installed) this worked without any issues.

Customer's Excel needs to be on the latest version as per screen shot below: