The best tool in the Sage ERP product line is Sage Intelligence Reporting. This tool comes with a number of preconfigured reports for financial, sales, inventory and purchasing reporting. This article will cover the sales, inventory and purchasing reporting tool. Sage Intelligence works with Microsoft Excel to create Pivot Tables for the reporting. Pivot Tables are a great tool for summarizing data.
Take the Sales Master report: This report allows you to see the sales total for a customer and the total for each item purchased. You can easily filter the report to see the total sales for any salesperson or combination of salespeople. You can modify the report to total on the salesperson and then the customer. You can drop the items and just see company totals. You also can just see the top 100 customers or maybe the top 10. If you want to add a field not on the report you can add a column in the report specs in the Report Manager. If the field you want to add is not in one of the tables the report uses, you can modify the container with a simple SQL join statement and then all the fields in the new table can be added to your report.
This product is available to add to Sage ERP products. it can be paid for as a one time fee plus maintenance or you can set it up as a subscription and pay for it monthly. Sage Intelligence Reporting is a very powerful tool that takes advantage of the capabilities of Excel Pivot Tables and the simple SQL statements to create flexible meaningful reports.
Written By Michael Ericksen, WAC Solution Partners- Midwest
-Partner, Certified Consultant