Manually Defining a Line Layout 
You can define a line layout manually within Totals Reports Definition under Extras
®
Line layout
®
Maintain. The initial entries on the overview screen are each defined in their respective detail screen. If the line layout already exists, you can branch right into maintenance with the Choose pushbutton.
- The line layout is identified by a four-digit, freely definable ID.
- The sequence number determines in which sequence the FS items should be output. Thus, the sequence is freely definable and does not depend on the structure of the item numbers addressed in the line layout.
- For a line containing a text, value or quantity, a valid consolidation item must be specified in the FS item field so that the texts, values or quantities belonging to the FS item can be output. The medium text for the item - stored in Item Text Maintenance - appears as a reference when you enter the item number.
- By entering the processing indicators listed below in the Line indicator field you can request certain functions:
TS |
Text line, highlighted |
TD |
Text line, normal |
WS |
Value line, highlighted |
WD |
Value line, normal |
MS |
Quantity line, highlighted |
MD |
Quantity line, normal |
=S |
Row of
=
characters, highlighted |
=D |
Row of
=
characters, normal |
-S |
Row of
-
characters, highlighted |
-D |
Row of
-
characters, normal |
.S |
Row of
.
characters, highlighted |
.D |
Row of
.
characters, normal |
Ln |
Output of
n
blank lines (where
n
= 1..9) |
NP |
Form feed (new page) |
Certain indicators in the Line indicator field require or permit the maintenance of other related fields in Line Layout Maintenance. However, no further fields are applicable when requesting separators, blank lines and form feeds.
- For value or quantity lines, you can enter a base item for calculating structure percentage rates in the Base item field. ‘Structure percentage rate’ here refers to the relationship in percent between two FS items. For example, in a balance sheet report you can print each item value’s proportion to the balance sheet total. You need not specify a base item for each FS item. It normally suffices to enter a new base item at the beginning of the line layout, or when the base value changes, because a base item remains valid until a new one occurs in the line layout.
One example of this would be the output of a summarized balance sheet and income statement in a single report form. Here, the balance sheet total would be used as a base value for the balance sheet items, and then the sales revenue for income statement items.
- The Column suppression field is very similar to the column layout rule. Column suppression is used for switching one or more columns on or off line by line. It is possible, for example, to obtain a shifted output of subtotals such as fixed assets and current assets. You could also use this method, however, to control the selective printout of structure percentage rates for certain items. In the Column suppression field, you can specify different column layouts for each value or quantity line. The line being maintained does not take into consideration any of the definitions in the column layout rule, which are assigned to a column layout, if this column layout is entered in the Column suppression field. If no column layouts are entered in this field, all definitions in the column layout rule are printed regardless of whether these column definitions were assigned to a group or not. Likewise, all column definitions that are not assigned to a column layout are taken into account for each value or quantity line.
Text lines differ from value and quantity lines in that the values for text lines, which are normally output via the report column layout, are automatically suppressed. Text lines can therefore be used as subheadings, for example at the beginning of the assets or liabilities. Of course, you can use an appropriate column control to output the item texts on value and quantity lines.
- You can invert the +/- sign line by line in the report in addition, or as an alternative to globally controlling the item value +/- sign depending on the report,. This control instrument is useful, for example, when printing a vertical income statement, where the revenue items are displayed as positive values and the expense items as negative values, contrary to the accounting definition in FS Item Maintenance. When you enter a minus sign in the +/- sign field for value or quantity items, the item value stored in the database is reversed, however entering a plus sign or blank has no effect.
- For totals items such as fixed assets, you might find it useful to show the item texts in upper case. This can be done by selecting the Upper case indicator for the respective line.