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
    [Collapse]Personnel
     [Expand]Employment
     [Expand]Time Terminal
     [Expand]Leave
     [Expand]Daily Allowances and Mileage Rates
     [Collapse]Payroll
      [Expand]Average Salaries
      [Expand]Contributions
      [Expand]Salary Grades
       Income Sources
      [Expand]Income and Payroll Tax Rates
      [Expand]Payment Order Codes
      [Expand]Work Types
      [Collapse]Earnings Types
        Earning Types by Department
       [Expand]Taskbar
        Transfer Registers – Earnings Types
        Edit several earnings types with related criteria
        Formulas for Predefined Earnings Types
        Predefined Earnings Types
       [Collapse]Formula Builder
         Program Parameters
         Average Salaries
         Administration panel
         Payroll Preparation
         Variables for Contributions
         Single Employee
         Employment Record
         Position
         Grade
         Periodic Rating
         Factor Net
         Cost Centers
         GE Variables
         Subjects
         Rounding
         Finished Work Analysis
         Fixed Assets
         Date variables
         Using SQL Statement in Formula
       Additional General Relief
     [Expand]Health and Safety at Work
      Work Processes
     [Expand]Messages in Personnel Settings
     Calendar
    [Expand]Financials
    [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: 421.8983 ms
"
   1007535 | 219807 | 356665 | Updated
Label

Date variables

Date variables

Below are listed date variables for salary formulas included under Date variables item in Formula Builder:

The following field and button are made available in Formula Builder after selecting specific variables under Date Variables:

VARIABLES

DatePay – Payout Date

Payout date from the Payroll Preparation.

DateCalc – Report Date

Calculation date from the Payroll Preparation.

DateVAT – Tax Date

Tax date from the Payroll Preparation.
DataEnter - Start Date Start date from Employment record. 

 

000001.gif

If we want that the formula is going to work correctly we use formats of variables for dates.

It is importatant that we enter the date in a form LLLLMMDD.

 

Date variables from payroll preparation

Example:

The employee is entitled to a salary bonus is:

  • If the payout date is later 15.12.2019, than the value is 0€ if the payout date is before than the value is 10€
  • If the calculation date is before 15.12.2019, than the value is 50€ if the payout date is later than the value is 5€

 

In Formula Builder we use date variables DatePay – Payout Date and DateCalc – Report Date and we proceed by entering the conditions bellow in two new ET:

  1. In ET R11 we enter [#DatePay#<"20191215":0]10
  1. In ET R12 we enter [#DateCalc#>"20191215":50]5

 

This means:

  1. If the Payout date is smaller or before than the entered date, that the employee will receive bonus of 10€, but if the payout date is after the entered date, than the bonus is 0€
  2. If the Calculation date is bigger or after than the entered date, that the employee will receive bonus of 5€, but if the calculation date is before the entered date, than the bonus is 50€

 

Date variables from employment record 

Example:

The employee is entitled to a length of service bonus if:

  • If the start is later 01.01.2019, than the value is 0€ if the start date is before than the value is 0,5%
  • John Doolitle started his employment on 15.12.2018 and Alice Knight on 01.10.2019

 

In Formula Builder we use date variable DateEnter – Start Date and create a new earning type:

In ET MN1 we create a formula [#DateEnter#<20190101:0,5]0

 

after the calculation we can see the results in preparation in a tab Pay Slip:

 


 

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