Verifying Formulas in Posting Templates
Verifying Formulas in Posting Templates
Verifying Formulas in Posting Templates
|
 |
 |
When verifying formulas used in posting template besides formula regularity checks also whether it is possible to enter such an expression. This is in further detail described in the Lines in Posting Template topic.
Any expression, which is not followed by any of the characters, is invalid:
| first place |
second place |
Followed by |
|
R - Revaluation
S - Sum
O - Interest
|
D – debit transactions on the account in a gioven period
K – credit transactions on the 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
If expression does not begin in one of the characters stated above and at the same time is not followed by any of the characters specified, an error is returned (see Type of transactions on the account must be specified in the second part of expression #xx#!)
|
any given set of characters identifying the account, e.g.:
11%
|
| A - Line Amount |
Any line number, e.g.:
10
It is wise to ue only integers avoiding use of wildcard characters. Verifying formula returns an error (see Line number must be integers (#xx#)!).
|
|
If any of the four cahracters from the first column is not specified in the first part of the expression, the following error is returned (see Type of operation (R, S, O or A) must be specified in the first part of expression #xx#!)
Below You Can Observe Examples of Correctly Defined Expressions:
- #SD28%# - balance of debit transactions on accounts of group 28
- #SO4%# - sum of debit balance on accounts of class 4
- #RP90%# - revaluation of credit balance on accounts of group 90
- #A10# - #A20# - amount from line 10 in posting template, less the amount from line 20 of the same template