Verifying Formulas in Financial Reports
Verifying Formulas in Financial Reports
|
 |
 |
When verifying formulas used in financial reports (see Formula Verification) besides formula regularity checks also whether it is possible to enter such an expression. This is in further detail described in the Financial Report Formulas.
Any expression, which is not followed by the next combination of characters, is incorrect:
| In initial position |
Followed by |
|
D – debit transactions on account ina given period
K – credit transactions on account in a given period
S – absolute value of account balance in a given period = |D - C|
P - credit – debit (credit balance in a given period) = C - D
O – debit – credit (debit balance in a given period) = D - C
|
any set of characters identifying the account for example:
11%
|
|
A - value in line under column A (Formula 1)
B - value in line under column B (Formula 2)
|
any line number for example.:
10
Here it is wise to use integers only, on the other hand you cannot use wildcard characters. Otherwise when testing formula, the following error is returned (see Line number must be integers (#xx#)!).
|
| EmpNo - average number of employees in an individual year.
|
(no record) |
If one of the four characters that can be found under the first column is not used in initial formula position, the following error is returned when running test (see The first character of %s must be a transaction type or a column mark!).
Below You Can See Examples of Correct Entry:
For accounts and account groups:
- #S1200# = balance of account 1200 in a given period (absolute balance)
- #D12%# = debit transactions on accounts of group 12 in a given period
- #K0%# = credit transactions on accounts of class 0 in a given period
- #O02%# = debit – credit on accounts of group 02 in a given period (debit balance) = #D02%#-#K02%#
- #P90%# = credit – debit on accounts of group 90 in a given period (credit balance) = #K90%#-#D90%#
as well as for lines:
- #A1# - value in line 1 from column A (Formula 1)
- #B14# - value in line 14 from column B (Formula 2)
for average number of employees in a specific year:
#StDel# - average number of employees in a specific year.
Example:
Formulas can be tested in financial reports (Settings, Financials, Financial Report), where it is. In the lower windows of financial report template click the sign :
It opens a window wherewith the column Value. We enter value in this field for each variable and check the result.
