Collapse AllExpand All

6.1.4.  Ad Hoc Report

Ad hoc reports are completely free-form and user-defined. They give you the flexibility to create financial reports which do not fit neatly within the three standard statement formats.

Note

Any financial reports created in the system prior to version 2.1.0 are considered to be ad hoc reports.

Tip

Exercise caution before converting an ad hoc report to another report type. The process removes ad hoc group definitions, replacing them with standard statement format settings.

To create an ad hoc Report, select the Ad Hoc report type. The following screen will appear:

Ad Hoc financial report

When creating a new ad hoc report, you are presented with the following options:

Row Layout

Display lists groups and account numbers for the specified financial report.

The following buttons are unique to this screen:

ADD TOP LEVEL GROUP

Select to add a top level group to the report.

ADD GROUP

Select to add a group to the report.

ADD ACCOUNT

Select to add G/L account(s) to a financial report group.

ADD SPECIAL

Select to add a financial report special item.

MOVE UP

Highlight a group or account and then select this button to move the group or account up the list.

MOVE DOWN

Highlight a group or account and then select this button to move the group or account up the list.

6.1.4.1.  Financial Report Group

To add a new financial report group, select either the ADD TOP LEVEL GROUP or ADD GROUP buttons. The following screen will appear:

Add Financial Report Group

Tip

To add a sub-group to a top level group, simply highlight a top level group using your mouse, then select the ADD GROUP button. The screen for adding a sub-group is the same as the one for adding a top level group.

When creating a new financial report group, you are presented with the following options:

Name

Enter a name to identify the financial report group.

Description

Enter a brief description of the financial report group.

Subtotal/Summarize

Specify whether you want to subtotal or summarize the financial report group. If either is selected, specify which of the following display options you want to include subtotals or summaries for:

Show Subtotal

Will show subtotals for all included accounts when the financial report is generated.

Use Alt. Label

Select if you want to replace the label Subtotal with an alternate label when the report is run. The text for the alternate label is entered below.

Summarized

Will summarize the information for all included accounts and roll that information up to the group's top level when the financial report is generated.

Tip

A financial report can show either a subtotal or a summary—but not both. If neither is specified, the additional options will be unavailable.

Show Beginning Balance

Will show the subtotal or summary for all beginning balances included in the group when the financial report is generated. If selected, you also have the option to show the beginning balance as a percentage of the group total. Not selecting means the system will not calculate the beginning balance for the group.

Show Ending Balance

Will show the subtotal or summary for all ending balances included in the group when the financial report is generated. If selected, you also have the option to show the ending balance as a percentage of the group total. Not selecting means the system will not calculate the ending balance for the group.

Show Debits/Credits

Will show the subtotal or summary for all debit/credit balances included in the group when the financial report is generated. If selected, you also have the option to show debits and credits as a percentage of the group total. Not selecting means the system will not calculate the debit/credit balances for the group.

Show Budget

Will show the subtotal or summary for all budget balances included in the group when the financial report is generated. If selected, you also have the option to show budgets as a percentage of the group total. Not selecting means the system will not calculate the budget balance for the group.

Show Difference

Will show the difference between debits and credits included in the group when the financial report is generated. If selected, you also have the option to show the difference as a percentage of the group total. Not selecting means the system will not calculate the difference between debits and credits for the group.

Show Custom Column

Will show custom column details included in the group when the financial report is generated. If selected, you also have the option to show custom column details as a percentage of the group total. Not selecting means the system will not calculate the custom column balance for the group.

Use Group for % Total calculation

Indicate which group to use if percentage of group total calculations are specified. By default, the system will use the parent group for these calculations. The parent group is understood to be the group within which the group is immediately located. If you prefer to determine percentage of total calculations using a different group than the parent group, select that group from the list. All groups defined for the financial report will be available for selection.

Alt. Subtotal Label

Enter the label text you want to replace the label Subtotal with when the report is run.

Operation

Specify how the financial report group should operate in relation to the group specified under the Use Group option:

Add to Group Total

Select if you want the group to be added to the specified group's total. If selected, a + sign will appear next to the group as it appears in the financial report.

Subtract from Group Total

Select if you want the group to be subtracted from the specified group's total. If selected, a - sign will appear next to the group as it appears in the financial report.

6.1.4.1.1.  Financial Report Item

To add a G/L account to a financial report group, select the ADD ACCOUNT button. The following screen will appear:

Add account to financial report group

When adding an account(s) to a financial report group, you are presented with the following options:

Select One Account

Select when you want to add a single account to a financial report group.

Account: Select the G/L account you want to add to the financial report group.

Tip

Adding accounts by segment or type or sub type reduces the need for maintenance on your financial reports. Whenever new accounts are added or removed, your financial reports will automatically use accounts matching your selection criteria.

Select Multiple Accounts by Segment

Select when you want to add groups of accounts to a financial report group.

Number

Specify the account number segment(s) you want to add to the financial report group. All accounts matching the selected segment(s) will be added to the group.

Type

Specify the account type you want to add to the financial report group. All accounts matching the selected account type will be added to the group.

Sub Type

Specify the subaccount type you want to add to the financial report group. All accounts matching the selected subaccount type will be added to the group.

Operation

Specify how the account should operate in relation to the group specified under the Use Group option:

Add to Group Total

Select if you want the account to be added to the specified group's total. If selected, a + sign will appear next to the group as it appears in the financial report.

Subtract from Group Total

Select if you want the account to be subtracted from the specified group's total. If selected, a - sign will appear next to the group as it appears in the financial report.

To specify additional options for your financial report item, select the Options tab. The following screen will appear:

Select account options

When specifying additional options for your financial report item, you are presented with the following:

Show Beginning Balance

Select to include the account's beginning balance when the financial report is generated. If selected, you also have the option to show the beginning balance as a percentage of the group total. Not selecting means the account's beginning balance will not be shown.

Show Ending Balance

Select to include the account's ending balance when the financial report is generated. If selected, you also have the option to show the ending balance as a percentage of the group total. Not selecting means the account's ending balance will not be shown.

Show Debits/Credits

Select to include the account's debit/credit balance when the financial report is generated. If selected, you also have the option to show debits and credits as a percentage of the group total. Not selecting means the account's debit/credit balance will not be shown.

Show Budget

Select to include the account's budget balance when the financial report is generated. If selected, you also have the option to show budgets as a percentage of the group total. Not selecting means the account's budget balance will not be shown.

Show Difference

Select to include the difference between debits and credits for the account when the financial report is generated. If selected, you also have the option to show the difference as a percentage of the group total. Not selecting means the account's difference balance will not be shown.

Use Group for % Total calculation

Indicate which group to use if percentage of group total calculations are specified. By default, the system will use the parent group for these calculations. The parent group is understood to be the group within which the account is immediately located. If you prefer to determine percentage of total calculations using a different group than the parent group. All groups defined for the financial report will be available for selection.

Show Custom Column

Select to enable account information to be included in a custom column when the financial report is generated.

Show % of Group Total

Select to show the custom column information as a percentage of the group total.

Use Beginning Balance

Select to include the beginning balance for the account in the custom column.

Use Ending Balance

Select to include the ending balance for the account in the custom column.

Use Debits

Select to include the debit balance for the account in the custom column.

Use Credits

Select to include the credit balance for the account in the custom column.

Use Budget

Select to include the budget balance for the account in the custom column.

Use Difference

Select to include the difference between debits and credits for the account in the custom column.

6.1.4.2. Financial Report Special

The financial reporting engine (FRE) supports the addition of a limited number of special items, which may be used to extend your reporting capabilities. A special item can function as the child of a top-level or other group. To add a new special item to a financial report, select the ADD SPECIAL button. The following screen will appear:

Add Financial Report Special item

When adding a special item to a financial report, you are presented with the following options:

Note

Because ad hoc reports are not required to conform to the three standard statement formats, the Column Layouts tab is not available for ad hoc reports. Column layouts may only be used by financial reports which conform to these standard formats.

Name

Enter a name to identify the special item.

Type

Select one of the special item types from the following options:

A/R Open Items

Select to include the open receivables balance for the specified accounting period(s) in the financial report.

A/P Open Items

Select to include the open payables balance for the specified accounting period(s) in the financial report.

Show Beginning Balance

Select to include the special item's beginning balance when the financial report is generated. If selected, you also have the option to show the beginning balance as a percentage of the group total. Not selecting means the special item's beginning balance will not be shown.

Show Ending Balance

Select to include the special item's ending balance when the financial report is generated. If selected, you also have the option to show the ending balance as a percentage of the group total. Not selecting means the special item's ending balance will not be shown.

Show Debit/Credit

Select to include the special item's debit/credit balance when the financial report is generated. If selected, you also have the option to show debits and credits as a percentage of the group total. Not selecting means the special item's debit/credit balance will not be shown.

Show Budget

Select to include the special item's budget balance when the financial report is generated. If selected, you also have the option to show budgets as a percentage of the group total. Not selecting means the special item's budget balance will not be shown.

Show Difference

Select to include the difference between debits and credits for the special item when the financial report is generated. If selected, you also have the option to show the difference as a percentage of the group total. Not selecting means the account's difference balance will not be shown.

Use Group for % Total calculation

Indicate which group to use if percentage of group total calculations are specified. By default, the system will use the parent group for these calculations. The parent group is understood to be the group within which the Special item is immediately located. If you prefer to determine percentage of total calculations using a different group than the parent group. All groups defined for the financial report will be available for selection.

Operation

Specify how the special item should operate in relation to the group specified under the Use Group option:

Add to Group Total

Select if you want the special item to be added to the specified group's total. If selected, a + sign will appear next to the group as it appears in the financial report.

Subtract from Group Total

Select if you want the special item to be subtracted from the specified group's total. If selected, a - sign will appear next to the group as it appears in the financial report.

Show Custom Column

Select to enable special item information to be included in a custom column when the financial report is generated.

Show % of Group Total

Select to show the custom column information as a percentage of the group total.

Use Beginning Balance

Select to include the beginning balance for the special item in the custom column.

Use Ending Balance

Select to include the ending balance for the special item in the custom column.

Use Debits

Select to include the debit balance for the special item in the custom column.

Use Credits

Select to include the credit balance for the special item in the custom column.

Use Budget

Select to include the budget balance for the special item in the custom column.

Use Difference

Select to include the difference between debits and credits for the special item in the custom column.

6.1.4.3. Additional Options

To specify additional configuration options for the layout of your ad hoc report, select the Options tab. The following screen will appear:

Ad Hoc report Options

When specifying additional configuration options for the layout of your ad hoc report, you are presented with the following options:

Show Grand Total

Select if you want to include grand totals in the financial report. If selected, specify which of the following display options you want to include grand totals for:

Show Beginning

Will show the grand total for all included beginning balances when the financial report is generated.

Show Ending

Will show the grand total for all included ending balances when the financial report is generated.

Show Debits/Credits

Will show the grand total for all included debit/credit balances when the financial report is generated.

Show Budget

Will show the grand total for all included budget balances when the financial report is generated.

Show Difference

Will show the grand total for all included difference balances when the financial report is generated.

Show Custom

Will show the grand total for all included custom balances when the financial report is generated.

Alternate Labels

You have the option to substitute alternate text for the following column headers or row labels when viewing or printing your financial report:

Alternate Beginning Balance

Specify an alternate label to use as the header text for the beginning balance column. If not specified, the default text will be used.

Alternate Ending Balance

Specify an alternate label to use as the header text for the ending balance column. If not specified, the default text will be used.

Alternate Debits

Specify an alternate label to use as the header text for the debits column. If not specified, the default text will be used.

Alternate Credits

Specify an alternate label to use as the header text for the credits column. If not specified, the default text will be used.

Alternate Budget

Specify an alternate label to use as the header text for the budget column. If not specified, the default text will be used.

Alternate Difference

Specify an alternate label to use as the header text for the difference column. If not specified, the default text will be used.

Alternate Grand Total

Specify an alternate label to use as the text for the grand total row. If not specified, the default text will be used.

Alternate Custom Label

Specify an alternate label to use as the header text for the custom column. If not specified, the default text will be used.

Note

Any notes you add to a financial report definition will appear at the bottom of the financial report when the financial report is printed.