Row Maintenance

---

Use this form to specify what to display vertically on the report. You must have set up relevant trees on the Tree Maintenance form and allocated accounts to them on the GL Account Tree Maintenance form before defining your report rows.

If you select the Transpose option on the Report Maintenance form, this can become the column format and go across the page rather than rows down the page.

There are five types of rows:

• Comment - This is text to appear in the report row. This is primarily used for headings.
• Tree - This is a detailed line that contains values; it must relate back to a standard tree and branch.
• Total - This is used to sum detailed lines. You can also include some minor calculations, such as dividing or multiplying by a constant value. For example, to calculate expenses as a percentage of sales.
• Account - This is a detailed line that contains values. You specify the account numbers to include, wildcards are available.
• Account Type - This is a detailed line that contains values; it sums the value of all accounts of a specific type.

The Row Maintenance form contains a number of options.

Code

Enter a name for the row structure, up to 30 alphanumeric characters.

Description

Enter an extended description for the row structure.

Tree

Select the general ledger account tree used to report rows of type Tree.

Note: Once selected, the tree becomes read-only. If you have selected the wrong tree, you must create a new row maintenance.

Default Style

Select a style to default to new rows as they are added. This can be overridden by selecting a style at the row level.

In Development

If a row is used in published reports, you must set it to In development to make changes. All existing published reports using the row format are deleted. If you don't want to delete existing published reports, you must copy the row format and create a one.

Active

Select this option if this row format can be used in designing new financial reports.

Entering Rows

Row No

Enter a manual number to determine the order in which the rows displays using WebView. Leave gaps in your numbering so that you can add new rows between existing ones if necessary .

Line Type

Specify whether the row is a Comment, Tree, Account, Account Type, or Total row. The selection determines what additional information you must specify for the row.

Comment Row

Enter this to support a comment row:

Style

Select the style format to apply to the comment. If there is a conflicting style on a column it takes precedence.

Caption

Enter the text (or space if applicable) to print on the comment line.

Note: The text does not wrap around and you cannot force a new line by pressing CTRL-Enter. You can create two comment lines to print a heading or comment that extends beyond the web page width.

Calc/Branch/Account/Type

This is not applicable for a comment row.

TCode

Not applicable for a comment row.

Tree Row

A tree row is used to add figures or values to your report. The tree must relate back to the GL account tree selected on the main form.

Style

Select the style format to apply to report values. If there is a conflicting style on a column it takes precedence.

Caption

Enter any text to appear on the row. This identifies the value that is being displayed in the row about the selected tree branch. If you don't type anything it uses the branch name.

Calc/Branch/Account/Type

Double-click to select a tree branch. Pressing Enter selects the highlighted branch, and pressing the Tab key selects the branch lined up on the row. To move back up a level, press Shift+Enter.

TCode

Enter a Transaction analysis tree short code value if you want this row to only display for a specific code

Account Row

Enter this to support an account row:

Style

Select the style format to apply to the account. If there is a conflicting style on a column it takes precedence.

Caption

Enter the text to print on the row. This identifies the account.

Calc/Branch/Account/Type

Enter the characters for your general ledger account or range of accounts. To choose all values for a particular segment, use an asterisk.

To select all values for one position within a segment, use a ?. For example, 10.*.* returns all accounts with 10 in the first segment. 10.*.1?? returns all accounts with 10 in the first segment and those if the last segment begins with a 1.

TCode

Enter a transaction code to only display for a specific code.

Account Type Row

Enter this to support an account type row:

Style

Select the style format to apply to the account type. If there is a conflicting style on a column it takes precedence.

Caption

Enter the text to print on the row. This identifies the account type.

Calc/Branch/Account/Type

Select the type of account to display — for example, Income, Expense.

TCode

Enter a Transaction analysis tree short code if you want this row to only display for a specific code

Total Row

Enter this to support a total row:

Style

Select the style format to apply to the report total value. If there is a conflicting style on a column it takes precedence.

Caption

Enter any text to appear on the row, to represent the total.

Calc/Branch/Account/Type

Enter the detail of what is to be totaled or calculated. You can use the four standard numeric operators (+, -, * and /, and brackets) to indicate the order in which calculations are performed.

A calculation can see a specific row and column value. For example, C30/C20R10 would use the value from the cell of row 10 and column 20. This can be useful when you are trying to display a value per quantity for example, if you have kilometers display on one row then to calculate the spend per kilometer.

Note:You cannot add up a range of rows. You must add each one to the formula.

Alternative Column Format

If a column format is specified here, the row displays using this format instead of the one defined at the report level. You can use this if one row in a report is to display quantities or year to date values while the rest of the report is monthly values.

The column format must have the same number of columns as the main one used for the report for example, if the main column format has six columns and you specify an alternate format with eight columns, only the first six would display.

Visible

Use this option to specify rows to use for calculations, without actually displaying them on the report.

Reverse Sign?

Select this option to reverse the sign on the values displayed, this applies to both positive and negative numbers.

• Tree Maintenance
• GL Account Tree Maintenance
• Report Maintenance
• GL Account Tree

---