Summary

The Reporting Manager window is used to generate a Reporting Manager report that has already been set up using the Reporting Manager Maintenance window (GL> Reporting Tools> Reporting Manager).

Step by Step

1     Open the Reporting Manager window (GL> Reports> Reporting Manager).

2     Configure the report. 

• The Report Type drop-down menu is used to select the type of report you would like to generate. The selection in this field determines the reports that display in the Report drop-down menu.
• The Report drop-down menu is used to select the report template you would like to use to generate the report. Only report templates of the report type selected in the Report Type field will display in the drop-down menu.
  • You can view the report type attached to a report template using the Report Type Maintenance window (GL> Reporting Tools> Reporting Manager> Select a report> Report Type drop-down menu).
• The Account From and Account To fields are used to select the GL accounts you would like to display on the report. Click the Account From or Account To field label to select a GL account from a list.
  • Enter the same GL account number in the Account From and Account To fields if you would like to include a single GL account on the report.
• The Fiscal Period From and Fiscal Period To fields are used to filter the journal entries that display on the report by the fiscal period.
  • You can view the fiscal period attach to a journal entry using the display journal entries feature (GL> Display> Journal Entries> Filter the journal entries that display in the window> Fiscal Period column).
• The Fiscal Year field is used to filter the journal entries that display in the report by the fiscal year. This is a required field since the reports display YTD amounts.
• The Journal Entry Number field is used to filter the journal entries that display on the report by journal entry number. Journal entries are assigned a sequential number when they are created and the journal entry number sequence is reset at the beginning of each fiscal period. For example, if you enter 1 in this field and include more than one fiscal period on the report, the report will include the first journal entry of each fiscal period.
• The ALFRE field is used to filter the general ledger accounts that display on the report by the ALFRE designation attached to the GL account.
  • GL accounts inherit an ALFRE designation from the account type (GL> Maintenance> Chart of Accounts> General tab> Account Type field).
• The System field is used to filter the journal entries that display on the report by the module that was used to generate them.
  • Check the toggles for each module you would like to include in the report.
• Check the Suppress account without a balance, budget, or activity toggle to remove GL accounts from the report that have no beginning balance, activity, and budget.

3     Print the report.

• Click the Print icon to process the report immediately or enter a date and time in the field next to the Print icon to schedule the report to generate at a later time. You can view the progress of the report on the Job Viewer window (SS> Utilities> Show Scheduled Jobs).
  • Click the Print icon drop-down menu and select Print Preview to preview the report before printing.
  • Click the Print icon drop-down menu and select Excel to export the report data to an Excel spreadsheet as unformatted data.
  • Click the Print icon drop-down menu and select Excel (Formatted) to export the report data to an Excel spreadsheet that includes much of the Springbrook formatting found on the printed version of the report.
  • Once the report is generated, you can also display the report using the View Reports window (SS> Utilities> View Report).