| # Consolidated Statement Account Factors by Column (tffst1126m000) Use this session to maintain factors. Related topics Create statement layouts Consolidated Statement The number of the consolidated statement in which you want to multiply the values of the statement accounts in a specific column by a certain factor. Statement Column The number of the statement column in which you want to multiply the values of the statement accounts by a certain factor. Sequence Number The sequence number allows you to select several ranges of statement accounts in a specific statement column. Example For consolidated statement 100 you have defined column A. You have also defined a number of statement accounts:
Statement Acc. | Amount | Statement Acc. | Amount
1100 | 4,500 | 1600 | 7,345
1200 | 5,337 | 1700 | 3,224
1300 | 1,195 | 1800 | 817
1400 | 416 | 1900 | 5,136
1500 | 8,992 | 2000 | 80
You now want to multiply the amounts of statement accounts 1100, 1200, 1300, 1700 and 1800 by 1.3 To accomplish this, you must enter the following data
Consolidated statement | 100 | 100
Statement column | A | A
Sequence number | 1 | 2
From statement account | 1100 | 1700
To statement account | 1300 | 1800
Multiplication factor | 1.3 | 1.3
The statement will contain the following data:
| Column A
1100 | 5,850
1200 | 6,938
1300 | 1,554
1400 | 416
1500 | 8,992
1600 | 7,345
1700 | 4,191
1800 | 1,862
1900 | 5,136
2000 | 80
Statement Account From The number of the first statement account in the range. Statement Account To The number of the last statement account in the range. Factor Absolute figure by which the values of a specific consolidated statement column are multiplied. This may, for example, give you insight into expected financial figures. Factors can also be used to express statement values in other currencies. Increase Sequence Number Increases the value of the Sequence Number field by one. Decrease Sequence Number Decreases the value of the Sequence Number field by one. Renumber Sequence Numbers Renumbers the values of all Sequence Number fields. |