GL Design Wizard

Navigator >Setup > General Ledger > Financial Report Designer > Wizard button

Use the GL Design Wizard to design financial reports. The Wizard will use selections to format a report and generate the required MaxBasic code to run the report.

The wizard will validate the GL on opening. If the GL is not valid, follow these steps:

Close the GL Financial Report Designer.
Go to Navigator > Tasks > General Ledger > Validate Ledger.
A Validation Report is produced, listing the Account Number, Name and a Description for each error in the GL. Take the necessary steps to repair the GL. Contact your QSP or Accredo Support if necessary.
Once the GL is valid, return to the GL Design Wizard.

Reports are generated using the styles selected in Report Preferences. The GL Design Wizard retrieves Heading and Total account names from the Current Account. Details for Heading accounts appear in the Iterator panel of the GL Financial Report Designer as follows:

Name – shows the Current Account Name.
Comment – shows the Current Account number used to retrieve the account name when the report is run. If you consolidate by Segment 1 or 2, Account Names and Numbers are also retrieved.

Accredo provides several samples of financial reports that can be loaded and edited. Alternatively you can create a new Report. Report definition files can be saved. The default path for GL Financial Reports is Accredo\Reports\GLFinancial, the default file type is Design Files (.pfd).


Heading Fields
Report Title		This will be inserted into the ReportTitle property of the designed report.
Report Style		Select from: Array totalling and manual ranges - totalling is based on manually specified ranges of accounts. Chart based totalling and ranges - totalling and ranges in the report are based on information in the General Ledger Chart Of Accounts.
	Load... `(Alt+L)`	Load an existing GL Report Wizard file to use for designing different reports.
	Save... `(Ctrl+S)`	Save the current wizard settings as a GL Report Wizard file. You can reload the file in the wizard to refine or create a new report.
	Generate `(F9)`	Generate a GL Report definition based on current selections in the wizard and the structure of the Chart Of Accounts. You can further refine the report and you can run a test. The wizard retains selections. You can re-open the wizard and save or change the settings. The wizard settings are also saved when you save a GL Report Design. If there are unposted or untransferred batches, this will be displayed in the header.
	Cancel `(Esc)`	Closes the wizard without saving settings or changes made since the last save, and without generating a new code in GL Financial Report Designer.

Note: When a GL Financial Report is run from the Design Wizard, the "Excluding untransferred batches" and "Excluding unposted batches" labels are always shown. When a GL Financial Report is run from Navigator > Reports > General Ledger > Financial Reports, these will only be shown if untransferred or unposted batches exist.

In This Section

GL Design Wizard - Iterators tab

GL Design Wizard - Bands tab