Lines in Financial Reports

Lines in Financial Reports

You can enter names of individual lines in financial report as well as formulas by using which you can calculate them. 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. 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 in 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.
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 fro keeping records are not included in the formula! It is once again displayed in the Formula 2 field. You can enter it optionally.
	By clicking this button tests the entered formula.
(Note)	The window for entering notes that can be found in the bottom section.

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.

In the formula, we can use the function Rounding  at the individual positions of balance. Column rounding is hidden by default on financial report template and should be added to the individual financial report via a right mouse click. This function works only in formulas that do not refer to other cells.