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
   [Expand]Getting Started
   [Expand]User Manual for eBusiness
   [Collapse]Settings
    [Expand]Subjects
    [Expand]Items
    [Expand]POS
     Manufacturing
    [Expand]Program
    [Collapse]Personnel
     [Expand]Daily Allowances and Mileage Rates
     [Expand]Employment
     [Collapse]Payroll
      [Expand]Average Salaries
      [Expand]Contributions
      [Expand]Income and Payroll Tax Rates
      [Expand]Additional General Reliefs
      [Expand]Work Types
      [Expand]Earnings Types
      [Collapse]Formula Builder
        Rounding
        Referencing Variables from Subjects
        Create Formula for Meals Allowance
        Create Formula Using SL Expression in Formula Builder
        Referencing Variables in Previous Pay Slip
        Referencing Variables in Contributions
        Referencing Professional Education Level
     [Expand]Leave
     Calendar
    [Expand]Financials
    [Expand]Customs
    [Expand]Documentation
    [Expand]Program
     Change user
   [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: 453.1246 ms
"
   9150 | 9698 | 341913 | Updated
Label

Create Formula Using SL Expression in Formula Builder

Create Formula Using SL Expression in Formula Builder

Create Formula Using SL Expression in Formula Builder

010381.gif010411.gif010382.gif010383.gif

Do the following to create a formula for commuting allowance in formula builder (see type 4). 

 

The formula consists of the following:

[(#Del04#*#Fa6#*#VZRD-Dni#)+#Del05#*#VZRD-Dni#>#PRZnesek#+(#Del04#*#Fa6#*#VZRD-Dni#):#PRZnesek#+(#Del04#*#Fa6#*#VZRD-Dni#)]#Del05#*#VZRD-Dni#+(#Del04#*#Fa6#*#VZRD-Dni#)

#Del05#*#VZRDČ-Dni#+(#Del04#*#Fa6#*#VZRDC-Dni#)

 

The variables in formula influence the following:

When daily commuting expense is greater than the monthly expense, use monthly allowance. Otherwise use daily allowance.

 

This can be done in the following two ways:

  1. without SQL expression

  2. with SQL expression

 

Type 1: Without SQL Expression

To create a formula in formula builder, see Create Formula for Meals Allowance.

078002.gif

 

 

 

2Type 2: With SQL Expression

000001.gif By entering SQL expressions you should observe the following:
  • SQL expression begins and ends with a delimiter ~S~
  • A formula can contain any number of SQL expressions
  • An SQL expression cannot contain logical conditions ([..:..]..)
  • SQL expression cannot contain temp tables with one #
  • SQL expression can contain variables (# ... #)
  • Logical conditions can contain SQL expression

 

You can enter SQL expression in formua builder observing the above rules.

078006.gif

 

Then press 078007.gif and finally 078008.gif in order to record formula in the corresponding field in Earnings Types.

078009.gif

 

000001.gif You can test formulas which do not include SQL expression in the Test panel, since SQL expressions cannot be tested in formula builder.

 

 


 

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