Crystal Reports affords you the means to report on any data in your system, categorized and formatted in whatever way you want. Irrespective of whether you want exception reports, statistical analysis, trend and comparison reporting, or a simplified snapshot, Crystal Reports eradicates the necessity for extracting the data to a different system.
In the first editions of MAS 90 and MAS 200 several customers shied away from Crystal Reports because it’s quite complicated and all report must be started from nothing. At present however, you can find specialists to help you get on track and even better, most of the Standard Reports in MAS 90 and MAS 200 are actually Crystal Reports so its possible to simply focus on amongst those and prepare improvements as required.
And in case the power of Crystal Reports still does not provide the same format you wish, you are able to extract the MAS 9 or MAS 200 data on the report right into Excel and resume your formatting and data massaging there.
Open Data Base Connectivity (ODBC) Links
Because MAS 90, MAS 200 and Excel (as well as other data analysis tools) are Open Data Base Compatible (ODBC), you can literally link from an Excel spreadsheet towards the MAS 90 and MAS 200 tables. Now most customers that use this feature do it only to get hold of a one-time data dump from MAS 90 and MAS 200, so that they can begin working with the data. At the same time if you have a recurring requirement for the same data, you could create the ODBC link as a live link within a formatted Excel spreadsheet, so that any time you open the spreadsheet, you can receive current data. Such as, for anyone who is currently extracting all the Sales Invoice History month after month for uses of commission calculation or salesperson reporting, and each and every month you use time sorting, and formatting the data, it is possible to quickly produce a preformatted spreadsheet with the ODBC link set and each month open it with current data, save it using another name and you are through. In a overall way, here’s how the new Sage MAS Intelligence tool runs.
Business Insights Explorer
With the move of MAS 90 and MAS 200 towards the new Business Framework (v4.x) Sage created Business Insights Explorer as an imbedded application giving you the capacity to perform business analytics on critical sets of data in your MAS 90 and MAS 200 system, while not having to attend Excel. Having an Excel like grid format, you can filter, group and total the data that makes meaning for your demands. Who is acquiring what, what items are moving and which aren’t, who’re my major customers and vendors. Even utilize it as an instrument to aim in on those clients who are behind in payments to help in the collection process. Existing either from the Business Insights menu, or from the Explorer menu within each module, you could start with amongst the 25 pre-existing Views and then tailor it to satisfy you particular business needs.
While you are over-relying on custom Crystal Reports or too much use of Excel spreadsheets, it could be time to examine DataSelf BI. DataSelf is a true DataWarehousing/Business Intelligence software that permits you to pretty much slice and dice the information in your MAS 90 and MAS 200 accounting software any way you choose. This easy-to-customize system is offered pre-configured with a data warehouse, OLAP cubes, dashboards and more than 2,000 reports and Key Performance Indicators (KPIs). DataSelf provides you the type of business analysis and reporting sometimes only found in products costing 5-10 times that of MAS 90 and MAS 200, nonetheless it can be used and studied in a matter of hours, not weeks.