SB Enterprise Help Center

GL Query Manager Group Maintenance

Updated on

Summary

Query Manager Groups are used to organize query manager reports into user-specified groups and sub groups. These groups and sub groups of query manager reports can then be generated all at once from the Query Manager Report window (GL> Reports> Query Manager).

For example, an organization could create a Query Manager Group for grouping expense vs. budget reports and Sub Groups for grouping specific types of expense vs. budget reports. They could then use the Query Manager reporting tool to set up monthly expense vs. budget reports for the whole organization, for each department, and for individual teams within departments. By adding those reports to their own Sub Groups, they can be printed all at once as a sub group. In the event that all expense vs. budget reports need to printed at once, you can simply select the expense vs. budget Group and not select a Sub Group. All the reports in the Group will be printed with the specified report parameters.

Step by Step

 

1     View the existing Query Manager Groups.

  • Open the Query Manager Groups Selection window (GL> Maintenance> Query Manger Groups).
  • The Query Manager Groups Selection window will display all of the groups that have been created in the database.
  • Highlight a group and press DELETE or click the Delete icon to delete the selected group.
    • When a query manager group is deleted, it is removed from any query manager reports it has been associated with.
  • Press INSERT or click the Create icon to create a new group. This will launch the Query Manager Groups Maintenance window.

 

2     Create a new Query Manager Group.

  • Enter a unique Group name. This is a required field and can be up to 20 alphanumeric characters long.
    • Groups can contain as many sub groups as needed. However, a Query Manager report can only be included in one Group.
  • Enter a group Description. This is an optional field and can be up to 128 alphanumeric characters long.
  • Click the Create icon to add a Sub Group to the Query Manager Group. This will create a new line item in the Sub Groups section below.
    • Enter a Sub Group name for the new sub group.
      • Sub groups are used to organize Query Manager reports within larger groups of reports. Each Query Manager report can only be included in a single sub group.
      • This is a required field and can accommodate up to 20 characters.
    • Enter an optional Description for the sub group.
    • Repeat this process to add additional sub groups to the Query Manger group.
  • Click the Save icon when complete.
Previous Article GL Chart of Accounts Maintenance
Next Article GL Recurring Journal Entries Maintenance
Still Need Help? Contact Us