Include Nil Balance Accounts

Selected, accounts with all financial fields as zero will be included in the report.

Clear, these accounts are omitted.

This sets the state for the IncludeNilBalances variable in the BeforeReport code.

Amount Decimals, Percent Decimals

Enter the decimal accuracy for financial and percentage fields.

Retain Existing Bands

Select to retain bands that are already in the GL Report Designer after the GL Design Wizard has run. If you have already entered or changed MaxBasic code in the GL Report Designer and you want to generate iterators using the GL Design Wizard, this prevents unwanted changes to bands.

Include Array Based Total Code

Selected, the Array Based Total code will be available in the GL Financial Report Designer. Only select this if you intend to make extensive modifications to the report generated by the Wizard. You will require the array based totalling code to do this. Defaults to Clear.

Page Orientation

Select from:

• Automatic
• Portrait
• Landscape

Automatic will choose the optimal orientation. based on fitting columns on the page with a readable font size.

Default Font

The default font for the report, loaded from and saved to Report Properties. Font sizes are calculated as the report is generated.

Report columns grid

Contents

Specify content for a field on the report. You can choose values from the Lookup . See GL Design Wizard Band Contents Fields.

Label

Enter a heading that will print at the top of the column on the report. A number of label characters convert to MaxBasic functions, for example:

• Period|Activity will wrap ‘Activity’ to the next line.
• %PeriodName% will fetch the correct name for the period.

Width

The column width on the report. The width shown in the grid is measured as a number of 0 characters, the same way the column width on report layouts is measured. This is translated into millimetres when the report is generated.

Code Only

Makes the code used to calculate the field available to the report without including the result as a field on the report. The calculation will be available in the BeforeBand code in the GL Financial Report Designer. You can use it as a raw figure for other calculations, for example, to calculate the balance for a period as a percentage of the budget.

Budget

Select the budget for the field.

Branch

Dept

Use Branch and Department to design cross tab (across the page) style reports, specifying branch and / or department codes per field. If you select a branch and / or department in the grid, you must consolidate branches and / or departments. The Wizard will select the relevant consolidation box(es) on the Iterators tab.

Ranges, comma separated values, and wild card characters * and ? may be used. (Accredo Saturn Only)