Report Maintenance

Use this form to create the financial reports that WebView users can view. You can copy and edit an existing report to create new versions or to add new features.

Options Reference

Each option and field on the form is described below. Mandatory options and fields are highlighted in red.

Code

Enter a code to represent the report, up to 20 alphanumeric characters.

Description

Enter a detailed description of the report.

Row Format

Select the row format you defined for the report.

Column Format

Select the column format for the report.

Security

Select the security structure you defined for the report.

Name

Type the report name including place markers to include when the report is generated using the scheduler.

Use Default GL Budget

Select this option to use the default general ledger budget assigned on the GL Module Control form (if applicable for budget-related reports). If you don't select this option, you can select a budget on this form.

GL Budget

Enter the general ledger budget to use in the report if the option to Use Default GL Budget is not selected.

Allow Override at Runtime

Select this option to enable the user to change the budget when running the report

Latest Period

No Restriction - You can specify any date on which to run the report for.
Selected - Enter a date for the report. Only use this for a year-end report.
WebView default - Make the run date the date specified on the General Ledger Module Control form.

Default Report Library

Select the default report library to which reports are saved to when you generate them.

Use Source Company Periods for Consolidation

If a report is showing multiple companies across or down the page, select this option to display the current company's periods.

Note: Companies being consolidated also require the same budgets.

Omit Company Code from Account name

Select this option if you don't went to display the company code when viewing the account details within a financial report.

Transpose

Select this option to display the row format across the page as columns.

The amount of detail that displays across the page depends on the whether the row format allows drill down.

On the Style Maintenance form, disable the Allow drill Down option on the Other tab prevent the tree detail being displayed across the page.

Exclude Zero Balance Tree Rows

If all the accounts belonging to a tree branch (specified for a row) have no value based on dates specified, then the row is excluded.

Allow change at runtime

Select or deselect the above setting at runtime.

If the Column Format you specify includes any TCode column types, the above two fields display.

Default Transaction Tree

Select the default transaction tree to use for this report.

Allow Tree Selection

Select this option to enable the user to change the transaction tree when they run the report.

Company Selection

The report is run for the company you are logged into if no selection is made.

If you select:

A company, the report is always run for that company even if you are logged into a different company at the time.
Multiple companies and select the option below, the report is available for just those companies.

Limit Report availability to Companies specified

Select this option to only run the report for the companies that you select in the table on the form.

Advanced

Click this button to change the style or column format applied to a specific column and row combination.

You can:

Display quantity rather than value for a specific column and row.
Make the total column on a percentage line blank.
Change colour or background colour on a total variance row and column.

All references are to a specific column and row number, so you should have those open in another form or document while you are working.

Note: Companies being consolidated also require the same budgets.

Excel Options

Excel Header - Select the header to use if this report is exported to Excel.
Excel Footer - Select the footer to use if this report is exported to Excel.
Naming - Type the form name to use if this report is output in a combined workbook. If you don't type anything the report description is used.
{AccountGroup}, {TranTree}, {CompanyName} are available.

Page Setup

Orientation - Select the default orientation for the report when exported to Excel.
Scaling - Select an option to specify either the percentage scale or the default number of pages in Excel when the report is printed.
Adjust to - Enter the percentage of normal size the report defaults to when exported to Excel.
Fit to - Enter the number of width and height that the report defaults to when exported to Excel.
Paper Size - Select the paper size to use when printing this report.

General

Output calculations - Select this option to view the calculation in Excel. This applies to total rows.
Output report notes - Select this option to include notes that have been added to the report included in Excel as cell comments.
Lock spreadsheet - Select this option to lock the spreadsheet. There is no password.
Output Report - Select one of:
- Detail - The report includes all detailed general ledger account balances under the tree branches.
- Summary - The report only includes the top level trees specified on the Row Maintenance form.
- Summary Expanded Trees - The report includes top and lower level tree branches but no account details

Email Recipients

Select the WebView users who can receive emailed reports.