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:
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.
With such a wide variety of features and functionality available, Intelligence has you covered
from A to Z.
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.
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(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.