| # To set up the statement account structure If you are setting up the statement account structure, you must take a few factors into account: Number of levels Like in ledger accounts structures, you can use parent-child relations in a statement account structure. Statement account structures are similar to ledger accounts structures: A maximum of 99 levels. Level 0 is used for values, and all higher levels are used for totalizing. However, in the interim tables of FST, the maximum number of levels is 15: one child level, and 14 parent levels. This number of levels is in many cases sufficient when copying the statement account structure to the FST interim tables. The parent levels are mostly not fully used in Finance, so in fact, only a limited number of levels (5, 10, 15, and so on) exist. Therefore, Finance parent-child structures can be usally copied without any problems to the 15 levels in the FST interim tables. If more than 15 levels exist, you must adjust the statement account structure so that the structure has no more than 15 levels. Use of dummy statement accounts to get correct level codes To set up a statement account structure, you can use parent-child relations. In such a structure, one parent can have several children. However, the parent does not need to be every child's direct parent. The parent can be on the level directly above the child, but there can also be one or more extra levels between the parent and the child. In the example below, 'Total Fixed Assets' is the direct parent of 'Cars'. 'Total Fixed Assets' is also a parent of 'Offices' and 'Warehouses', but there is another parent in between, namely 'Buildings'. If the statement account structure is exported to the FST reporting tables, the parent 'Total Fixed Assets' is on level Lv02 for the children 'Offices' and 'Warehouses', and on level Lv01 for the child 'Cars'. If you create a report using an external report writer, and you want to use the parent 'Total Fixed Assets' to totalize the financial values of the children 'Offices', 'Warehouses', and 'Cars', a problem occurs. Since 'Total Fixed Assets' is stored with different level codes (Lv01 and Lv02), the external report writer does not know whether to totalize Lv01 or Lv02. To prevent this problem, you must use dummy statement accounts when setting up the statement account structure. In the example below, a dummy statement account 'Total Cars' is included as an extra level between the parent 'Total Fixed Assets' and the child 'Cars'. If the statement account structure is copied to the FST reporting tables, the dummy statement account makes sure that the parent 'Total Fixed Assets' is on the correct level (Lv02). If an external report writer now uses 'Total Fixed Assets' to totalize financial values, 'Offices' and 'Warehouses' as well as 'Cars' are taken into account. Related topics Financial statements – overview Ledger account and dimension structure To use dimensions |