• Table Tools
  • Do-It-Yourself versus non-Do-It-Yourself tables
  • Specifying Row Properties
  • Financial Statements - Editing Tables
  • Financial Statements - Working with Do-it-Yourself Tables
  • Specifying Table Print Options in the Financial Statements
  • Financial Statements - Working with Table Linkages

Specifying Row Properties

Financials provides options that control how rows are displayed in tables.

What do you want to do?

• Specifying row attributes
• Allowing input override for a row
• Specifying when a row is to be printed

---

Specifying Table Row Attributes

Procedure

1. From the Table Tools tab, in the Row Properties group, click (Attributes).
2. 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

1. Open the Financial statements document and select the Table Tools tab.
2. In the Financial statements document, click in the row in which the numeric cells are to become input cells.
3. 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

1. Open the Financial statements document and select the Table Tools tab.
2. In the Financial statements document, click in the row for which printing is to be specified.
3. Click (Print). The Row Print Options dialog appears.

4. 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.

5. 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.