Imagine my horror, when doing a Sage 200 upgrade recently, when faced with a report used by the customer, which used Sage 200 Excel Integration. The report was quoted as being their ‘Bible’ report.

In the 8 years of implementing Sage 200/MMS I have tended to steer clear of using Excel Integration. To my knowledge all colleagues of mine have done the same.

As much as anything this is probably because I have never taken the time to look at it, play with it and learn what it was capable of. It was never an element of the system that Sage focused on during their accreditation course(s) (Appendix B I think of the manual I received back then!!).

Generally speaking there has always seemed to be a better way of getting data out of Sage 200, whether it was using a good old EXCEL QUERY, a tool such as CRYSTAL REPORTS or more recently BUSINESS INTELLIGENCE, so I have never really seen the reason to use Excel Integration.

I do not think Sage have ever really extended the Functions that Excel integration offers so it never really became that powerful a reporting tool.

However this report I was faced with recently was very impressive. Excel Integration had been used to bring Budget and Actual values in to, basically, a Profit and Loss report structure.

There was the flexibility of being able to create the P & L based on the Nominal accounts, as opposed to the Report Categories and being in excel other required calculations were made from the data using standard excel formulae and functions. Also it was able to link to other reports that the customer had in Excel.

The report needed a slight tweaking following the upgrade as I had moved Sage 200 onto a new server, and the functions had a path to the MMS_Excel.xla file in front of them. A quick find and Replace and the report was running perfectly…pheeew!

It got me thinking though; about weather I had missed a trick with this tool over the years. Does anyone else use it? Or did anyone else use it?

For me, ok, I think Business Intelligence supersedes Excel Integration now. But maybe I should have given it a chance in the early days!

 

Ctayts

Advertisements