Handling Your Data In MAS 90 and MAS 200 is Trouble-free

Crystal Reports

Crystal Reports offers you the ability to report on any type of data in your MAS 90 or MAS 200, categorized and prepared in whatever way you like. Regardless if you need exception reports, statistical analysis, trend and comparison reporting, or a quick overview, Crystal Reports does away with the requirement for drawing out the data to a different solution.

In the earlier versions of MAS 90 and MAS 200 several customers shied away from Crystal Reports because it was very intricate and every report needed to be done from nothing. Presently however, there are actually specialists to aid you in getting established and even better, many of the Standard Reports in MAS 90 and MAS 200 are in reality Crystal Reports so you can just start with considered one of those and have alterations as required.

And if the capacity of Crystal Reports still does not bring you the particular format you want, you can extract the MAS 90 or MAS 200 data on the report straight to Excel and carry on your formatting and data massaging there.

Open Data Base Connectivity (ODBC) Links

As MAS 90, MAS 200 and Excel (as well as other data analysis tools) are Open Data Base Compatible (ODBC), it is possible to literally link directly from an Excel spreadsheet directly into the MAS 90 and MAS 200 tables. Now a lot of users that use this capability do so just to secure a one-time data dump from MAS 90 and MAS 200, so they are able begin working with the data. Then again if you experience a repeating need for the same data, you could establish the ODBC link as a live link with a formatted Excel spreadsheet, to ensure each time you open the spreadsheet, you can receive current data. Such as, when you’re recently extracting all the Sales Invoice History every month for intentions of commission computation or salesperson reporting, and just about every month you use time sorting, and formatting the data, you can only build a preformatted spreadsheet with the ODBC link set and each month open it with existing data, save it using another name and you’re done. In a big picture way, here’s how the new Sage MAS Intelligence software works.

Business Insights Explorer

Along with the move of MAS 90 and MAS 200 to the new Business Framework (v4.x) Sage introduced Business Insights Explorer as an imbedded program which gives you the capability to accomplish business analytics on key pieces of data inside your MAS 90 and MAS 200 ERP, without needing to check out Excel. Having an Excel like grid format, you’re free to filter, group and total the data that makes logic for your specifications. Who is acquiring what, what goods are moving and which aren’t, who’re my largest clients and distributors. Even work with it as an instrument to concentrate in on those clients who’re behind in payments to aid in the collection process. Available either from the Business Insights menu, or from the Explorer menu within each module, you can begin with amongst the 25 pre-existing Views and then modify it to match you distinct business wants.

DataSelf BI

When you are over-relying on custom Crystal Reports or excessive use of Excel spreadsheets, it might be time to examine DataSelf BI. DataSelf is certainly a true DataWarehousing/Business Intelligence software that enables you to pretty much slice and dice the information within your MAS 90 and MAS 200 accounting software in whatever way you would like. This easy-to-customize solution is offered pre-configured with a data warehouse, OLAP cubes, dashboards and over 2,000 reports and Key Performance Indicators (KPIs). DataSelf delivers you the type of business analysis and reporting sometimes only seen in systems pricing 5-10 times that of MAS 90 and MAS 200, could possibly be started and studied in just hours, not days.

 

Posted in ERP Software

Tags: mas 200, mas 90