PANTHEON™ Help

 Toc
 PANTHEON Help - Welcome
[Collapse]PANTHEON
 [Collapse]Guides for PANTHEON
  [Collapse]Guide for PANTHEON
   [Collapse]Settings
    [Expand]Subjects
    [Expand]Items
    [Expand]POS
    [Expand]Manufacturing
    [Expand]Personnel
     Calendar
    [Collapse]Financials
      Denominations
     [Expand]Chart of Accounts
     [Expand]Cost Centers
      Payment Methods
     [Expand]Tax Types
      Foreign Inflows and Outflows
     [Expand]Distribution Keys
     [Expand]Interest Rates
     [Expand]Financial Reports
     [Collapse]Templates for Automatic Posting
      [Expand]Toolbar in Posting Template
       Header of Posting Template
      [Collapse]Lines in Posting Template
        Verifying Formulas in Posting Templates
       Generating Reports and Posting
       Errors in Posting by Using Templates
     [Expand]Depreciation Categories
     [Expand]Revaluation Rates
     [Expand]Payment Orders
      Cash Receipts / Disbursements
      Post Statuses
      Journal Entry Notes
     [Expand]Corporate Income Tax Calculation (DDPO/DDD settings)
      XBLR Register
      XBRL Templates
      ESEF register
      Prenos šifrantov preko spleta
    [Expand]Customs
    [Expand]Program
    [Expand]Documentation
    [Expand]Change User
   [Expand]Orders
   [Expand]Goods
   [Expand]Manufacturing
   [Expand]POS
   [Expand]Service
   [Expand]Financials
   [Expand]Personnel
   [Expand]Analytics
   [Expand]Desktop
   [Expand]Help
   [Expand]Messages and Warnings
   [Expand]Additional programs
   [Expand]Old products
  [Expand]Guide for PANTHEON Retail
  [Expand]Guide for PANTHEON Vet
  [Expand]Guide for PANTHEON Farming
 [Collapse]User Manuals for PANTHEON
  [Expand]User Manual for PANTHEON
  [Expand]User Manual for PANTHEON Retail
  [Expand]User manual for PANTHEON Vet
  [Expand]User Manual for PANTHEON Farming
[Collapse]PANTHEON Web
 [Collapse]Guides for PANTHEON Web
  [Expand]Guide for PANTHEON Web Light
  [Expand]Guide for PANTHEON Web Terminal
  [Expand]Guide for PANTHEON Web Legal
  [Expand]Old products Archive
 [Collapse]User Manuals for PANTHEON Web
  [Expand]Getting started PANTHEON Web
  [Expand]User Manual for PANTHEON Web Light
  [Expand]User Manual for PANTHEON Web Terminal
  [Expand]User Manual for PANTHEON Web Legal
  [Expand]Old products Archive
[Collapse]PANTHEON Granules
 [Collapse]Guides for PANTHEON Granules
  [Expand]Personnel Granule
  [Expand]Travel Orders Granule
  [Expand]Documents and Tasks Granule
  [Expand]Dashboard Granule
  [Expand]B2B Orders Granule
  [Expand]Field Service Granule
  [Expand]Fixed Assets Inventory Granule
  [Expand]Warehouse Inventory Granule
 [Collapse]User Manuals for PANTHEON Granules
  [Expand]Getting started
  [Expand]Personnel Granule
  [Expand]Travel Orders Granule
  [Expand]Documents and Tasks Granule
  [Expand]B2B Orders Granule
  [Expand]Dashboard Granule
  [Expand]Field Service Granule
  [Expand]Fixed Assets Inventory Granule
  [Expand]Warehouse Inventory Granule
  [Expand]Archive
[Expand]User Site

Load Time: 406.2518 ms
"
   4377 | 5058 | 344342 | Updated
Label

Verifying Formulas in Posting Templates

Verifying Formulas in Posting Templates

Verifying Formulas in Posting Templates

 005557.gif 005558.gif

010381.gif 010411.gif 010382.gif 010383.gif

42079.gif

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
000001.gif For general information on testing formulas see Verification and Modification of Formulas.

 

Rate this topic
Was this topic usefull?
Comments
Comment will also bo visible in forum!