In the process of creating a financial statement, you designed the row structure of the statement, as described in Design the row structure of a financial statement. Now you can design the rows and columns of the financial statement.

Set up the rows

  1. Click > > > .

  2. In the upper pane, press CTRL + N, if necessary, to create a line for the financial statement.

    Note Note

    For more information about the fields that are mentioned in this topic, press F1 in the form.

  3. In the text box, enter a unique identifier for the financial statement.

  4. In the text box, enter a descriptive name for the financial statement.

  5. In the lookup field, select the main row pattern that you want to use in the statement.

  6. To use a secondary row pattern, select a focus in the lookup field.

  7. To insert a page break after all the rows that are created for a particular focus are presented, select the check box.

  8. On the tab, select the row definition(s).

    Select the row definition for the main focus and, if you defined a secondary focus, select the row definition for this focus.

    The focus and row definition combinations determine what is printed on the financial statement:

    • Main focus without a row definition: Prints the focus elements sorted according to the order of rows in the dimension set that is chosen as the main focus.

    • Main focus and secondary focus without a row definition to the main focus: Prints the elements detailed per secondary focus elements.

    • Main focus with a row definition and secondary focus: Prints the main focus element values according to the row definition detailed per secondary focus.

    • Main focus with a row definition and secondary focus with a row definition: Prints a main focus row definition combining the components of the main and secondary focuses according to the row definition for the secondary focus elements. The secondary focus row definition repeats on each occurrence of main focus element values.

  9. In the fields on the right, define the print settings for the financial statement and the default settings for what details and elements to print on the financial statement.

Set up the columns

Each column is defined by a column type. Some column types are for naming purposes only, such as ; some are for presentation of transaction account balances, such as , and some are for calculation purposes, such as . Therefore, many fields are available for input according to your selection in the field.

Note Note

When you set up a cash flow statement that uses the cash flow row definition, the first column is typically the name of the row that is included in the cash flow statement. The second column is typically the period for which you are creating the cash flow statement.

  1. Click > > > .

  2. In the upper pane, select the financial statement for which you want to create columns.

  3. In the lower pane, press CTRL+N to create a line for the first column in the report. A column number is automatically assigned in the field.

  4. In the field, enter the name for the column. This will appear as a header for the column in the financial statement.

  5. In the drop-down list, select the type of column. If your main focus is Department, for example, the first column might be named Focus for the column type , the second column Focus name for the column type , and the third column Secondary focus for the column type , and so forth.

  6. Create the non-calculation/non-transaction column types that you need and order them as necessary using the and buttons.

  7. Create transaction column types. To specify account and dimension criteria for the selected column, click the button.

  8. Enter the necessary information on the , , and tabs.

  9. You can now create the calculation column types. Select, for example, to print a column that displays the difference between the realized ledger transactions in and the budget transactions in .

  10. On the tab, enter the calculation expression and other calculation details.

After you set up all the rows and columns, you can generate the financial statement as described in Generate, print, and export a financial statement.

See Also