Iterator panel

The iterator panel determines the accounts and reporting bands. The panel has the following fields:

Line No

Iterators are numbered sequentially. Use Go to Line to move to a specific iterator.

Name

The iterator name. This is referred to in the report band as Iterator.Name. This is often used to store the Account Name.

Comment

This is referred to in the report band as Iterator.Comment. This can be used to document the iterator purpose, or include headings, consolidated names and totalled groups of accounts. It can also be used to show the Account Number.

Branch

Specify the Branch or Branches if required. Ranges, comma separated values, and wildcard characters * and ? may be used.

(Accredo Saturn Only)

Department

Specify Department if required. Ranges, comma separated values, and wildcard characters * and ? may be used. (Accredo Saturn Only)

Segment 1 Segment2

Specify ranges for accounts and sub-accounts to be included for this Iterator line. You can specify a range as:

Value1[-Value2]

Segment1 refers to the main account number, which is the first 4 digits of the account number. Segment2 refers to the sub-account number, which is the last 3 digits of the account number.

An asterisk (*) can be used as a wild card to specify all accounts or sub-accounts. An at symbol (@) can be used to specify all accounts adding directly to a total account. A double at (@@) can be used to specify all accounts adding directly and indirectly to a total account.

For example:

If no Branch, Department, (Accredo Saturn) Segment 1 or 2 is specified, the Iterator line will be output once. This is useful for adding headings to the financial reports.

Sort By

Branch, Department (Accredo Saturn) and Segments, (B, D, 1, 2) to use as the primary sort key. For example, if you enter "1,2" accounts are sorted by the main account number (Segment 1) followed by the sub-account number (Segment 2). Accredo Saturn Only: For example, if you enter "1, B" accounts are sorted by the main account number (Segment 1) followed by the Branch.

Consolidate By

Branch, Department, (Accredo Saturn) Segments and Totals (B, D, 1, 2, T) to consolidate by. If no value is entered, accounts will be not be consolidated. For Accredo Saturn: For example, if you enter B, all Branches will be consolidated, if you enter B, D then all Branches and Departments will be consolidated. You can consolidate over main accounts (Segment 1) or over sub-accounts (Segment 2). You can also use T to total at the other consolidation levels specified, then Alternate and Total the results, rather than just Totalling per consolidation level.

Note: If you consolidate by Segment 2 over a set of accounts which share Segment 1 but don’t all alternate to Accounts which total to the same total account, Accredo will not do alternation for those accounts because the totalling will not have sensible results. If all accounts which share Segment 1 are set up to alternate to accounts which total to the same total then Accredo will alternate. Any alternation happens before consolidation on Segment 2.

Selection

You can add a filter or enter a MaxBasic Expression to determine accounts included in the selected range. If this is blank, all accounts will be included. If a Selection is entered, accounts will be included if the selection expression returns the value True for the accounts. Type the expression or click Open Code Editor (F2) to build an expression using Edit Selection Expression.

Note: The GLACCT fields available to the filter are limited to those included in the GL Report Designer Account object.

Band

Select a band to include the iterator. You can right-click or press Shift+F10 to show the context menu, which includes an option to go to the band.

Sign

An optional Debit or Credit specifier on the iterator. In the band, you can access the Debit or Credit field of an account as Account.Sign (Debit = +1, Credit = -1). The additional Sign field on the iterator is useful when no accounts are specified in the range or when the accounts can include both debit and credit accounts. This allows a single band to deal with the sign correctly for both Debits and Credits.

Class

Select the account type from Income, Expense, Capital, Asset or Liability. Income, Expense and Capital accounts have a FavSign used in variance calculations of -1. Asset and Liability account have a FavSign of +1.

Level

A positive number, used as a total level indicator. This allows a single total band to function with different levels of totalling. It is referred to in the report band as Iterator.Level.

Iterator.Level can be used for alternate accounts when using report totalling.

ExNull

Selected, null values are excluded.

Clear, null values will be included.

Iterator Toolbar

Insert (F4)

Insert a line to add a new iterator.

Duplicate (Shift+F4)

Duplicates the selected report.

Move (Shift+Up) (Shift+Down)

Select an Iterator and move it higher or lower on the list.

Delete (F3)

Deletes the selected Iterator.

Print (Ctrl+P)

Print a list of all Iterators.

Customise (Alt+F5)

Opens Customise Fields, you can customise the fields visible in the grid.

Go to Line ... (Ctrl+G)

Prompts for the Iterator Line to go to.