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
Help With Pay Stub Generation
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
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
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?
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?
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
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
This is a problem specific to MySQL, run these SQL commands on your TimeTrex database.
Let us know if that fixes things.
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;
TimeTrex Community Edition is developed and supported by volunteers.
Help motivate us to continue by showing your appreciation!
Help motivate us to continue by showing your appreciation!
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
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