Sage Intelligence: Missing/Not all companies’ data included in consolidated company Sage Intelligence report

First note the above-mentioned issue may be due to the server PC name been changed since the consolidated report has been created.

Consider the following steps to resolve the above issue:

1. Usually, when you setup a new consolidated report layout within the Sage Intelligence Connecter screen, the Windows Server PC name is referred to in the  field marked below, in addition to the Use Auto Connection System option selected.

Please refer to the attached guide for more details on setting up a company Consolidated report.

Click here to open this guide:

Sage Intelligence Reporting: Running consolidated reports over multiple companies

2. Therefore, one way to resolve this matter is to do the following:

• Unselect the Use Auto Connection System option,
• enter the Localhost\SQL instance name value (as seen below),
• enter the User ID value = sa (the SQL instance main user), and
• enter the sa user’s password.

3. Ensure the rest of the steps in the attached guide is adhered to.

4. When done, click the Apply button on the top right of the screen to save your changes.