Sage MAS 90_200 Business Intelligence and Reporting

BizInsights Financial Reporting

The BizNet BizInsight™ is an Excel-based business reporting and analytics solution that delivers simple, yet powerful, reporting and analysis capabilities to business users. BizInsight™ makes it easy to gain control of the entire business reporting and analysis process by ensuring data from MAS 90/200 ties to data in Excel.

Key Functionality:

• 100% Excel based for easy report design, distribution and consumption
• Replaces static Excel spreadsheets that companies maintain every period with live, integrated reports that can be refreshed by decision makers on their own
• Reduces the month-end close time by eliminating the running and distributing of reports
• Provides business intelligence ‘on-the-fly’ allowing the user to define the drill down
• Reflects adjustments within reports instantly with a click of a ‘Refresh’ button

Contact ASI to discuss Financial Reporting needs.

Crystal Reports

Create and customize presentation-quality reports from your Sage MAS 90 or Sage MAS 200 ERP systems data with Crystal Decisions software. Crystal Reports® is a powerful report writer that allows you to create meaningful reports quickly and easily. You can use sample reports straight out of the box. Or, modify reports to suit your needs, then save and run them anytime.

Key Functionality:

• Sub-Reports may be embedded in a main report so that you can insert information from different tables with different formats into any section of a report
• You can present summary information in a single cell, replacing columnar report formats
• This feature allows for printing with greater precision on pre-printed forms using new guidelines and text objects
• You can combine database information with letters or other text objects, and specify selection criteria to target specific groups of customers
• You can graph on details, formulas, and subtotals, and you can choose from several graphical formats

Business Alerts

This innovative product utilizes your e-mail system to notify you whenever something significant happens in your Sage MAS 90 or Sage MAS 200 ERP system. The notifications that you choose to generate can be selected from a series of sample alerts, which can quickly be tailored to suit your specific needs. Or you may choose to create custom alerts based on your company’s unique needs.

Key Functionality:

• Analyze critical data using scheduled alerts
• Monitor date and time-sensitive events
• Automatically send e-mail messages alerting specific individuals about certain conditions
• Track important business functions
• Customize sample alerts for your specific business requirements

Business Insights Dashboard

Business Insights Dashboard provides timely and efficient access to accurate financial information generated from your Sage MAS 90 or 200 system. You can keep on top of critical business management information and be better prepared to thrive in today’s fast-paced, highly competitive business environment.

Key Functionality:

• A wizard makes it easy to customize your start page and select the reports you want to see
• View your information within the Sage MAS 90 or 200 Desktop or access it directly with Internet Explorer
• You have the option to drill down into selected Sage MAS 90 or 200 reports and inquiries to display additional information
• The easy-to-read information display uses a combination of visually effective text and graphics in an attractive, contemporary design
• Data is automatically refreshed through a polling process that takes place in the background

F9 Report Writer

F9 is a Financial Reporting application, which dynamically links the Sage MAS 90 and Sage MAS 200 ERP General Ledger data to Microsoft Excel. By employing a combination of simple cell formulas in Excel, F9 allows General Ledger data in Sage MAS 90 or 200 to be formatted into any desired financial report in the flexible and powerful environment of the spreadsheet. The F9 Report Wizard allows you to go from a blank spreadsheet to a fully formatted, hot-linked report in just seconds.

Key Functionality:

• The presentation of your financial information can be enhanced by taking advantage of the graphics, text, and add-in capabilities of your spreadsheet
• You can create financial reports that span any period, even a one-week or one-day Profit and Loss (P&L), if desired
• By loading all or part of your chart of accounts into memory, you can speed recalculation times dramatically
• Find the origin of any number in your spreadsheet—drill down all the way to the individual transaction itself
• You are guided through report creation step by step; in seconds, you can create a complete financial report with all F9 functions, formulas, and cell references intact

Business Insights Explorer

Business Insights Explorer is the most convenient way to navigate your business. It brings ad hoc inquiry, drill-down, drill-around analysis up to a whole new level. Turn your data into knowledge that you can act on by using powerful sorting, grouping, filtering, and charting capabilities that you personalize to your specific needs and role within your company.

Key Functionality:

• Business Insights Explorer provides a single, user-friendly interface that gives you quick access to crucial information, and related data—all the way down to the individual transaction
• View key information about a specific entity, such as a customer and related transaction information, including invoices and orders, in a single view using the Preview option
• Quickly convert your Business Insights Explorer grid information into a chart and display your information the way you want to see it
• Task Management options provide an easy way for you to quickly access key tasks for the displayed view, including customer information update and order creation capabilities
• A simple right-click can export your data to pre-defined Word templates, plus Excel, Access, or XML files. Easily create mail-merge documents based on the filtered data being viewed

FRx Desktop

Maximize the flexibility of your report formats! Specify row and column formats independently or combine formats with custom reporting trees that match your company’s chart of accounts structure to report on specific cost centers.

Key Functionality:

• The FRx link allows you to build general ledger lists automatically and pull your accounting data directly from the application
• Change fonts and colors for professional-looking report printing
• Drill down to the transaction-level detail
• Roll Up allows you to consolidate business units, yielding combined totals and other information
• Use “Cleaver” tool to resegment accounts or carve out new account structures

Business Insights Reporter

Designed to provide the data you need to make critical decisions, Business Insights Dashboard presents information in a high-level, attractive graphical format that allows you to instantly ascertain the state of your business. Flexible, yet simple to use, Business Insights Dashboard is displayed within the Sage MAS 90 or 200 Business Desktop and can also be accessed directly with Microsoft Internet Explorer, Outlook, or Digital Dashboard.

Key Functionality:

• Data is presented in logical views – no need to try to figure out what table to get data from or how to link to additional data for your report
• Wizard-driven reporting – wizards guide you through all of the required steps to create a report
• Choose your format – output reports to multiple formats, including Excel, Adobe PDF, or XML, in addition to printing
• Secure access to your data – determine which user roles will have access to reports

Visual Integrator

Facilitate seamless integration between Sage MAS 90 or 200 data and other business applications Visual Integrator can import from (or export to) any ODBC-compliant source, without the need for an intermediary data file such as ASCII delimited or Microsoft Excel.

Key Functionality:

• Link multiple ODBC tables together, and point and clieck to select fields for importing
• Validation logic is built into Visual Integrator to assure that the data being imported conforms to Sage MAS 90 and 200 rules
• Use multiple methods of scheduling Visual Integrator jobs
• Each import or export job can be assigned a passoword, which is then required before the job can run
• Jobs can be set to run in sequence