GL> Reports> Query Manager

Query Manager

Summary

The Query Manager window is used to generate a Query Manager report using a template that has already been created using the Reporting Tools palette (GL> Reporting Tools> Query Manager). Click here for information on creating a Query Manager template.

Step by Step

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

2 Configure the report.

The Report Name drop-down menu is used to select the report template you would like to generate. Only Query Manager report templates that have been created using the Reporting Tools palette will display in the drop-down menu (GL> Reporting Tools> Query Manager).

Click here for information on creating a Query Manager report template.

If filters have been added to the query manager template (GL> Reporting Tools> Query Manager> Open a report template> Filters tab), the filters will populate in the window.
If you are using the Report Group and Report Sub Group functionality below, this field will be cleared and disabled.

The Report Group and Report Sub Group fields are used to generate a set of Query Manager reports that are grouped into the selected Report Group or Report Sub Group. These are optional fields and should only be used if your organization utilizes Query Manager groups.
- If you select a Report Group and a Report Sub Group, all of the Query Manager reports associated with that Report Sub Group will be printed.
- If you select a Report Group but do not select a Report Sub Group, all of the Query Manager reports associated with all of the Report Sub Groups in the selected Report Group will be printed.
- Query Manager Report Groups and Sub Groups are created and maintained on the Query Manager Group Maintenance window (GL> Maintenance> Query Manager Groups). Click here for information on Query Manager Group Maintenance.
- Query Manager reports are grouped into reporting groups and reporting sub groups on the Query Manger report template maintenance window (GL> Reporting Tools> Query Manager> General tab> Report Group and Report Sub Group fields).
- As with any other Query Manager report, all the grouped reports generated using the Report Group and Report Sub Group functionality can still be configured using the fields below with one exception. When using Query Manager grouping functionality, the Section Types field below will be disabled and the section types selected on the Query Manger Maintenance window will be used.
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 search icon 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 Budget Group field is used to filter the accounts included in the report by those associated with the selected Budget Group. Click here for information on Budget Group Maintenance.
The Date Type drop-down menu is used to select the type of date that will be used to filter the transactions included on the report.

Select Date if you would like to filter the transactions on the report by journal entry date.

The journal entry date of a journal entry is generally defined during the GL Distribution step of a batch process.

The Date From and Date To fields are used to filter the transactions that display on the report by journal entry date.

The journal entry date of a transaction is generally defined during the GL Distribution step of a batch process.

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 From and Fiscal Year To fields are used to filter the journal entries that display in the report by the fiscal year.
Select a report layout in the Orientation field.
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 Use Period Budgeting toggle will not affect the report output as Period Budgeting has not yet been implemented in Version 7.
The System field is used to filter the journal entries that display on the report by the module that was used to generate them. For example, check the PR toggle if only journal entries generated in the Payroll module should be included on the report.

Click the toggle next to the field title to include all modules.

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). Click here for information on the General tab of the Chart of Accounts Maintenance window.

The Section Types field is used to select additional Fund, Department and Account filter options that were set up when the selected Query Manager Report was created (GL> Reporting Tools> Query Manager).