Vantage - BAQ to show who is clocked in / out

Yahoo Archive
1
Thanks - will give it a go.




________________________________
From: Brian Roberts <broberts@...>
To: vantage@yahoogroups.com
Sent: Mon, 28 February, 2011 21:42:52
Subject: RE: [Vantage] Vantage - BAQ to show who is clocked in / out

Â
The "who has forgotten to clock out" report was already on my todo list
this week, so I did it for both of us. Here are the steps & details
that I did. I don't know a convenient way to summarize a BAQ in an
email and I don't believe file attachments are allowed, but I can export
the BAQ & email it to you off-list if you're on 9.05.

Created a new BAQ and in Phrase Build, added the LaborHed and EmpBasic
tables. The relation between them was added automatically.

In Display -> Column Select, choose a bunch of columns to display -
name, status, payroll from EmpBasic, and a bunch of dates and times from
the LaborHed table.

In Display -> Filter Results, entered these criteria, one row at a time:

LaborHed.ClockInDate <= BAQ special constant -> click on "special" and
choose "yesterday" for the special constant.

And LaborHed.ActualClockOutTime = specified constant -> 0

And LaborHed.ClockOutTime = specified constant -> 0

And EmpBasic.Payroll = specified constant -> true

And EmpBasic.EmpStatus = specified constant -> A

Save, then Analyze -> Test...

Brian.

________________________________

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Chris Thompson
Sent: Monday, February 28, 2011 11:20 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Vantage - BAQ to show who is clocked in / out

Hi All

Im trying to write a BAQ to display which shopfloor employees are
clocked in and
when they clocked in.

It's basically the information that Shop Tracker > Who Is Here
information that
I need.

I can get a BAQ using LaborHed to display all shopfloor employees but I
cant get
it to tell me who is actually clocked in now.

I am wanting the BAQ so I can see who is clocked in and then who has
forgotten
to clock out (i.e. the clock in date <> today's date).

Any help would be appreciated.

Thanks.

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

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







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

Im trying to write a BAQ to display which shopfloor employees are clocked in and
when they clocked in.

It's basically the information that Shop Tracker > Who Is Here information that
I need.

I can get a BAQ using LaborHed to display all shopfloor employees but I cant get
it to tell me who is actually clocked in now.

I am wanting the BAQ so I can see who is clocked in and then who has forgotten
to clock out (i.e. the clock in date <> today's date).

Any help would be appreciated.

Thanks.




[Non-text portions of this message have been removed]
3
Hello again Chris.

LaborHed gives you payroll information, log-in to the system. You need to retrieve Clock-In date and time (clock-out time to see who's in) in the LaborDtl table.

Regards.

Roel Martinez
ERP Analyst

SABRE TUBULAR STRUCTURES (tm)
www.sabretubularstructures.com<http://www.sabretubularstructures.com/>
8653 E. Hwy 67 | Alvarado, TX 76009
Phone: 817-852-1700 ext. 11858 | Direct Line: 817-852-1858 |Fax: 817-852-1705
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Chris Thompson
Sent: Monday, February 28, 2011 10:20 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Vantage - BAQ to show who is clocked in / out



Hi All

Im trying to write a BAQ to display which shopfloor employees are clocked in and
when they clocked in.

It's basically the information that Shop Tracker > Who Is Here information that
I need.

I can get a BAQ using LaborHed to display all shopfloor employees but I cant get
it to tell me who is actually clocked in now.

I am wanting the BAQ so I can see who is clocked in and then who has forgotten
to clock out (i.e. the clock in date <> today's date).

Any help would be appreciated.

Thanks.

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



[Non-text portions of this message have been removed]
4
The "who has forgotten to clock out" report was already on my todo list
this week, so I did it for both of us. Here are the steps & details
that I did. I don't know a convenient way to summarize a BAQ in an
email and I don't believe file attachments are allowed, but I can export
the BAQ & email it to you off-list if you're on 9.05.



Created a new BAQ and in Phrase Build, added the LaborHed and EmpBasic
tables. The relation between them was added automatically.



In Display -> Column Select, choose a bunch of columns to display -
name, status, payroll from EmpBasic, and a bunch of dates and times from
the LaborHed table.



In Display -> Filter Results, entered these criteria, one row at a time:

LaborHed.ClockInDate <= BAQ special constant -> click on "special" and
choose "yesterday" for the special constant.

And LaborHed.ActualClockOutTime = specified constant -> 0

And LaborHed.ClockOutTime = specified constant -> 0

And EmpBasic.Payroll = specified constant -> true

And EmpBasic.EmpStatus = specified constant -> A



Save, then Analyze -> Test...



Brian.



________________________________

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Chris Thompson
Sent: Monday, February 28, 2011 11:20 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Vantage - BAQ to show who is clocked in / out





Hi All

Im trying to write a BAQ to display which shopfloor employees are
clocked in and
when they clocked in.

It's basically the information that Shop Tracker > Who Is Here
information that
I need.

I can get a BAQ using LaborHed to display all shopfloor employees but I
cant get
it to tell me who is actually clocked in now.

I am wanting the BAQ so I can see who is clocked in and then who has
forgotten
to clock out (i.e. the clock in date <> today's date).

Any help would be appreciated.

Thanks.

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





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