Home | Contact Us | Buy
Time and Attendance made easy  
Time off in lieu of Overtime

Summary :
In most cases time worked past the normal time is considered Aovertime@. This is usually paid out as extra earnings. However in some companies this extra time (or part of this extra time) is returned to the employee as Atime off@. This document details configuring such a system using TNA 2000.

Requires :
Version 2.43 or later.

Configuration

A) Create a time category called say ALieu Time@. This category should be set to have neutral effect on the Total (i.e. not + or - but set to 0). You can choose to report this time on reports, or not, that's up to you.

B) Assuming Normal time is category 2, and Lieu time is Category 3, Create a Payroll Macro containing the following. (Adjust the wee:hours settings to match the categories you used).

at before saving Payroll hours

 wee:hours3 = GetEmpPayrollHours(ProcessEmp,ProcessDate-1,ProcessDate-7,1,3)

 If wee:hours2 > wee:stdhours

   If wee:hours3 > (wee:stdhours - wee:hours2)

     wee:hours3 = wee:hours3 - (wee:Stdhours - wee:hours2)

     Wee:hours2 = wee:StdHours

   Else

     Wee:hours2 = wee:hours2 + wee:hours3

     Wee:Hours3 = 0

   End

 End

Notes:

1) Assuming a 7 day payroll shift here. If not (i.e. if monthly shift) then set the first line to say wee:hours3 = GetEmpPayrollHours(ProcessEmp,ProcessDate-1,ProcessDate-31,1,3)

the syntax for GetEmpPayrollHours is

GetEmpPayrollHours (Employee, FromDate, ToDate, Rate, Category)


2) Note the 3 at the end of the first line. This is the Lieu category number.

3) This script will take place AFTER the normal payroll balancing rules. Hence normal payroll balancing is not usually used.

4) the above script uses payroll AStd Hours@to decide on the required amount. So make sure the Daily Std Hours is set for each shift, or replace the Wee:StdHours above with a fixed number. (This number is time in hundreths of a second - i.e. 360000 = 1 hour)

Notes
It is envisaged that this method will become obsolete in Version 3.

   Terms of Use      Disclaimer 

2007 CapeSoft Software (Pty) Ltd. All rights reserved.
This site is optimized for IE 6+, Firefox 1.0+, and resolution 1024*768 pix