Statement Layouts (tffst0110m000)

Field Information

Layout Definition

Layout Type

Three layout types exist.

Select one of the following:

• Statement
• Annexure
• Consolidated

Layout

statement layout

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.

Enable Automatic Conversion of Statement Reports to RPT

If this check box is selected, LN converts the statement report to a format compatible for the external reporting tool.

Note: To use the external reporting tool's template, in the Print Financial Statement Values (tffst1450m000) session, select 'RPT' as the printing device.

Layout Size

Font Size

The font size to be used.

Small

If the statement is printed in A4 format, each statement line will contain a maximum of 132 characters.

Large

If the statement is printed in A4 format, each statement line will contain a maximum of 80 characters.

Medium

If the statement is printed in A4 format, each statement line will contain a maximum of 94 characters.

Character 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 Size 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.

Blank Line

LN will insert a blank line.

Line

LN will insert a line containing "---".

Double Line

LN will insert a line containing "===".

Underscore

LN will insert a line containing "___".

Graphic Line

LN will insert a graphical line.

No Line

Texts of the statement will immediately follow the item indicated.

Line after Column Header

The contents of the line following the column header lines containing the column description.

Blank Line

LN will insert a blank line.

Line

LN will insert a line containing "---".

Double Line

LN will insert a line containing "===".

Underscore

LN will insert a line containing "___".

Graphic Line

LN will insert a graphical line.

No Line

Texts of the statement will immediately follow the item indicated.

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 Size set to Medium

Character 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.

Blank Line

LN will insert a blank line.

Line

LN will insert a line containing "---".

Double Line

LN will insert a line containing "===".

Underscore

LN will insert a line containing "___".

Graphic Line

LN will insert a graphical line.

No Line

Texts of the statement will immediately follow the item indicated.

Line after Account Text

The contents of the line following the lines containing account texts linked to statement accounts.

Blank Line

LN will insert a blank line.

Line

LN will insert a line containing "---".

Double Line

LN will insert a line containing "===".

Underscore

LN will insert a line containing "___".

Graphic Line

LN will insert a graphical line.

No Line

Texts of the statement will immediately follow the item indicated.

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 Size set to Medium

Character 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 Size set to Medium

Character 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.

Blank Line

LN will insert a blank line.

Line

LN will insert a line containing "---".

Double Line

LN will insert a line containing "===".

Underscore

LN will insert a line containing "___".

Graphic Line

LN will insert a graphical line.

No Line

Texts of the statement will immediately follow the item indicated.

Line after Grand Total

The contents of the line following the lines containing grand totals.

Blank Line

LN will insert a blank line.

Line

LN will insert a line containing "---".

Double Line

LN will insert a line containing "===".

Underscore

LN will insert a line containing "___".

Graphic Line

LN will insert a graphical line.

No Line

Texts of the statement will immediately follow the item indicated.

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.

Blank Line

LN will insert a blank line.

Line

LN will insert a line containing "---".

Double Line

LN will insert a line containing "===".

Underscore

LN will insert a line containing "___".

Graphic Line

LN will insert a graphical line.

No Line

Texts of the statement will immediately follow the item indicated.

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.

Blank Line

LN will insert a blank line.

Line

LN will insert a line containing "---".

Double Line

LN will insert a line containing "===".

Underscore

LN will insert a line containing "___".

Graphic Line

LN will insert a graphical line.

No Line

Texts of the statement will immediately follow the item indicated.

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