Lines in Financial Reports
Lines in Financial Reports
In the Lines section, you can enter names of individual lines on the financial report, as well as formulas, by using which you can calculate them.
This section can be accessed from menu Settings | Financials | Financial Reports.
Enter the corresponding data directly into the lines or in the two windows at the bottom.
|
Line
|
Here, the consecutive number of a line in a financial report is displayed. You can reference it in the formulas used in calculation.
 |
WARNING
If you change the number of financial report line (e.g. from 10 to 11) and you reference it in formulas, references change accordingly, too (e.g. from #A10# to #A11#).
|
|
|
Description
|
The text appearing in the report as the name of the line. It is once again displayed in the Name field.
|
|
ADP
|
 Link to XLS report. It is key for AJPES reports.
|
|
Show
|
If checked, the line appears in the report. If you, for example, want to define a line from a financial report to be used exclusively in calculations, leave this field unchecked.
|
|
Date 2
|
If checked, the other date set (start and end dates) will be used in calculation of the financial report line as with the other lines (see Displaying Financial Report - Date 2). The checkbox works only with the lines where account values (e.g. #K760%") occur in the formulas. You cannot use it (that is, it does not have any effect) for the lines where there is a reference to some other line in the financial report (e.g.. #A51#). See Using Second Date in Displaying Financial Reports.
|
|
Bold
|
If checked, displays is bold.
|
|
Formula 1
|
The formula used in calculating data, appearing in the report under the first column.
Accounts for keeping records are not included in the formula!
It is once again displayed in the Formula 1 field. You can enter it optionally.
 |
hint
Use any mathematical and logical operations, as described in the chapter formulas, to calculated data in financial reports.
For a more detailed formula description see the chapter Formulas Used in Financial Reports.
|
|
|
Formula 2
|
The formula used in calculating data, appearing in the report under the second column.
It is used only in case you selected Debit/Credit option in the Type box (see General). Otherwise data from the comparative period is used in calculation.
Accounts for keeping records are not included in the formula!
It is once again displayed in the Formula 2 field. You can enter it optionally.
|
|
Test formula
|
By clicking this button, the entered formula is being tested.
|
|
(Note)
|
The window for entering notes that can be found in the bottom section.
|