Modify Special Reports Setup

Modify Special Reports Setup allows you to set up and edit your special reports. Click Filters on the blue bar above the grid if you want to narrow down your displayed reports. You can filter by Title or by selecting which Statement Types to display. Click the Search button to display results or the Cancel link to return to the main General Ledger page.

When no special reports exist, you are prompted to start with either a Manual or Auto Generate set up.

This Section Includes:

Filters

The following fields are filters and allow you to reduce the number of entries that appear on the grid. Click the Search button to refresh the entries on the grid.

  • Title: Enter a partial or full name of a special report. (Example: If you have a lot of Special Reports but want to find all the reports that have "Director" in the name of the report, then enter "Director" in this field and then click the Search button.)
  • Statement Types: This is a drop-down list where you can select one or multiple report types. (Example: If you only want to see the special reports that include the "Statement of Activities" report type, select the check box next to "Statement of Activities".)
  • Security Level: There are several security levels available:
    • Not Filtered: Displays all special reports regardless of the security.
    • Unsecured: Only displays the reports that do not have a password assigned.
    • Change, Delete or Run: Displays the reports with this Security Level assigned.
    • Change or Delete: Displays the reports with this Security Level assigned.

Special Reports Grid

You can drag and drop grid items when creating or editing your special reports.

Special reports you have already created appear in a grid. The following columns are displayed:

  • Title
  • Note: Hover over the Note  icon to preview the note.
  • Setup: Hover over the Information  icon to display user and time information for when the report was set up and last updated.
If your chart of accounts has been altered, you receive a message above the grid informing you of this fact and prompting you to review your reports to see if you need to make any changes. Click the Report of changes button to bring up a report displaying all changes to the chart of accounts. Click the Close Report button when finished to return to the Special Reports Setup page. You can also click the Clear Change Flag link to remove this warning.

Double-click on a special report or click the Edit  icon to edit (More Information), the Delete  icon to prompt you to delete the special report, or the Copy  icon to create a copy of the special report. Click the Add New Report button above the grid to add a new special report manually (More Information), the Auto Generate New Report button to begin generating a new special report (More Information) or select one or more reports in the grid and click the Copy Reports button to create a copy of all selected special reports.

Setup List

Select one or more reports and click the View Setup List button to view the Special Report Setup List window where you can select your report preferences:

  • Show General Ledger Links: This option displays the individual records that make up the lines in the special report.
  • Show Account Details: This option displays the details of accounts within each line on the special report.

Selecting both options displays the complete breakdown of the special report.

Click the OK button to display a preview of your Special Report Setup List report. You can navigate the pages, export to several formats (e.g., PDF, Excel, Word), and Print. Click the Close Report button to return to Modify Special Reports Setup.

Run Reports

Select one or more special reports and click the Run Reports button to display a preview of the associated reports. You can navigate the pages, export to several formats (e.g., PDF, Excel, Word), and Print. Click the Close Report button to return to Modify Special Reports.

Special Reports > Update

Modify Special Reports - Update allows you to edit the details of your special report design and select which reports to print using that design.

This Section Includes:

Special Reports Grid

The Expand All and Collapse All buttons expand and collapse the entire grid. The report Title can be edited while the Add New Group and Add New Line buttons allow you to add items to your special report. 

Security Level:

After selecting either the Change, Delete or Run or the Change or Delete option from the drop-down list, a Report Password field appears. Enter the password for this report. Passwords are saved separately for each special report. (Passwords can be reset by calling Support and verifying your credentials.)

Click the Add New  icon by any group in the grid to add a group or line under that group. Click the Edit  icon to edit any group or line, and the Delete  icon to prompt you to delete a group or line from the grid.

You can drag and drop grid items when creating or editing your special reports.

Special Reports Update

When adding or editing a group you can specify the Description, whether you want to Reverse sign when printingShow Heading, and where you want to Include Under. This is a drop-down list allowing you to select whether to position the group at the top or place it under another group. Click the Update button to save changes to the group or the Cancel link to return to the previous page without saving.

The option to Reverse sign when printing has a special function when using the Cash Flow report. If this option is not selected, the amount printed on the Cash Flow report is the opening balance. If selected, the amount is for the period.

When adding or editing a line you can specify the Description, whether you want to Reverse sign when printing, and where you want to Include Under. This is a drop-down list allowing you to select whether to position the line at the top or place it under a group. You also have a grid where you can click the Add new line link to add accounts or ranges of accounts from any level of your chart of accounts. The Sub-Account drop-down list allows you to specify which sub-accounts you want to include on the line. Select any option other than Show All to display field(s) so you can input the number(s).

Click the Apply button to save changes to the line and start entering a new line, the Update button to save changes to the line, or the Cancel link to return to the previous page without saving.

When using an account range, the fields behave in the following fashion:

  • <blank> - 40100: A blank in the first field and 40100 in the second field indicates you want only account 40100 for that line.
  • 40100 - <blank>: The number 40100 in the first field and a blank in the second field indicates you only want account 40100 for that line.
  • 0-40100: A zero in the first field and 40100 in the second field indicates you want all accounts less than or equal to 40100 for that line.
  • 40100-0: The number 40100 in the first field and a zero in the second field indicates you want all accounts greater than or equal to 40100 for that line.
  • 40100-49999: The numbers 40100 in the first field and 49999 in the second field indicate you want all accounts between 40100 and 49999 for that line.

After setting up the special report click the first report that you want to print on the right panel under Report(s) Selection. This displays the Preferences window for that report. Make your selections and customizations then click the Update button to select the report and return to the Update page or the Cancel link to return to the Update page without selecting the report. You can select as many reports as you like. Click the Delete  icon in the Report(s) Selection area by any report to be prompted to delete the selection.

You must select at least one report to print.

Click the Update button to save all changes, the Reset link to undo all changes since the last time the page was updated, or the Cancel link to return to the main Special Reports page without saving.

 

 

Updated

Was this article helpful?

0 out of 0 found this helpful

Have more questions? Submit a request