Help With Pay Stub Generation

[gandor]

Product Edition: Standard
Version: 1.5.0
OS SUSE Linux 10.1
PHP5
MYSQL5
Apache 2.2

I Just installed Timetrex and set up a Pay Period Schedule as fallows.

Name: Normal
Description: Normal Work Week
Overtime Week: Friday - Thurday
Daily Start Time: 00:00
Continuous Time: 12:00
Type: Weekly
Pay Period Starts On: Friday
Transaction Date: 11
Transaction Always on Business Day: is checked
Create Initial Pay Periods From: Jan-05-2007
and i have 4 Employees: assigned to this pay period

I have imputed the punch data to these pay periods

Start Date: Jan-26-2007
End Date: Feb-01-2007
Transaction Date: Feb-12-2007

Start Date: Jan-02-2007
End Date: Feb-08-2007
Transaction Date: Feb-19-2007


now here is the problem when i generate pay stubs for these pay periods
i get

Start Date: Fed-15-2007 ---- (Start Date should be Jan-26-2007)
End Date: Feb-01-2007
Transaction Date: Feb-12-2007


Start Date: Feb-15-2007 ---- (Start Date should be Jan-02-2007)
End Date: Feb-08-2007
Transaction Date: Feb-19-2007

what in the world is going on?
its driving me crazy.

Can anyone please help me

[shaunw]

The dates you have supplied don't make any sense. You have end dates that are before start dates. Can you provide any screenshots, or information for us to login to your system?

[gandor]

yes i know they dont make sence
for some reason timetrex is generating its pay stubs and replacing the start date ie feb-02-2007 with the date the pay stub was generated

you can log in here

user name: temp
password: user

http://inflecto.org/payroll/interface/Login.php

[gandor]

it also doesn't seem to be calculating the YTD amount when generating a pay stub either.

[shaunw]

I've never seen this issue before, something very strange is going on. Can you check your TimeTrex cache directory to see if it has files owned by more then one system user?

After you have checked, delete all the subdirectories and files from the cache directory, then try creating a pay stub again.

What timezone is your servers system clock set to as well?

[gandor]

I assume when you say "check your TimeTrex cache directory"
You are referring to the /tmp/timetrex directory

all the file and directories are owned by the same user wwwrun
i went ahead and deleted all the pay stubs generated in timetrex and deleted tmp files and directories as well..
Then regenerated the pay stubs still the same results. The pay stubs are being generated with the start date as the date the pay stubs where generated generated ie todays date... and its still not calculating YTD Amounts either

my servers time zone is set to US CST

any other ideas

[mikeb]

This is a problem specific to MySQL, run these SQL commands on your TimeTrex database.

Code: Select all

alter table pay_stub change start_date start_date timestamp NULL default NULL;
alter table pay_stub change end_date end_date timestamp NULL default NULL;
alter table pay_stub change transaction_date transaction_date timestamp NULL default NULL;

Let us know if that fixes things.

[gandor]

thank you very much this seems to have done the trick...

one thing i noticed though..
if i only generate pay stubs for the current pay period or for just one pay period it does not calculate the YTD amount. The YTD amount is the same as the Amount field

now if i generate all pay stubs back to the first pay period of the year "IN ORDER" it calculates the YTD amount correctly

[shaunw]

Correct, you must generate pay stubs in order. You can edit past pay stubs and TimeTrex will re-calculate YTD values going forward, but for generating pay stubs for all employees you must do it in order by date.