| # Statement Columns (tffst1105m000) Use this session to define and maintain statement columns. Related topics Creating statement layouts General General Financial Statement An account structure that can consist of child statement accounts and parent statement accounts. At the child level, the statement accounts are linked to ledger accounts and dimensions. With a financial statement, you can collect the desired financial values from the General Ledger and Budgeting modules, and use this data for internal and external financial reporting and analysis. Statement Column The column number. Column Details Column Description (row 1) The first line of descriptive column text. Column Description (row 2) The second line of descriptive column text. Column Description (row 3) The third line of descriptive column text. Column Type The type of column. Allowed values Amount/Quantity Amount/Quantity (Cum) Percentage over Accounts Percentage over Columns Rounding Differences Period Type Period Type Value Status to Select Value Status Formula Indicates how the values of the statement column must be calculated. The formula contains variables that are linked to statement account values. Example
    a + b - c
Where:
a | = | Opening balance
b | = | Debit amount
c | = | Credit amount
Column 1 for Percentage Calculation The number of the column used for percentage calculation. 100 Percent Column for Perc. Calc. The number of the column that contains the denominator used for percentage calculation. Rounding Rounding Rounding Indicates how the calculated value must be rounded off. Related topics Rounding Method Decimals Indicates how the value calculated for the selected statement column must be rounded off.. Note This field does not have any effect on the values printed on the annexure. The annexure contains the exact values without any rounding or reproduction. Reproduction Indicates how the amounts, calculated according to the data defined for the selected column, must be displayed in the financial statement. Allowed values Normal Thousands Millions Example The example below shows how a value will be displayed in the selected statement column, based on the following data.
Rounding | Decimals | Reproduction | Result
Normal | 2 digits after dec sign | Normal | 5756.98
Up | 2 digits after dec sign | Normal | 5756.99
Normal | On Unit | Normal | 5757
Down | 3 digits before dec sign | Normal | 5000
Down | 3 digits before dec sign | Thousands | 5
Up | 3 digits before dec sign | Normal | 6000
Normal | 3 digits before dec sign | Thousands | 6
Normal | 6 digits before dec sign | Millions | 0
Rounding Difference Column Select the appropriate column from the Statement Columns (tffst1105m000) session. Value Selection before Rounding Value Selection before Rounding If this check box is selected, you can specify one or two conditions. Operator Select the appropriate operator. Allowed values Lower Than Lower or Equal Equal To Greater Than Greater or Equal Not Applicable Value Enter a numerical value. Condition Select the appropriate condition. Allowed values And Or Operator Select the appropriate operator. Allowed values Lower Than Lower or Equal Equal To Greater Than Greater or Equal Value Enter a numerical value. Value Selection after Rounding Value Selection after Rounding If this check box is selected, you can specify one or two conditions. Operator Select the appropriate operator. Allowed values Lower Than Lower or Equal Equal To Greater Than Greater or Equal Value Enter a numerical value. Condition Select the appropriate condition. Allowed values And Or Operator Select the appropriate operator. Allowed values Lower Than Lower or Equal Equal To Greater Than Greater or Equal Value Enter a numerical value. Balancing Column Balancing Column If this check box is selected, you can specify a balancing account. Balancing Account Select the appropriate account from the Statement Accounts (tffst1520m000) session. Statement Column References Starts the Statement Column References (tffst1111m000) session. Renumber Renumbers the values of all Statement Column fields. Consolidated Account Factors by Column Starts the Consolidated Statement Account Factors by Column (tffst1126m000) session. |