Get a dynamic view of your top customers with the Top Customers Analysis report

This report gives you a dynamic view of your top 5, 10, 15 and 20 customers—depending on your requirements. The first dashboard you’ll notice is a map chart, which opens up after you’ve entered your required from and to date. This map chart highlights the amount of Sales per Customer by Location. The size of the bubble indicates the […]

Continue reading


View quantities and values of stock purchased and sold with the Stock Movement report

This report displays the quantities and values of stock purchased and sold from the start date you enter at runtime to the current date, broken down by product.  It also includes opening and closing stock amounts.  This enables you to tell, at a glance, whether you’re perhaps overstocking or understocking on certain items, and whether […]

Continue reading


Get an overview of your purchasing behaviour with the Purchase Analysis report

This report gives you an overview of where, and from whom, you’re purchasing goods and services based on the date selection you have made. To run this report, you’ll first choose the from and to date by simply clicking on the date selector to expand it further: The Purchase Analysis by Region report will then open for the period […]

Continue reading


Flag customers who owe you money with the Overdue Customers report

This report helps you flag customers who are currently overdue and owe you money. With this report, you’ll be able to drill-down to specific customer information to follow up on the outstanding amounts as soon as possible—which will help your business cash flow. There are 3 pages to this report, namely; Overdue Customer Dashboard, Detail, […]

Continue reading


How to create a linked dashboard (or landing page) for your Excel workbook

Have you ever had the pleasure (or displeasure) of working with an extra large Excel workbook with many, many different sheets? This happens frequently, especially if you are working with a large amount of data that needs to be analyzed periodically. This may be due to multiple tables, lookups, references, charts, graphs etc. This has […]

Continue reading


Learn how to use Column Variables for more descriptive headings in your cloud reports

Having descriptive headings in a report can make it easier to comprehend.  For example, having month names instead of period values for column titles can make it easier to determine the data a column refers to.  Sage Intelligence now makes this possible in a dynamic way through Column Variables. This tip applies to: Sage Business […]

Continue reading


Learn how to check your Containers in the Sage Intelligence Connector module

Being able to check if the components of a report are functioning as expected while working with them can help provide a smooth workflow and save time dealing with problems later in the report creation process.  Also, if you do come across errors in a report, being able to test its components easily allows for […]

Continue reading


Five non-negotiable questions you should be asking your reporting solution

Many companies today suffer from a lack of visibility into key performance metrics. We call this “keyhole visibility” because it’s the equivalent of trying to evaluate what’s happening in a room by looking through the keyhole. With a narrow view, you’re unable to fully understand what’s behind the door and what might be lurking around […]

Continue reading


Sage © Sage South Africa Pty Ltd 2019 . All Rights Reserved.