deductions taken not showing up on lawson query

what tool are you using for the lawson query? what are the parameters used?

We are using the lawson add-in Query Wizard and running the query against the PAYDEDUCTN table. The criteria is to use the period end date is >= 08/01/2010 and period end date is <= 08/31/2010. This way we get all the deductions for the month. We are paid bi-weekly and the first paycheck is on the report but the other one is not and its only for this one employee. All the other employees have both deductions for the two periods in August.

I have some similar queries, but I can't use period ending, I have to use check date to capture deductions withheld within a month. For the month of August, what are your period end dates, and the associated check dates? Did the individual in question have a manual check, maybe, with a different date on it? Or an adjustment entered within the parameters of your query?

I ran it on check date rather than period end date and I do see that the period end date for the check date 8/26/10 had 09/04/2010 instead of 08/21/10 like everyone else. The pay period for check date 8/26/10 was Aug 8-21st. I did check the dates and they entered a vacation day with a date of 8/23/10 which is in the next pay period (period ending 9/4/10).

We have it set up on the HS03.1 to allow employees to enter time for the pay period starting on the day that begins the pay period. For example, on 8/22/10 it starts the new pay period 8/22-9-4 with a paydate of Sept 9th. When the employee comes in on Monday 8/23/10 all time is due for the previous paycycle that I am processing that week. Im processing payroll on monday for Aug 8th to Aug 21st. If the employee does not arrow back in Lawson time system they could potentially enter a vacation day in the next paycycle not the current one because its defaults to whatever day it is currently. When they go in on Monday Aug 23rd its showing them the Aug 22nd through 9-4-10 pay period end date. My guess is this employee entered the vacation day on Aug 23rd's date instead of arrowing back to the current pay cycle im running which would have been Monday August 16th. My question is how do you stop this from happening and why does the system process the vacation in a future period?

I'm a little confused how the topic of PR14 deductions and Time Entry relate but I'll try to answer your most recent question relating to Time Entry. We've been using Time ENtry since 10/2008. HS535 controls what time records are pulled in for processing. What are your parameters for HS535? IWe use a combination of status and pay period dates to control what is picked up by HS535.

You can use your lock out dates on HS03 to prevent entry. The PR140 will process any records you have created and put into current status, the period end date in that respect is irrelevent. Sounds like you need to consider multiple parameters as Jodi discusses. And Jodi, I'm confused, too -