| # Statement Layouts (tffst0110m000) Use this session to define and maintain statement layouts. Related topics Creating statement layouts Layout Definition Layout Type Three layout types exist. Select one of the following: Statement Annexure Consolidated Layout Statement layouts determine the general presentation of financial statements. This includes margins, header data of columns and accounts, header and footer texts, etc. This data is used to create financial statements. LN will order the statement data according to the parameters corresponding with the layout code selected. Status The status of the statement layout. This can be one of the following: Modified Report Generated Generation Error Fixed Note This field is only available if the status is Report Generated or Fixed. Convert Statement Report to RPT If this check box is selected, LN converts the statement report to a BIRT-compatible format. Note To use the BIRT template, in the Print Financial Statement Values (tffst1450m000) session, select "RPT" as the printing device. Layout Size Font The font size to be used. Type of Font Page Width The maximum number of characters per statement line. Note The value that you can enter in this field depends on the selection you made in the Font field. Top Margin The top margin determines the number of blank lines at the top of each page. Bottom Margin The bottom margin indicates how many lines must be left blank at the bottom of each page. Left Margin The left margin determines the number of blank column positions on the left side of the pages. Column Definition Column Separator The character used to separate columns. Number of Column Header Lines The column header lines contain the descriptions of the statement columns. Enter the number of lines to be reserved for the column header texts.The minimum value to be entered is "0" (zero), which means that there will be no header lines. The maximum number of lines is 3. Line before Column Header The contents of the line preceding the column header lines containing the column description. Type of Line Line after Column Header The contents of the line following the column header lines containing the column description. Type of Line Position of Statement Account The column position for the header of the column containing the statement account code. Note If you enter "0" (zero), no column will be printed. Column Header Statement Account The text for the column header. Position of Statement Account Description The column position for the header of the column containing the statement account description. Note If you enter "0" (zero), no column will be printed. Column Header Statement Account Description The name for the header of the column containing the statement account description. Text Handling Position of Account Text The column position at which LN will print the first character of the account texts linked to statement accounts. Example Font set to Medium Page Width: 94 The statement will be printed in A4 size. If you enter 40 in this field, in each line 54 positions remain available for text linked to statement accounts. Note If you leave this field empty, LN will not generate any account texts when creating the statement. Line before Account Text The contents of the line preceding the lines containing account texts linked to statement accounts. Type of Line Line after Account Text The contents of the line following the lines containing account texts linked to statement accounts. Type of Line Print Adjustment Transaction Specified If this check box is selected, adjustment transactions will be included in the statement. These transactions will be inserted after the line containing the statement account concerned (the corresponding value will be the adjusted amount). Example Account X containing an amount of 100 and an adjustment transaction of 50 debit. Check box selected:
Column A
Account X | 150 (INCLUDING Adjustment Transaction)
Text | 50
Check box cleared:
Column A
Account X | 150
Text for Adjustment Transaction The text linked to the adjustment transactions to be printed in the statement. Position Carry Forward Text The position at which LN will print the first character of the text linked to carry forward totals. Example Font set to Medium Page Width: 94 The statement will be printed in A4 size. If you enter 40 in this field, in each line 54 positions remain available for text linked to carry forward totals. Note If you leave this field empty, LN will not generate any carry forward totals when creating the statement. Carry Forward Text The carry forward text is printed with the subtotals of each page. Position Grand Total Text The column position at which LN will print the first character of texts linked to grand totals. Example Font set to Medium Page Width: 94 The statement will be printed in A4 size. If you enter 40 in this field, in each line 54 positions remain available for text linked to grand totals. Note If you leave this field empty, LN will not generate any grand total text when creating the statement. Grand Total Text The text that is printed with the grand totals of a statement. Line before Grand Total The contents of the line preceding the lines containing grand totals. Type of Line Line after Grand Total The contents of the line following the lines containing grand totals. Type of Line Header If this check box is selected, a header text will be printed on the top of each page. Line after Header The contents of the line following the header. Type of Line Footer If this check box is selected, a footer text will be printed on the bottom of each page. Line before Footer The contents of the line preceding the footer. Type of Line Problem Texts Problem Text for Division by zero The text to be included in the statement if, during generation of that statement, any value (defined in the Formula field of the Statement Columns (tffst1105m000) session) must be divided by zero. In that case no value can be printed; and the text defined here is then printed at this position. Problem Text for Out of Selection The text to be included in the statement if a value in a column does not match the criteria defined for this column in one of the following fields in the Statement Columns (tffst1105m000) session: Value Selection before Rounding, Value Selection after Rounding. Problem Text for Missing 100% Account The text to be included in the statement if a column does not contain a 100% account. In that case, LN cannot calculate any values on the basis of the column mentioned above. To indicate that a specific account is a 100% account, use the 100 Percent Column for Perc. Calc. field in the Statement Columns (tffst1105m000) session. Note This text can only be included if, for the columns concerned, you selected Percentage over Accounts in the Column Type field in the Statement Columns (tffst1105m000) session. This text will also be printed in the comparative column (Column 2), if any problem text is printed instead of the 100% account value. Column 2 is the column in which the comparative percentages are displayed. These percentages are calculated by comparing the Column 1 amounts with the 100% account value. Example
Column 1 |  | Column 2
A 100 |  | A No 100% Acc
B 200 |  | B No 100% Acc
C 300 |  | C No 100% Acc
D 400 |  | D No 100% Acc
E 500 |  | E No 100% Acc
F 600 |  | F No 100% Acc
Problem Text for No Column 1 Amount The text to be included in the statement if, instead of the column 1 value, a problem text is displayed. This text can only be included if, for the columns concerned, in the Statement Columns (tffst1105m000) session, in the Column Type field, you selected one of the following options: Percentage over Accounts Percentage over Columns Note This text is not printed if the column 1 value has been defined as a 100% account. In that case, the text defined in the Problem Text for Missing 100% Account field is printed. Example Column 2 is the 100% column. Column 3 contains the comparative percentages. Problem Text for Division by zero: Division 0 Problem Text for Out of Selection: Out of Sel. Problem Text for No Column 1 Amount: No Am. Col 1 Problem Text for No 100% Column Amount: No 100% Am.
Column 1 |  | Column 2 |  | Column 3
A 100 |  | A Division 0 |  | A No 100% Am.
B 200 |  | B 400 |  | B 50.0
C Division 0 |  | C 200 |  | C No Am. Col 1
D 500 |  | D 300 |  | D 166.7
E 600 |  | E 800 |  | E 75.0
F 600 |  | F 700 |  | F 114.3
G Out of Sel. |  | G 1200 |  | G No Am. Col 1
H 1000 |  | H 1320 |  | H 75.6
Problem Text for No 100% Column Amount The text to be included in the statement if, instead of the 100% column value, a problem text is displayed. Note This text can only be included if, for the accounts concerned, in the Statement Columns (tffst1105m000) session, in the Column Type field, you selected Percentage over Columns. Example Column 2 is the 100% column. Column 3 contains the comparative percentages. Problem Text for Division by zero: Division 0 Problem Text for No 100% Column Amount: No 100% Am.
Column 1 |  | Column 2 |  | Column 3
A 60 |  | A 100 |  | A 80
B 120 |  | B 110 |  | B 109.1
C 60 |  | C 62 |  | C 96.8
D 105 |  | D 120 |  | D 87.5
E 170 |  | E Division 0 |  | E No 100% Am.
F 140 |  | F 100 |  | F 77.8
G 110 |  | G 135 |  | G 81.5
H 55 |  | H 34 |  | H 161.8
Details Starts the Statement Layouts (tffst0110m000) details session. Generate Report Generates a statement layout based on the data entered in this session. Note To generate a report, you must have development rights and the appropriate package VRC set in the Change Current Package VRC of User (ttadv0140m000) session. Print Dummy Statement Layout Starts the Print Dummy Statement Layout (tffst0410m100) session. This command is only available after the statement has been generated, or when its status is Fixed. Print Statement Layout Starts the Print Statement Layout (tffst0410m000) session. |