The structure designer has two views, the Tree controlview and the line view.

If you select the Tree controlcheck box, the row definitions are presented in a tree structure. You can drag basic elements to the tree structure when you design the financial statement.

When you double-click a row type in the tree structure or click the Editicon, the system switches between the edit mode and a list of values that you can select.

If you clear the Tree controlcheck box, you enter the line mode of the structure designer, and you can create the structure of the financial statement as follows: Press CTRL+N to add a line, and enter values in the Row nameand a Print nametext boxes. Select a value in the Typefield for the row. In the line mode, you can create rows of any type, such as Element, Group, Structure, Calculationand Exception.

The following procedures describe how to create various types of row lines in the tree structure.

1. In the right pane of the Structure designerform, view the accounts or the dimension values that are part of the main focus that you selected for the financial statement row definition.

   Accounts are displayed on the Accountstab and dimension values on the Dimensiontab. If the focus of the row definition contains more than one dimension type, you can change the dimension type in the Dimensionfield.

2. Select the ledger accounts or dimension values that you want to use in the right pane and drag them to the item in the tree structure (left pane) that contains them.

   You can also use other methods to add rows to the row structure in the left pane:

   • Right-click on the row above the position where you want the new row to be placed; click Create.

   • Click the Newicon, or press CTRL +N and move the cursor downwards to see the new row.

   • Place the cursor at the place in the tree where you want to insert an element, and then double-click on a row in the right pane.

3. When you work in the tree control view, you select and format individual lines in the left pane. To edit a line in the tree structure, double-click it, or click the Editicon. A new set of tabs appears in the right pane.

4. On the Generaltab in the right pane, you can enter a name and description that are used internally in the structure designer, as well as the name and description that are printed on the financial statement report.

   You can use placeholders (for example, %NAME or %DESCR) in the Print nameand Print descriptionfields to create rows in the generated financial statement for all elements that fit the placeholder requirements.

5. On the Setuptab, enter various kinds of information according to the value in the Typefield.

   For example, select Debitor Creditin the Debit/Creditdrop-down list. An account that has a credit balance will show zero if the row settings is set to Debit.

   Or, select the Headeror Subtotalcheck boxes to print a header, its sublevels, and then a subtotal rolling up the sub-level figures.

   Note
   Use expressions to generate multiple authorized values. Write an expression such as p* in the Valuefield. p* means that all departments starting with a p are listed in the tree structure. Select the Simulatecheck box to expand the row definition nodes in the tree structure.

6. On the Special reporttab, define how the line will be formatted and in which column field the row value will be shown in the financial statement. For more information, see the field descriptions in Structure designer (form).

7. To reuse an existing row definition, make sure that you are not in the edit mode by double-clicking the row definition in the tree structure area. When the list of values is presented in the pane on the Dimensionstab, click the Structurestab, and drag the row definitions that you want to reuse. In this way, you create nodes of the type Structuredescribed later in this topic.

8. If you do not want to reuse the whole row definition, double-click the reusable row definition in the tree structure to activate the edit mode. On the Setuptab, select a specific part of the row definition that will be used in the new row definition in the Branchfield.

   Note
   You cannot change the value in the Typefield after the row definition line is created.

1. In the left pane of the Structure designerform, position the cursor where you want to insert a group row line, and click the Createicon. A group row line could be a header for a group of accounts or dimension values.

2. In the right pane, in the Typefield, select Group. Complete the Row nameand Row descriptionfields.

3. Drag the row line to its proper position in the tree structure.

4. To format the lines of a single row in the tree structure, select the row, and then click Edit. In the right pane, new tabs appear. On the Setuptab, select how you want the row to be formatted in the financial statement.

   Note

   If you clear the Tree controlcheck box, you can view, create, and format all the lines within a specific group on a grid structure. Select the group row for which you want to create or format the component rows, and click Sub-branches. You can create the rows that together define the group, or you can format all the rows in a consistent manner, by selecting and clearing the fields on each line that otherwise in the tree control view appear on the Setuptab. When you create a sub-branch, you cannot return to the Tree controlview. The parent branch is noted at the bottom of the grid form. Return to the parent level by closing the Structure designerform for the sub-branch. From the top-level parent branch, you can return to the Tree controlview as appropriate.

Use the steps below to create row lines of the type Structurethat links to branches in another row definition.

1. In the left pane of the Structure designerform, position the cursor where you want to insert a structure row line and click the Createicon. Row lines of type Structurelink to branches in another row definition. They enable you to reuse substructures that you have already set up for other financial statements. For example, you can reuse the row structure that presents the income statement when you are preparing a cash flow statement.

2. In the Typefield, select Structure. Complete the Row nameand Row descriptionfields.

3. On the Setuptab, select another row definition in the Row definitionfield and link to a certain branch of the selected row definition in the Branchfield.

   Note
   You can reuse row definitions with the row type Structure.

1. In the left pane of the Structure designerform, position the cursor where you want to insert a calculation row line and click the Createicon.

   Calculation rows are usually created last because they use the position of other lines in their definition.

2. In the Typefield, select Calculation. Complete the Row nameand Row descriptionfields.

   Drag row definition nodes from the tree structure pane to the grid area in Arguments availablesection on the Setuptab, and then write the expression in the Calculation expressionfield.

   For example, if you have added two row definition nodes and write a + operator in the Calculation expressionfield, the sum of the two row definition nodes is added to the printout of the financial statement.

Use the steps below to create row lines of the type Exceptionto print inconsistencies in the tree structure like missing and duplicate lines.

1. In the left pane of the Structure designerform, position the cursor where you want to insert an exception row line, preferably at the end of the tree structure, and click the Createicon.

2. In the Typefield, select Exception. Complete the Row nameand Row descriptionfields.

3. On the Setup, select the exception type in the Exception typefield. For example, a financial statement with an exception type value Duplicatelists element value combinations whose balances are present several times in the financial statement.

1. When the basic structure of the row definition is in place, complete the Setuptab next to the Exceptiontab.

   Note
   If you want to format the rows quickly, clear the Tree controlcheck box at the top of the form. In a grid structure, you can now view and edit the formatting of each row. You can also build the row structure in the line view.

2. Before you update the structure make sure that there are no errors and duplicates. Click the Simulatecheck box to explode the tree structure into all the actual values.

   To look for duplicates, click the Checkcheck box, and then click the Simulatecheck box. A search is performed for duplicates, which are marked with a specific icon. Both icons are displayed to make it possible to go to the next or previous error.

   Note
   In simulation mode the Structure designerform is not editable.

When the row definition structure is complete, you can prepare, view, and print a financial statement in General ledger> Reports> Transactions> Periodic> Financial statement .