Report Maintenance

Use this form to create the financial reports that WebView users can see. 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 that appear in the report when it's 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 specific 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 they want to run the report for.
Selected - Specify a date for the report. Only use this for a specific year-end report.
WebView default - Make the run date to the date specified on the General Ledger Module Control form.

Default Report Library

Select the default report library to which reports are saved 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 to not 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 or not you can drill down on the row format.

On the Style Maintenance form, deselect the Allow drill Down option on the Other tab to 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 you don't make a selection.

If you select:

A specific 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 just for those companies.

Limit Report availability to Companies specified

Select this option to only allow the report to be run 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.
Blank a total column on a percentage line.
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: The results display in Microsoft Excel.

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 to default the report to when exporting to Excel.
Fit to - Enter the default width and height for the report when you export it 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.
Output report notes - Select this option to have 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.