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.

Code

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

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 you want when the report is generated using the scheduler.

Use Default GL Budget

Select this option to use the default GL Budget assigned in GL Module Control (where 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 GL Budget to use in the report, where 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 - A field displays, in which you 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 in General Ledger module control.

Default Report Library

Select the default report library reports will be saved to when generated.

Use Source Company Periods for Consolidation

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

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.

In Style Maintenance, turn off Allow drill Down on the Other tab if you don't want the tree detail to be 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 will be excluded.

Allow change at runtime

Ability to tick and deselect above setting at runtime - you can decide if they want the rows or not.

If the Column Format you specify includes any TCode column types, you will also see the above two fields

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

If no selection is made the report will be run for whichever company you are logged into.

If you select one specific company the report is always run for that company even if you are logged into a different company at the time.

If you select multiple companies, and select the box below, the report is available for just 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.

The results display in Microsoft Excel.

Excel Options

• Excel Header - Select the header you want to use if this report is exported to Excel.
• Excel Footer - Select the footer you want to use if this report is exported to Excel.
• Naming - Type the form name to be used 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 you want the report to default to when exported to Excel.
• Fit to - Enter the number of width and height that you want as the default when the report is 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.
• 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 will only include the top level trees as specified in row maintenance.
  • Summary Expanded Trees - The report will include top and lower level tree branches but no account details

Email Recipients

Select the WebView users who can receive emailed reports.

• Excel Header/Footers

---