Help with Pay Stub

coolmanlg · Post by **coolmanlg** » Tue Jun 26, 2007 8:40 pm

After entering an wages, setup tax, dedcutions, pay period sechdule, and generating pay stub, I only get blank

STATEMENT OF EARNINGS AND DEDUCTIONS

without the wages and deductions.

This is an idea of what I did.

Pay Period schedule

1. Name: Salary
Desc: Monthly Salary
overtime wk:Monday-Sunday
Daily Start:09:00AM
Continous Time:08.00
Type:Monthly
Pay Period Start Day Of Month:1
Transaction Day Of Month:1
Create Initial Pay Periods From:1-Mar-07
I attached an employee to this schedule.

Wages

I entered the employee wage, tax and deductions from the wage function in the employee list

Mass Punch
I punched in time IN and OUT for the employee

Time:9:00am
Start Date:1-mar-07
End Date:1-Apr-07
Punch Type:Normal
In/Out:

End of Pay Period

Afterwards, I clicked on the end of pay period
I clicked on VIEW for 1-apr-07 which is the transaction date

On the view pay period, The following were listed:

Status:Open
Start Date:01-Mar-07 9:00 AM
End Date: 01-Apr-07 8:59 AM
Transaction Date:01-Apr-07 8:59 AM
Total Punches:44
Pending Requests: 0
Exceptions: 0 / 0 / 0
Action: Generate Pay Stub

It generated the pay stub with the status of success and the employee name.

Pay Stub List

When I clicked on the pay stub list, I get the following:
1 Kany Papa NEW 01-Mar-07 01-Apr-07 01-Apr-07 [ View ] [ Edit ]
2 Kany Papa Open 01-Mar-07 01-Apr-07 01-Apr-07 [ View ] [ Edit ]

Clicking on view displays an empty

statement of earning and deductions

pdf document.

What have I done wrong pls?

coolmanlg · Post by **coolmanlg** » Wed Jun 27, 2007 3:29 am

Post by **shaunw** » Wed Jun 27, 2007 8:53 am

When I clicked on the pay stub list, I get the following:
1 Kany Papa NEW 01-Mar-07 01-Apr-07 01-Apr-07 [ View ] [ Edit ]
2 Kany Papa Open 01-Mar-07 01-Apr-07 01-Apr-07 [ View ] [ Edit ]

Something is wrong here, you should not be seeing two pay stubs for the same employee for the same Start/End date.

Are you running MySQL by chance?

coolmanlg · Post by **coolmanlg** » Wed Jun 27, 2007 10:08 am

Thanks for the reply. Yes am running mysql version 5.0.27-community-nt
php version : 5.2.1 and apache version 2.2.4 on winxp sp 2 home edition.

Post by **shaunw** » Wed Jun 27, 2007 10:42 am

Does your MySQL support InnoDB tables?

This post explains how to find out:

http://forums.timetrex.com/viewtopic.php?p=492#492

Also you need to check to make sure your tables are using the InnoDB engine, this post explains that:

http://forums.timetrex.com/viewtopic.php?p=996#996

You mentioned that you clicked "View" on a pay stub, but which pay stub did you view? Did they both show the same thing?

coolmanlg · Post by **coolmanlg** » Wed Jun 27, 2007 11:33 am

Thanks shaunw

I have made the checks and the default engine is innodb.

Here is how I got to the view:

timesheet->pay stubs.

which shows a list of pay stubs

1 Hassan Awodi NEW 01-May-07 01-Jun-07 01-Jun-07 [ View ] [ Edit ]
2 Hassan Awodi Open 01-May-07 01-Jun-07 01-Jun-07 [ View ] [ Edit ]

I clicked on the view in bracket.

Regards.

Post by **shaunw** » Wed Jun 27, 2007 11:43 am

The default engine is InnoDB, but you didn't mention if the TimeTrex tables are in fact InnoDB.

Also, which pay stub did you click the "View" link beside? The one with status "New" or the one with status "Open". If you view them both, do they show different information?

coolmanlg · Post by **coolmanlg** » Thu Jun 28, 2007 12:28 am

The TimeTrex tables are InnoDB. Clicking on either the New or Open displays the same information...empty statements of earning.

Post by **shaunw** » Thu Jun 28, 2007 8:50 am

Is it possible for you to email support@timetrex.com the URL to your TimeTrex installation along with a login/password for the administrator user?

coolmanlg · Post by **coolmanlg** » Thu Jun 28, 2007 10:05 am

am running TimeTrex on my local and I don't have a public IP. Or could you walk me through a basic step of what I need to do generate a very simple pay stub?

How do link the various pay stub account created with the employee? How does money get in and out of the pay stub?

Post by **shaunw** » Thu Jun 28, 2007 1:46 pm

I'm worried that something is seriously wrong with your TimeTrex installation. However without having access to your system is could be extremely difficult to diagnose. The reason I believe this is because you have two pay stubs with the same dates, this should never happen.

Can you dump your database and email it to us instead perhaps?

coolmanlg · Post by **coolmanlg** » Fri Jun 29, 2007 9:17 am

Thanks shaun. I have mailed you the dumb.

Post by **shaunw** » Fri Jun 29, 2007 2:53 pm

We looked at the dump, and it appears as though your database is severely corrupt. Since there is no real data in it I would recommend you completely install TimeTrex from scratch again.

If the database wasn't corrupt, you wouldn't see any pay stubs being generated at all because you didn't give any employees a wage, nor did you assign any hours to their timesheet, so there was nothing to pay them.

coolmanlg · Post by **coolmanlg** » Sat Jun 30, 2007 2:32 am

Will do that now. I actually assigned wages to the employees.

I will install a fresh one and send you the db dumb again.

michael1206 · Post by **michael1206** » Mon Jul 02, 2007 8:44 pm

Actually i think i encoutered the same problem as coolmanlg did, i have set the policy and payment terms as follows:

Pay Period schedule
Overtime Week: Sunday-Saturday
Daily Start Time:9:00
Continuous Time: 10:00
Type: Monthly
Pay Period Start Day Of Month: 1 at 9:00
Transaction Day Of Month:30
Create Initial Pay Periods From: 01-Jun-07

Tax and Policies
I didn't set any other tax nor policy except meal policy:
Type: Minimum
Minimum Time: 1:00
Start Window: 4:00
window Length: 2:00

The salary for one staff is paid by month

After I made a mass punch from 1 to 30 June 2007, then I click recalculated stub to generate records; in the pay stub list, I don't know why there were two records generated:

Peter Pan NEW 01-Jun-07 01-Jul-07 01-Jul-07 [ View ] [ Edit ]
Peter Pan Open 01-Jun-07 01-Jul-07 01-Jul-07 [ View ] [ Edit ]

and there is no record in the stub list.

I would like to ask if i missed something; honestly, I do want to know what procedure should I do from the beginning to the end, though i have gone through the whole administrator guide. I still feel difficult to set even i tried the simple scenario

i am now using TimeTrex version 2.0.1
PHP version: 5.2.3
mySQL version: 5.0.41-community-nt

Post by **shaunw** » Tue Jul 03, 2007 8:12 am

You mentioned you are running MySQL v5.0.41, please see this post:
http://forums.timetrex.com/viewtopic.php?t=298

Also, please run this SQL query and let me know what it returns:

Code: Select all

select * from pay_stub_id_seq;

michael1206 · Post by **michael1206** » Tue Jul 03, 2007 8:33 pm

when execute: select * from pay_stub_id_seq;
it shows empty set, ie. no record found at all

besides, i would like to ask if the problem still exists when using 5.1.19 MySQL version

thx a lot

Post by **shaunw** » Wed Jul 04, 2007 8:53 am

That query should never show empty, it should always return a single row. This is the exact same issue coolmanlg had.

I would recommend re-installing TimeTrex if you can as it appears something seriously wrong has happened.

TimeTrex isn't supported on MySQL v5.1 because it is in beta still, I would recommend using v5.0.37 or older instead as per http://forums.timetrex.com/viewtopic.php?t=298

coolmanlg · Post by **coolmanlg** » Tue Jul 31, 2007 5:11 am

Hello shaunw,

I have been busy on other project hence the silence. Am back now. I have reinstalled several times on lower versions of Mysql and still encountered the same problem.

Right, I have installed on postgres but seems to be having a different problem.

I have created a pay period, created a user with a wage and linked the user to the wage and the pay period.

Issues are:

1. clicking on timesheet->mass puch for the employee b/w 1st june and jul 31st generate generate the following:

Awodi, Hassan @ 01-Jun-07 12:00 PM Failed

1. Pay Period is Currently Locked, or Date/Time is incorrect

2. Clicking on Admin->payroll->end of pay period brings up the following:

There are no Pay Periods past their end date yet.

I set the initial pay period to 1st June 2007.

3. Even though I set the initial pay period to 1st June 2007, it doesn't include July 1st as a transaction date instead, it starts from August.

#
Name

Type

Status

Start

End

Transaction
Functions
1 Monthly Monthly N/A 01-Jul-07 8:00 AM 01-Aug-07 7:59 AM 01-Aug-07 8:00 PM
2 Monthly Monthly N/A 01-Aug-07 8:00 AM 01-Sep-07 7:59 AM 01-Sep-07 7:59 AM
3 Monthly Monthly N/A 01-Sep-07 8:00 AM 01-Oct-07 7:59 AM 01-Oct-07 8:00 PM
4 Monthly Monthly N/A 01-Oct-07 8:00 AM 01-Nov-07 7:59 AM 01-Nov-07 8:00 PM
5 Monthly Monthly N/A 01-Nov-07 8:00 AM 01-Dec-07 7:59 AM 01-Dec-07 7:59 AM
6 Monthly Monthly N/A 01-Dec-07 8:00 AM 01-Jan-08 7:59 AM 01-Jan-08 8:00 PM
7 Monthly Monthly N/A 01-Jan-08 8:00 AM 01-Feb-08 7:59 AM 01-Feb-08 8:00 PM
8 Monthly Monthly N/A 01-Feb-08 8:00 AM 01-Mar-08 7:59 AM 01-Mar-08 7:59 AM
9 Monthly Monthly N/A 01-Mar-08 8:00 AM 01-Apr-08 7:59 AM 01-Apr-08 8:00 PM
10 Monthly Monthly N/A 01-Apr-08 8:00 AM 01-May-08 7:59 AM 01-May-08 8:00 PM
11 Monthly Monthly N/A 01-May-08 8:00 AM 01-Jun-08 7:59 AM 01-Jun-08 7:59 AM
12 Monthly Monthly N/A 01-Jun-08 8:00 AM 01-Jul-08 7:59 AM 01-Jul-08 8:00 PM
13 Monthly Monthly N/A 01-Jul-08 8:00 AM 01-Aug-08 7:59 AM 01-Aug-08 8:00 PM
14 Monthly Monthly N/A 01-Aug-08 8:00 AM 01-Sep-08 7:59 AM 01-Sep-08 8:00 PM
15 Monthly Monthly N/A 01-Sep-08 8:00 AM 01-Oct-08 7:59 AM 01-Oct-08 8:00 PM
16 Monthly Monthly N/A 01-Oct-08 8:00 AM 01-Nov-08 7:59 AM 01-Nov-08 7:59 AM
17 Monthly Monthly N/A 01-Nov-08 8:00 AM 01-Dec-08 7:59 AM 01-Dec-08 8:00 PM
18 Monthly Monthly N/A 01-Dec-08 8:00 AM 01-Jan-09 7:59 AM 01-Jan-09 8:00 PM
19 Monthly Monthly N/A 01-Jan-09 8:00 AM 01-Feb-09 7:59 AM 01-Feb-09 7:59 AM
20 Monthly Monthly N/A 01-Feb-09 8:00 AM 01-Mar-09 7:59 AM 01-Mar-09 7:59 AM
21 Monthly Monthly N/A 01-Mar-09 8:00 AM 01-Apr-09 7:59 AM 01-Apr-09 8:00 PM
22 Monthly Monthly N/A 01-Apr-09 8:00 AM 01-May-09 7:59 AM 01-May-09 8:00 PM
23 Monthly Monthly N/A 01-May-09 8:00 AM 01-Jun-09 7:59 AM 01-Jun-09 8:00 PM
24 Monthly Monthly N/A 01-Jun-09 8:00 AM 01-Jul-09 7:59 AM 01-Jul-09 8:00 PM

Post by **shaunw** » Tue Jul 31, 2007 9:39 am

The status of your pay periods are all "N/A", which means they are phantom pay periods that don't really exist. So your pay period schedule isn't setup correctly.

First off, I wouldn't use 8:00AM for the start time unless you really know what you are doing, this is the pay period start time, and if an employee punches in before 8:00AM on the first day of a pay period their entire days time can be placed on the previous pay period. Use midnight (00:00) instead.

Secondly I always recommend that you set the "Create Initial Pay Periods From" to 1-2 pay periods before you actually plan on entering data. So instead of July 1st, try May 1st.

You will need to do all this by creating a new pay period schedule, as editing an already existing pay period schedule does not carry out many of the "new pay period schedule" tasks that need to be done.

coolmanlg · Post by **coolmanlg** » Tue Jul 31, 2007 11:15 am

thanks for the info shaunw. Will look at again and get back.

coolmanlg · Post by **coolmanlg** » Wed Aug 01, 2007 5:07 am

Thanks shaunw, I have been able to generate pay stubs for my test. All seems to be ok except that the tax and deductions I created for the employee is not reflecting in the pay stub.

I created the tax and deductions after my first pay stub generation. Does this affect the it?

Thanks

Post by **shaunw** » Wed Aug 01, 2007 9:40 am

Yes, TimeTrex does not automatically re-generate pay stubs for you, so if you make any kind of change, either to employee timesheets, taxes, deductions, PS amendments, you have to manually re-generate the pay stubs.

beakcon · Post by **beakcon** » Thu Aug 02, 2007 2:11 pm

I have what seems to be the same problem. When I attempt to view a pay stub, all I get is a blank stub with the pay period dates at the top.

Pay Period schedule
Name: Largo Shipping Warehouse
Overtime Week: Sunday-Saturday
Daily Start Time: 00:00
Continuous Time: 12:00
Type: Bi-Weekly
Pay Period Starts On: Sunday
Transaction Date: 2
Create Initial Pay Periods From: 08-Jul-07

Wages

I entered the employee wage, tax and deductions from the wage function in the employee list

On the view pay period, The following were listed:

Status:Open
Start Date: 08-Jul-07 0:00
End Date: 21-Jul-07 23:59
Transaction Date: 23-Jul-07 12:00
Total Punches:20
Pending Requests: 0
Exceptions: 0 / 0 / 0
Action: Generate Pay Stub

It generated the pay stub with the status of success and the employee name.

Pay Stub List

When I clicked on the pay stub list, I get the following:
1 john doe NEW 08-Jul-07 21-Jul-07 23-Jul-07 [ View ] [ Edit ]
2 john doe OPEN 08-Jul-07 21-Jul-07 23-Jul-07 [ View ] [ Edit ]

Clicking on view displays an empty statement of earning and deductions pdf document.

running mysql version 5.0.37-community-nt (Timetrex tables are InnoDB )
Apache/2.2.4 (Win32)
PHP version :5.2.2
winxp sp 2 Pro edition

so was there a resolution for this?

Post by **shaunw** » Thu Aug 02, 2007 6:48 pm

The problem you are running into is a MySQL issue. Either you aren't using InnoDB or your version of MySQL is broken. I would recommend using PostgreSQL instead if you can, it will be much less hassle for you.

Alternatively if you wait a week or so when we will release TimeTrex v2.1.0-rc1 with its own installer that will take care of the entire installation process for you automatically.

TimeTrex Time and Attendance

Help with Pay Stub

Help with Pay Stub

Time and Attendance