SAGE EVOLUTION
Using the Business Intelligence Centre to Consolidate Data
Pre-requisites
1. The companies to be used in the consolidation must be using the same metadata
(Contact your Administrator to ensure that the repository settings are the same)
2. In order to include companies into the consolidation list, log into the individual companies. Ensure that the main company remains open whilst building the consolidation report.
Summary of Consolidating Companies in Sage Evolution (BIC)
1. Create a consolidation connection
2. Import the consolidation report into the consolidation connection
3. Select the databases to include in the consolidation report.
4. Run the report
1. Create a consolidation connection
1. Open the BIC Connector
2. Right click on the connection type “ODBC Driver SQL Server”
3. Select “Add Connection”
4. Type in a name for the connection
5. Tick the “use Auto Connection System” box at the bottom left of this screen
6. Replace the contents of the Database Name Field to @TENANT_CONSOLIDATION@
7. Click the Add button
8. On the properties screen on the right, at the bottom, tick the “Show Advanced” box
9. Scroll down and tick the box “Consolidation Connection”
10. Click the Apply button
2. Import the consolidation report into the Consolidation connection
Import the report, selecting the Consolidation Target Connection.
1. Right click on the Pastel Evolution Consolidation Connection
2. Select Import Report
3. Select the report to be imported and click the “Open” button. For the Management Pack select the report named: Consolidation Management Pack 2-0 (Evo).al_
4. The import screen will display
5. In the “Report Destination” box select an existing folder, or click the “New” button to create a new folder in which to store the consolidation report.
6. Click the Import button
Once the import process has completed you can close the Business Intelligence Connector.
3. Select the databases to include in the Consolidation
1. Open the Report Manager
2. Select the imported report.
This report is locked so you would need to make a copy of it first (Steps 3-6)
3. Right click on the report name
4. Select copy
5. Select the folder you want to copy the report into
6. Right click and select Paste
7. Using the “Copy Consolidation Management Pack …” report, notice the properties on the right side of the window.
A new field, Database Consolidation List, appears in red text
8. Select the ellipsis (…) to the right of the field.
9. A list of databases will appear.
10. Tick the databases you want to include in the consolidation.
11. Click the OK button.
12. You are now ready to run the consolidation report.
NOTE: If a database is not included in the list and you want to include it, then you must log into that company first. Open and close the Report Manager within that company. Then you can logout.
Go back to the database you were using to run the report, open the Report Manager and that database should now appear on the list.
Important Note regarding the report named Consolidation Management Pack
The standard Management Pack has been modified for consolidation purposes and named as “Consolidation Management Pack”.
It now includes an expression named “MasterSubAccountCompanyName”. This will allow for the extraction of accounts that are unique to a company. The unique accounts are necessary for the consolidation to work correctly.
The template file attached to the Consolidation Management Pack also differs from the standard Management Pack so you cannot create and link an existing standard Management Pack workbook to the Consolidation report. Any changes you may have made on a standard Management Pack template file would have to be done again after running out the Consolidation Management Pack.
Please take note of the additional instruction on the instruction sheet in the workbook, relating to “Multiple Retained Earnings” accounts.
Frequently Asked Questions
Question 1:
When running out the Consolidation Management Pack 2-0 (Evo) report, A pick list is displayed in which I’m allowed to select only 1 company.
Answer 1:
1. Open the Connector module and navigate to the Pastel Evolution Consolidation connection.
2. Ensure the Consolidation Connection option is checked. If this is not the case, tick the checkbox and click Apply in the top right corner of the window.
3. Open Report Manager, click on the Consolidation Management Pack 2-0 (Evo) report and click the ellipsis in Database Consolidation List. Select the companies you wish to consolidate for this report and click OK.
4. Run the report.
Question 2:
I get the following error message when trying to run out the Consolidation Management Pack 2-0 (Evo) report.
Answer 2:
1. Open Report Manager, click on the Consolidation Management Pack 2-0 (Evo) report and click the ellipsis in Database Consolidation List. Select the companies you wish to consolidate for this report and click OK.
2. Run the report
7