Specifying Row Properties
Financials provides options that control how rows are displayed in tables.
Prerequisites
What do you want to do?
Specifying Table Row Attributes
Procedure
- From the Table Tools tab, in the Row Properties group, click (Attributes).
- Select from the following options:
Option | Description |
---|---|
Title Row | Select to make the row a title row. The style applied to the row will change and the numeric cells will hide for the row. |
Switch Sign | Select to display sign for a table row is to be switched. This means that a balance of 20 is displayed as -20, and vice versa. A icon appears next to the row with the switched sign. |
Subtract |
Select to make the row to be subtracted rather than added. By default, all values in a subtotal or total are added. A (subtract) icon appears next to the row that is subtracted. |
Currency |
Select to display currency symbols on the first row of the table and/or the total row. In Financials, you can display a currency symbol in any row. This symbol is specified in the Global Setup tab. |
Keep Cell Properties |
Select to preserve row properties. For example, if the properties for a row are different from the properties defined for the cell group to which the row belongs, you can specify that these changed row properties are to be preserved. |
Allowing input override for a row
You can specify that all numeric cells in a row are to become input cells. An override indicator is displayed, and the input values will properly flow to prior year columns on year end close.
Note: The description column for a row is always an input cell. An override indicator will be displayed if the default description is changed.
Procedure
- Open the Financial statements document and select the Table Tools tab.
- In the Financial statements document, click in the row in which the numeric cells are to become input cells.
- Click (Input).
Results
The numeric cells in the selected row are now input cells.
Specifying when a row is to be printed
For any table row, you can specify that a row is to be:
- Always printed
- Never printed
- Printed if a balance exists (this is the default).
You can also select specific columns to print, or specify that a subtotal is to be printed only if more than one balance exists in the rows to be totaled.
Procedure
- Open the Financial statements document and select the Table Tools tab.
- In the Financial statements document, click in the row for which printing is to be specified.
- Click (Print). The Row Print Options dialog appears.
-
Select one of the following radio buttons:
Radio Button Description Print if there is a balance Print the row if it contains at least one non-zero balance. Print always Always print the row. Never Print Never print the row. Print if more than one balance in the sub-total Print the subtotal row if more than one of the rows that is being summed contains a non-zero balance. This radio button is available for subtotals only. - In the Printed columns pane, select the check boxes next to the columns that you want to print.
Results
The specified row print option determines when the row is printed.