Finance

In line formulas for planning (similar as in financial reports) you refer directly to general ledger accounts.

Create formulas manually or automatically by selecting the accounts using the tool for creating formulas. If formulas are created automatically, you can at a later stage change them in any way you want.

Create ir change formulas by selecting the appropriate account, account transaction or account balance and mark whether the data hold good only for this account or for the entire child accounts group (Include Sub-Accounts  - in this case put the "%" percent sign in the formula).

• D – debit transactions to the account in the given period
• K – credit transactions to the account in the given period
• S – account balance in the given period
• P - Credit – Debit (credit balance in the given period)
• O – Debit – Credit (debit balance in the given period)
• A - Line

You can enter and subsequently change formulas in the Formula window (under the main table) as well as check them by calling up a tool using the Test Formula button.

The following examples would be the correct formula entries:   #S1200# = balance of account 1200 in the given period (absolute balance) #D12%# = debit transactions to accounts of group 12 in the given period #K0%# = credit transactions of accounts of group 0 in the given period #O02%# = debit – credit on accounts of group 02 in the given period (debit balance) #P90%# = credit – debit accounts of group 90 in the given period (credit balance) #A10#+#A30# - sum of lines 10 and 30