Data Collection setup and reports

Yahoo Archive
1
Lunch and breaks are defined under Financial Management/Payrol/Master File Maintenance/Shifts. You can set up the various lunch and breaks here.

Dave Miller
Prince Industries, Inc.

-------------- Original message --------------
From: "Jasper Recto" <jrecto@...>

We will soon be using data collection stations to clock in and out for the day instead of a time clock.

I need to creat a report that has the hours worked for each person. Looking at the LaborHed table, it's a little confusing on which clock in values I should be using.

Does anybody have any suggestion on this?

Also, there is supposed to be an internal control that automatically takes out for lunch. Where is this setting?

Thanks,
Jasper


[Non-text portions of this message have been removed]




[Non-text portions of this message have been removed]
2
We will soon be using data collection stations to clock in and out for the day instead of a time clock.

I need to creat a report that has the hours worked for each person. Looking at the LaborHed table, it's a little confusing on which clock in values I should be using.

Does anybody have any suggestion on this?

Also, there is supposed to be an internal control that automatically takes out for lunch. Where is this setting?

Thanks,
Jasper



[Non-text portions of this message have been removed]
3
The lunch setting is controlled in the shift master file. We have used the
canned labor edit report to review yesterday's time.

Jerry Boyle, Controller
Sipco Molding Technologies
Meadville, PA. 16335
p 814.724.2243 x53
f 814.724.2244
vantage 6.10


-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
Jasper Recto
Sent: Friday, June 16, 2006 11:57 AM
To: Vantage Groups (E-mail)
Subject: [Vantage] Data Collection setup and reports

We will soon be using data collection stations to clock in and out for the
day instead of a time clock.

I need to creat a report that has the hours worked for each person. Looking
at the LaborHed table, it's a little confusing on which clock in values I
should be using.

Does anybody have any suggestion on this?

Also, there is supposed to be an internal control that automatically takes
out for lunch. Where is this setting?
4
I am doing that right now, an Access database for the purpose of
getting rid of time cards. We've been running both in parallel for
years to maintain audit records. Needless to say, we haven't been
fully utilizing Vantage.

What I did was pull employee data (empid, name, supervisor) from
EmpBasic so I could get ALL employees. Then matched the employee to
the LaborHed to get actualclockintime and acutalclockouttime. Shift
in LaborHed is matched to JCShift to get the starttime and endtime.
We pay for lunch and breaks so that's not a issue here.

I also have a subreport that allows the LaborDtl with the tob, start
activity (labordtl.clockintime), end activity (labordtl.clockouttime),
wccode.

Not all of the time values I'm using have display values so I wrote a
little code to convert the decimal to hour:minute am/pm time.

I had to make it a subreport in case someone clocks all the way out
and then clocks back in the same day. And because of the subreport,
it took forever to run so I had to make the queries maket-ables and
store the data in local tables.

There is a form to filter by the date and supervisor. A signed
hardcopy report is retained for audit trail instead of the punched
time card.

There are some still some details to work out on the process
as well as fine tuning the database before we implement.




--- In vantage@yahoogroups.com, "Jasper Recto" <jrecto@...> wrote:
>
> We will soon be using data collection stations to clock in and out
for the day instead of a time clock.
>
> I need to creat a report that has the hours worked for each person.
Looking at the LaborHed table, it's a little confusing on which clock
in values I should be using.
>
> Does anybody have any suggestion on this?
>
> Also, there is supposed to be an internal control that automatically
takes out for lunch. Where is this setting?
>
> Thanks,
> Jasper
5
I am doing that right now, an Access database for the purpose of getting
rid of time cards. We've been running both in parallel for years to
maintain audit records. Needless to say, we haven't been fully
utilizing Vantage.



This is all for ver 6.1.



What I did was pull employee data (empid, name, supervisor) from
EmpBasic so I could get ALL employees. Then match the employee to the
LaborHed to get actualclockintime and acutalclockouttime. Shift in
LaborHed is matched to JCShift to get the starttime and endtime. We pay
for lunch and breaks so that's not an issue here. I also have a
subreport that allows the LaborDtl with the tob, start activity
(labordtl.clockintime), end activity (labordtl.clockouttime), wccode.



Not all of the time values I'm using have display values so I wrote a
little code to convert the decimal to hour:minute am/pm time.



I had to make it a subreport in case someone clocks all the way out and
then clocks back in the same day. And because of the subreport, it took
forever to run so I had to make the queries make-tables and store the
data in local tables.



There is a form to filter by the date and supervisor. A signed hardcopy
report is retained for audit trail instead of the punched time card.



There are some still some details to work out on the process as well as
fine tuning the database before we implement.





________________________________

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Jasper Recto
Sent: Friday, June 16, 2006 11:57 AM
To: Vantage Groups (E-mail)
Subject: [Vantage] Data Collection setup and reports



We will soon be using data collection stations to clock in and out for
the day instead of a time clock.

I need to creat a report that has the hours worked for each person.
Looking at the LaborHed table, it's a little confusing on which clock in
values I should be using.

Does anybody have any suggestion on this?

Also, there is supposed to be an internal control that automatically
takes out for lunch. Where is this setting?

Thanks,
Jasper


[Non-text portions of this message have been removed]





[Non-text portions of this message have been removed]