Sage Partners
Connect on Twitter
  • Home
  • Find a Reseller
    • By Location >
      • U.S. Partners
      • Canada Partners
    • By Sage Product >
      • Sage ERP Partners >
        • Sage 50 Partners
        • Sage 100 Partners
        • Sage 300 Partners
        • Sage 500 Partners
        • Sage X3 Partners
        • Sage Intacct Partners
      • Sage Construction Partners >
        • Sage 100 Contractor (Partners)
        • Sage 300 Construction (Partners)
      • Other >
        • Sage CRM Partners
        • Sage HRMS Partners
        • MIP Fund Accounting
  • Sage Product Info
    • Sage 50
    • Sage 100 >
      • Sage 100 Tips & Tricks
      • Sage 100 System Requirements
    • Sage 300 >
      • Sage 300 Installation Guides
    • Sage Intacct
    • Sage 500
    • Sage X3
    • Sage Construction >
      • Sage 100 Contractor
      • Sage 300 Construction
      • Sage Estimating
    • Other Sage Products >
      • Sage Fixed Assets >
        • Sage Fixed Assets User Guides
      • Sage CRM
      • Sage HRMS >
        • Sage HRMS System Requirements
  • Sage Add Ons
  • Resources
    • Blog
    • Popular Articles
    • Buying Guides >
      • Inventory Management Tips
      • ERP Implementation Failure
  • Contact Us

How to Turn a Single Company Into Multi-Company Report in Sage Intelligence

9/12/2017

0 Comments

 
Sage Intelligence Tips & Tricks
In Sage Intelligence, a number of reports are provided out-the-box for each Sage ERP product.  Most of these are standard single company reports.  It is, however, possible to turn any of these standard reports into consolidated multi-company reports. This tip will show you how.

​1. Add a Consolidation Connection

Most Sage Intelligence instances already come shipped with a Consolidation Connection.  However, if yours doesn’t, then you’ll need to add one (note: you need the Connector module for this).  

If you already have a Consolidation Connection then you can skip ahead to Step #2 - otherwise, follow the instructions below to add your own connection.

A. In the Connector, add a new Connection under the correct driver.

B. Give the Connection a name and click Add. Don’t worry about entering any other details in the Connection Info dialogue.
Sage Intelligence Report Connection Screen
C. Your new Connection will be listed under the Connection Type. Select it, and in the properties window, click the Show Advanced option.

D. Select the options Use Auto Connection System and Consolidation Connection and click Apply.
Sage Intelligence Report Connection
Once you have applied the changes to the Connection, the relevant connection details will be populated in the properties window.

See Also: Sage Intelligence vs Sage Enterprise Intelligence
​

2. Check to See if You Have the Latest Version of the Report You Want to Consolidate

It’s always recommended that you work with the latest version of a report.  You can check if there are any updates to a report via the Report Utility.  You can also use the Utility to browse for other reports that may be of interest to you as new ones are added regularly.
​

3. Make Sure Your Report is Unlocked

In the Report Manager, if you have downloaded a report from the Utility, it will likely be unlocked. However, if you want to make use of one of the standard reports that are shipped with Intelligence Reporting, you will need to unlock it (unless you’ve previously made a copy of it). It’s also recommended that you rename the report after you’ve made a copy of it.

See Also: How to Copy & Rename a Report [Video Tutorial]
Copy Report Function

4. Export & Import the Report Onto Your Consolidation Connection

Exporting a report and importing it onto a Consolidation Connection allows it to query multiple companies when it is run.  To do this, follow these steps:

A. Export your report to the desired location on your PC using the Export function on the Tools tab.
Export Report Function
B. Then import the same report back into the Report Manager, now using the Import function.  You may want to add a new folder for your consolidation reports.
Import to Report Manager
C. During the import process, when you get to the Import Report dialogue, make sure you select your Consolidation Connection and the folder you want the report placed in.
Sage Intelligence Import

5. Set the Companies You Would Like Data Pulled For

With your report imported onto the Consolidation Connection, under its properties, there will now be a Database Consolidation List field showing all the available companies - and you can select the ones you want to include in your report.  Take note that in a Union Report, this property is provided on all the Union Sub-reports, and you’ll need to select the companies you want for each one.  If the Union Sub-reports aren’t visible, then use the Toggle Hidden Reports option on the Tools tab to display them.
Sage Intelligence Database Connection List
Also take note that in order for your companies to appear in the Database Consolidation List dialogue, they need to be cached in your Tenant Cache.  To do this, close the Report Manager, sign into the respected company in your Sage product, and then open the Report Manager again.  Repeat this for each company you want to be loaded.

If you would like to view the companies that are saved in your Tenant Cache, select the Home object in the Report Manager and then on the Tools tab select Tenant Cache and then View Tenant Cache.
Sage Intelligence Tenant Cache
You're Done!
Once the companies you want have been checked in the Database Consolidation List, you can run your report.  The relevant information from each company will be output to their respective sheets in the report.
Get More Sage Intelligence Tips & Tricks
This article originally appeared on the Sage Intelligence website.

If you want more helpful tips like this, why not sign up for the Sage Intelligence mailer?  You'll get insightful tips & tricks delivered straight to your inbox on a weekly basis!
Subscribe Now!
P.S. You can also sign up for their Excel Tips & Tricks here:
​www.sageintelligence.com/subscribe/xl/
0 Comments

Your comment will be posted after it is approved.


Leave a Reply.

    ARE YOU A SAGE PARTNER?

    Get Your Business Listed Here!

    Click below if you're interested in having your business listed in this online directory of Sage Partners.
    Get Started
    Sage Warehouse Management
    Scanforce WMS for Sage
    Sage Cloud Hosting
    Picture

    Popular Articles

    Big Bang Implementation vs Phased Approach
    (Pros, Cons)

    ---
    What's New in
    Sage 100 2022

    ---
    What's New in
    Sage 300 2023

    ---
    New Release:
    Sage Intacct 2022

    ---
    What Does ERP Stand For?
    ---
    Sage 100 System Requirements and installation Guide
    ---
    Sage 300 Installation Guide
    ---
    Sage 100 Tips & Tricks

©2023 Top-Sage-Resellers.com. All rights reserved. This material and content on this website may not be reproduced, displayed, modified or distributed without the express prior written permission of the copyright holder. This website is not owned, operated, affiliated with, or endorsed by Sage Software, Inc. or Sage Intacct, Inc. Sage, Sage logos, and Sage product names mentioned herein are registered trademarks or trademarks of Sage Software, Inc. and/or its affiliates. Other product names mentioned are trademarks of their respective owners.
Privacy Policy