About Printing Statements Using Intelligence Reporting

Sage 300 comes with several financial reports that you print using Sage 300 Intelligence Reporting, including:

  • Financial Balance Sheet
  • Financial Income Statement
  • Financial Forecasting
  • Financial Ratios

Intelligence Reporting harnesses the capabilities of Microsoft Excel to provide quick access to information that you need from your Sage 300 system for operations and strategic planning. It also provides a powerful report designer that you can use to create customized reports and to analyze data in real time.

Note: You must have installed and activated Microsoft Excel to use these reports.

To print statements using Intelligence Reporting:

  1. Open Intelligence Reporting > Report Viewer.
  2. In the Report Viewer screen that appears, under the Designer heading, double-click the layout for the statement you want to view (for example, Financial Balance Sheet).
  3. On the ribbon, click Run.
  4. If the Enter Report Parameters dialog box appears, click the browse button, select parameters for the report, and then click OK.

    Intelligence Reporting generates the report, displaying the results on several tabs in an Excel workbook.

    Tip: For help on using Sage Intelligence Reporting, click the Home tab. This tab includes a variety of resources, including links to YouTube videos, the Sage Intelligence Community, and the Sage Intelligence Knowledge Base.

  5. Click the tab that contains the version of the report that you want to view.

    For example, if you generated an income statement, there are tabs for Actual YTD, Actual vs Prior, and Actual vs Budget.

  6. When you are satisfied with the results, you can print the report by clicking File > Print, then selecting print options as usual.

You can also view and print reports using the Report Designer. Open Intelligence Reporting > Report Designer, select a layout, and enter parameters, similar to the procedure for generating the report from the Report Viewer.