Lines in Financial Reports
Lines in Financial Reports
In section Lines you can enter names of individual lines in financial report as well as formulas by using which you can calculate them.
Section can be accessed from menu Settings | Financials | Financial Reports.
Enter corresponding data directly into lines or in the bottom two windows.
|
Line
|
Here is displayed the consecutive number of a line in financial report. 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 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 financial report to be used exclusively in calculations, leave this field unchecked.
|
|
Date 2
|
If checked, other date set (start and end dates) will be used in calculation of financial report line as with other lines (see Displaying Financial Report - Date 2). The checkbox works only in lines where in formulas occur account values (e.g. #K760%"). You cannot use it (that is, it does not have any effect) for lines where there is reference to some other line in financial report (e.g.. #A51#). See Using Second Date in Displaying Financial Reports.
|
|
Bold
|
If checked, displays is bold.
|
|
Formula 1
|
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 topic on formulas, to calculated data in financial reports.
For a more detailed formula description see Formulas Used in Financial Reports topic.
|
|
|
Formula 2
|
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 are 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 tests the entered formula.
|
|
(Note)
|
The window for entering notes that can be found in the bottom section.
|