PANTHEON™ Help

 Toc
 PANTHEON Help - Welcome
[Collapse]PANTHEON
 [Collapse]Guides for PANTHEON
  [Expand]Guide for PANTHEON
  [Expand]Guide for PANTHEON Retail
  [Expand]Guide for PANTHEON Vet
  [Expand]Guide for PANTHEON Farming
 [Collapse]User Manuals for PANTHEON
  [Collapse]User Manual for PANTHEON
   [Collapse]Getting Started
     Dictionary of terms
     First steps with PANTHEON
    [Expand]Using PANTHEON at Tecta, a fictional company
    [Expand]Instructions for Ensuring Compliance of PANTHEON with SAS
    [Expand]PANTHEON Installation
    [Expand]PANTHEON System
    [Collapse]PANTHEON Basics
     [Expand]Entering PANTHEON
     [Expand]PANTHEON windows and forms
     [Collapse]Entering data and navigating across PANTHEON
      [Expand]Records
      [Expand]Lookup Window
      [Expand]Input Elements
       Lookup List
      [Expand]Keyboard Shortcuts
       Wildcard Characters
      [Collapse]Formulas
       [Collapse]Building and Testing Formulas
        [Collapse]Formula Testing
          Using logical operator without logical expression
          Opening or closing round bracket missing!
          Opening or closing square bracket missing!
          Last character of the formula is an operator!
          Adjacent hashes!
          Syntax error in conditional statement. Correct syntax is [condition:value]
          Adjacent operators (xx)!
          Variable not enclosed in hashes (#)!
          Illegal characters: xyz
          Unknown error!
          The first character of #xx# must be a transaction type or a column mark!
          The line number must be an integer (#xx#)!
          The first character of #xx# must be an operation type (R, S, O or A)!
          The second character of #xx# must be a transaction type (D, K, S, P, or O)!
          Variable not defined
         Debugging Formulas
        Using Conditional Statements in Formulas
       Insert Image
     [Expand]Instructions for PANTHEON
    [Expand]PANTHEON Help
    [Expand]Materials and Goods Movements
    [Expand]Assigning Identifiers
    [Expand]Frequently asked questions about Pantheon (F.A.Q.)
    [Expand]Archive
   [Expand]User Manual for eBusiness
   [Expand]Settings
   [Expand]Orders
   [Expand]Goods
   [Expand]Manufacturing
   [Expand]Service
   [Expand]Help
   [Expand]Personnel
   [Expand]Financials
   [Expand]Analytics
  [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: 374.9347 ms
"
   4382 | 5063 | 340706 | Updated
Label

The First Character of #xx# Must be a Transaction Type or a Column Mark!

In addition to checking the general correctness of formula formatting, Formula testing in financial reports also checks whether we have entered an acceptable input in between the hashes (#) in the expression.

In balance lines, any expression that is not followed by the following character combinations after the hash is incorrect:

In first place Follows

D– debit transactions on account during a given period

K– credit transactions on account during a given period

S– the balance on account in a given period in absolute value = |D – K|

P – Credit & Debit (credit balance in a given period) = K - D

O – Debit – Credit (debit balance in a given period) = D – K

 any set of characters to identify the account, e.g:

11%

 

A – value in line under column A (Formula 1)

B – value in line under column B (Formula 2)

 any position number, e.g.:

10
EmpNo – average number of employees in a given year.

 

 (no record)

If one of the four characters from the first column is not used in initial formula position, the following error is returned when running the test.

Expressions that fail the Check pairs are also written out, and formula testing puts us on the problematic input so that it is easier to correct it.

33041.jpg

When we click the OK button, the program places the cursor at the point in the formula where the error occurred.

The following solution is available. In the first place, enter the correct expression after the hash.

Correct Incorrect
#A31# #C31#
#D11%# #E11%#
#StDel# #StDel3#

 

RELATED TOPICS:

Using logical operator without logical expression

Adjacent hashes!

 

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