How to generate the Consolidated Financial Reports in Sage 100 Intelligence
Products
Sage 100
Country
North America
Description
How to generate the Consolidated Financial Reports in Sage 100 Intelligence
Disclaimer
Support
Sage Customer Support does not provide assistance for issues related to third party products or enhancements, hardware, report customizations, state or federal tax-related questions, or specific accounting questions. Please contact your Sage business partner, network administrator, or accountant for assistance. Please review this document for additional information on the scope of Sage Customer Support Services.
Resolution
The Sage 100 Intelligence Connector module is required In order to generate Consolidated Reports. For more information on purchasing the Connector module, please contact your Sage Business Partner.
- Open Sage Intelligence Report Manager
- Double click the Financials folder
- Double click the Consol Financial Reports 3-x, (x= will be different depending on version you have installed)
- Double click Union Sub Reports
- All sub reports will be listed, right click on the Consol Acc Group Code 2-x sub report, (x= will be different depending on version you have installed) and select Go to Sub Report **This will take you to the actual sub report
- On the right side, in the Database Consolidation List, click the Ellipsis (…) button, select each company code you wish to consolidate.
- NOTE: This selection is populated by logging into Report Manager. If a company code is missing, close Report Manager and relaunch entering the missing company code when logging back into Report Manager.
- Highlight the Consol Financial Reports Sub 2-x, (x= will be different depending on version you have installed)
- On the right side, in the Database Consolidation List, click the Ellipsis (…) button, select each company code you wish to consolidate
- Important: Company codes selected should be the same on all sub reports that are linked to that report
- If additional sub reports were listed, you would need to repeat steps 5-6 above for all sub reports
- Highlight the Consol Financial Reports 3-x, (x= will be different depending on version you have installed)
- Click Run button
- In the Enter Report Parameters window, enter or select Fiscal Year and Budget Code and click OK
- Assign the General Ledger Account Group Categories on the Categories tab
- Click on the Menu tab and generate the desired Consolidated Financial Report
- If report needs to be saved to run the same way in the future, leaving report open in Excel, go back into Report Manager, select report name then right click and select Create and link template
Note: Steps above use the Consolidated Financial Report as an example, but similar steps would need to done for any consolidated type of report. All Union reports associated with the report must have the same company codes selected. (ex. Report Designer Add-in type of reports have 8 different sub reports), see step #5 to determine associated Union Sub Reports.
TIP! If you want to have a new/different set of union reports linked to a consolidated report, you will need to export report and import back in, choosing option to create new container for each union sub report, please see related article on importing/exporting report in Sage Intelligence
Additional information
NOTE: You must be using a consolidated type of report in order to change company codes from within the Report Designer Add-In task pan
