The Optimal Combination: Sage ERP MAS 90 and 200 Plus Sage ERP MAS Intelligence

It is no secret that having the optimal financial reporting and analysis tool allows you to gain greater control of your entire business by giving you both a past and future view of your business-critical information. But with so many options, how do you choose the right solution? The first step is considering what your business needs are. Do you need a tool that:

• Is easy to use and implement?
• Gives you access to your entire business’s data, not just General Ledger data?
• Allows you to reduce month-end close time by eliminating the creation, running, and distributing of manual reports?
• Allows you to run real-time reports?
• Allows you to easily manipulate information to fit your business needs?
• Allows you to drill down deeper into business-critical data so you can analyze current and future trends?

The chosen financial reporting and analysis tool of Sage Simply Accounting, Sage Peachtree, and Sage ERP Accpac and with over 22,000 installs worldwide, users would agree that Sage ERP MAS Intelligence (Intelligence) offers you this and more. Intelligence seamlessly integrates into your Sage ERP MAS 90 and 200 solution and is 100% Microsoft Excel^®-based for easy report design, distribution, and consumption. It allows managers to spend more time focusing on information analysis and interpretation and less time pulling the data together.

Sage believes so strongly that Intelligence will take your business beyond simple General Ledger reporting that available this month, support plan customers will receive a single-user Report Manager license for v4.4 and v1.4 at no additional charge. Instantly you can start authoring new reports (organizing, creating, editing)! A long with filtering and cloning the standard report templates for management (financial reports, dashboards, financial trend analysis) and general ledger sales, purchases, and inventory transactional reports.

It doesn’t stop there. Intelligence is available at different user levels and for multiple databases. Mix and match licenses and modules that best suit your businesses needs with ease.

• Report Viewer licenses can run existing reports to get access to real-time information and have some basic filter and change parameter editing capabilities, including drill down.
• Report Manager licenses have the capabilities of Report Viewer, plus the ability to create new reports, set up parameters, establish new templates, and more.
• Report Designer licenses provide you with total flexibility in a drag and drop format to build new templates and reports, tailored to your specific needs.
• Connector module allows you to access unlimited multiple disparate databases and consolidating data from multiple companies.

With such a wide variety of features and functionality available, Intelligence has you covered
from A to Z.

Learning Services: Free Training Videos on YouTube, Sage ERP MAS Intelligence Courses and More!

Sage MAS Intelligence is the new easy-to-use reporting tool available with Sage ERP MAS 90 and 200. Get prepared to start working with this powerful new tool by attending our new Sage ERP MAS Intelligence courses. Start with the basics by attending the Sage ERP MAS Intelligence Jumpstart realtime course, continue your training by attending the Sage ERP MAS Intelligence Intermediate virtual classroom course, and become an expert after attending the Sage ERP MAS Intelligence Advanced virtual classroom course. Visit Sage University for a complete listing of course dates and times.

Excel Tips of the Month

Question: I have a list of inventory in my worksheet, is there a way of finding duplicate cells without having to manually sort and check each cell?

You can find duplicates using the COUNTIF function.

=COUNTIF($A:$A,$A3)>1

=COUNTIF(column with duplicates, first cell in column)>1

The CountIF will return a Yes or a No to a question: the question in this instance is whether the number of times the value in cell A3 is counted is greater than 1. If it is, then it’ll return Yes, otherwise False.

Question: Would you like to be able to protect a worksheet but unprotect selected cells so they can be edited?

The cells you are going to “Unlock” are the cells you want to be able to edit. To Unlock the cells, select the cell you want to be able to edit (Hold down ctrl to select multiple cells) From the Home tab, in the Cells group, select the drop down arrow under Format Deselect “Lock Cell” (so you are now Unlocking the cell) OR If you prefer, you can right click on the selected cell/s Select Format Cells Select the tab at the top called Protection De-select the box for Locked Select OK

To protect the worksheet, select the Review tab, in the Changes group, select Protect Sheet Enter in the necessary (password etc) You will now only be able to edit the “Unlocked” cells.