Wip report

Yahoo Archive
1
Jasper,

You are going to have trouble because you will not have "active"
transactions entering them manually.
You might want to do the same type of thing, but use the payroll date from
the labor detail and make it "today" or today-1 or something similar. This
should help you get to a query that shows the labor, and therefore the job
at each machine.
Good luck,
Aaron Hoyt
Vantage Plastics

-----Original Message-----
From: Jasper Recto [mailto:jrecto@...]
Sent: Friday, October 29, 2004 9:07 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Wip report



THANK YOU!!

Jasper

-----Original Message-----
From: pjw@... [mailto:pjw@...]
Sent: Friday, October 29, 2004 9:02 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Wip report



Jasper,

Here is a copy of my query to show what's clocked in on setup on the shop
floor, first it was done with the wizard.
Next I basically added report builder type fitter items to each join area
Example "and LaborDetail.ActiveTrans = yes" etc....

Notice to I created Outer-joins - I did this so I could use this script for
Setup, Production or Indirect Labor. I just cut copied and pasted this in
the separate queries for each.

Also notice I changed the "EACH JobOper" to "First JobOper" to speed up
outer joins where I just wanted the first record. This is a little
performance tip I guess.

Also notice I created the EmpBasic join to display employee names which the
wizard does not do.



for each LaborDtl Where LaborDtl.Company = cur-comp
and LaborDtl.ActiveTrans = yes
and LaborDtl.LaborType = "S" no-lock,
First LaborHed Where LaborHed.Company = LaborDtl.Company
and LaborHed.LaborHedSeq = LaborDtl.LaborHedSeq no-lock,
First EmpBasic Where LaborHed.Company = EmpBasic.Company
and LaborHed.EmployeeNum = EmpBasic.EmpID,
First JobOper outer-join no-lock Where JobOper.Company = LaborDtl.Company
and JobOper.JobNum = LaborDtl.JobNum
and JobOper.AssemblySeq = LaborDtl.AssemblySeq
and JobOper.OprSeq = LaborDtl.OprSeq,
First JobHead Outer-join no-lock Where JobHead.Company = LaborDtl.Company
and JobHead.JobNum = LaborDtl.JobNum
BY LaborHed.PayrollDate
BY LaborDtl.WCCode:


Patrick Winter
sSc Specialty Screw Corporation
Vantage 6.10.514, Progress 9.1D08, Windows 2003 Server, Crystal 8.5.3.975




-----Original Message-----
From: Jasper Recto [mailto:jrecto@...]
Sent: Friday, October 29, 2004 7:49 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Wip report


We are on 5.2 and are not using data collection. We're still entering the
times sheets daily. How would you make it into a dashboard query in 6.1?
This would be most helpful even though there is a time lag between when the
job is done and when they enter in the time cards. Eventually, we will
start using data collection. Hopefully by the end of the year! How would
you make the query?

Thanks,
Jasper

-----Original Message-----
From: pjw@... [mailto:pjw@...]
Sent: Friday, October 29, 2004 8:38 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Wip report



Jasper,

What version of vantage are you on and are you using data collection. This
makes for a great dashboard query.


Patrick Winter


-----Original Message-----
From: Jasper Recto [mailto:jrecto@...]
Sent: Thursday, October 28, 2004 2:47 PM
To: Vantage Groups (E-mail)
Subject: [Vantage] Wip report


How would I create a report that could tell me on a daily basis what job is
running at each machine?
Any Ideas?

Thanks,
Jasper




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



------------------------ Yahoo! Groups Sponsor --------------------~--> Make
a clean sweep of pop-up ads. Yahoo! Companion Toolbar.
Now with Pop-Up Blocker. Get it for free!
http://us.click.yahoo.com/L5YrjA/eSIIAA/yQLSAA/PhFolB/TM
--------------------------------------------------------------------~->

Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have
already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and
Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links
Yahoo! Groups Links









Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have
already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and
Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links
Yahoo! Groups Links










Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have
already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and
Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links
Yahoo! Groups Links









Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have
already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and
Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links
Yahoo! Groups Links










Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have
already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and
Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links
Yahoo! Groups Links
2
How would I create a report that could tell me on a daily basis what job is running at each machine?
Any Ideas?

Thanks,
Jasper




[Non-text portions of this message have been removed]
3
Try using the JobOpMac table if you are in 6.1. It shows you job
number and machineID. I think from there you can get Machine name
from Machine Table.

--- In vantage@yahoogroups.com, "Jasper Recto" <jrecto@l...> wrote:
> How would I create a report that could tell me on a daily basis
what job is running at each machine?
> Any Ideas?
>
> Thanks,
> Jasper
>
>
>
>
> [Non-text portions of this message have been removed]
4
If you are using Data collection, base it off the LaborDtl table, filter by
active labor transaction.
You can link to about anywhere from there.
Good luck,
Aaron Hoyt
Vantage Plastics

-----Original Message-----
From: Jasper Recto [mailto:jrecto@...]
Sent: Thursday, October 28, 2004 3:47 PM
To: Vantage Groups (E-mail)
Subject: [Vantage] Wip report



How would I create a report that could tell me on a daily basis what job is
running at each machine?
Any Ideas?

Thanks,
Jasper




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




Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have
already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and
Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links
Yahoo! Groups Links
5
Jasper,

What version of vantage are you on and are you using data collection. This
makes for a great dashboard query.


Patrick Winter


-----Original Message-----
From: Jasper Recto [mailto:jrecto@...]
Sent: Thursday, October 28, 2004 2:47 PM
To: Vantage Groups (E-mail)
Subject: [Vantage] Wip report


How would I create a report that could tell me on a daily basis what job is
running at each machine?
Any Ideas?

Thanks,
Jasper




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



------------------------ Yahoo! Groups Sponsor --------------------~--> Make
a clean sweep of pop-up ads. Yahoo! Companion Toolbar.
Now with Pop-Up Blocker. Get it for free!
http://us.click.yahoo.com/L5YrjA/eSIIAA/yQLSAA/PhFolB/TM
--------------------------------------------------------------------~->

Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have
already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and
Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links
Yahoo! Groups Links
6
We are on 5.2 and are not using data collection. We're still entering the times sheets daily. How would you make it into a dashboard query in 6.1? This would be most helpful even though there is a time lag between when the job is done and when they enter in the time cards. Eventually, we will start using data collection. Hopefully by the end of the year! How would you make the query?

Thanks,
Jasper

-----Original Message-----
From: pjw@... [mailto:pjw@...]
Sent: Friday, October 29, 2004 8:38 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Wip report



Jasper,

What version of vantage are you on and are you using data collection. This
makes for a great dashboard query.


Patrick Winter


-----Original Message-----
From: Jasper Recto [mailto:jrecto@...]
Sent: Thursday, October 28, 2004 2:47 PM
To: Vantage Groups (E-mail)
Subject: [Vantage] Wip report


How would I create a report that could tell me on a daily basis what job is
running at each machine?
Any Ideas?

Thanks,
Jasper




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



------------------------ Yahoo! Groups Sponsor --------------------~--> Make
a clean sweep of pop-up ads. Yahoo! Companion Toolbar.
Now with Pop-Up Blocker. Get it for free!
http://us.click.yahoo.com/L5YrjA/eSIIAA/yQLSAA/PhFolB/TM
--------------------------------------------------------------------~->

Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have
already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and
Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links
Yahoo! Groups Links









Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and Crystal Reports and other 'goodies', please goto: http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto: http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto: http://groups.yahoo.com/group/vantage/links
Yahoo! Groups Links
7
Jasper,

Here is a copy of my query to show what's clocked in on setup on the shop
floor, first it was done with the wizard.
Next I basically added report builder type fitter items to each join area
Example "and LaborDetail.ActiveTrans = yes" etc....

Notice to I created Outer-joins - I did this so I could use this script for
Setup, Production or Indirect Labor. I just cut copied and pasted this in
the separate queries for each.

Also notice I changed the "EACH JobOper" to "First JobOper" to speed up
outer joins where I just wanted the first record. This is a little
performance tip I guess.

Also notice I created the EmpBasic join to display employee names which the
wizard does not do.



for each LaborDtl Where LaborDtl.Company = cur-comp
and LaborDtl.ActiveTrans = yes
and LaborDtl.LaborType = "S" no-lock,
First LaborHed Where LaborHed.Company = LaborDtl.Company
and LaborHed.LaborHedSeq = LaborDtl.LaborHedSeq no-lock,
First EmpBasic Where LaborHed.Company = EmpBasic.Company
and LaborHed.EmployeeNum = EmpBasic.EmpID,
First JobOper outer-join no-lock Where JobOper.Company = LaborDtl.Company
and JobOper.JobNum = LaborDtl.JobNum
and JobOper.AssemblySeq = LaborDtl.AssemblySeq
and JobOper.OprSeq = LaborDtl.OprSeq,
First JobHead Outer-join no-lock Where JobHead.Company = LaborDtl.Company
and JobHead.JobNum = LaborDtl.JobNum
BY LaborHed.PayrollDate
BY LaborDtl.WCCode:


Patrick Winter
sSc Specialty Screw Corporation
Vantage 6.10.514, Progress 9.1D08, Windows 2003 Server, Crystal 8.5.3.975




-----Original Message-----
From: Jasper Recto [mailto:jrecto@...]
Sent: Friday, October 29, 2004 7:49 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Wip report


We are on 5.2 and are not using data collection. We're still entering the
times sheets daily. How would you make it into a dashboard query in 6.1?
This would be most helpful even though there is a time lag between when the
job is done and when they enter in the time cards. Eventually, we will
start using data collection. Hopefully by the end of the year! How would
you make the query?

Thanks,
Jasper

-----Original Message-----
From: pjw@... [mailto:pjw@...]
Sent: Friday, October 29, 2004 8:38 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Wip report



Jasper,

What version of vantage are you on and are you using data collection. This
makes for a great dashboard query.


Patrick Winter


-----Original Message-----
From: Jasper Recto [mailto:jrecto@...]
Sent: Thursday, October 28, 2004 2:47 PM
To: Vantage Groups (E-mail)
Subject: [Vantage] Wip report


How would I create a report that could tell me on a daily basis what job is
running at each machine?
Any Ideas?

Thanks,
Jasper




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



------------------------ Yahoo! Groups Sponsor --------------------~--> Make
a clean sweep of pop-up ads. Yahoo! Companion Toolbar.
Now with Pop-Up Blocker. Get it for free!
http://us.click.yahoo.com/L5YrjA/eSIIAA/yQLSAA/PhFolB/TM
--------------------------------------------------------------------~->

Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have
already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and
Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links
Yahoo! Groups Links









Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have
already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and
Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links
Yahoo! Groups Links










Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have
already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and
Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links
Yahoo! Groups Links
8
THANK YOU!!

Jasper

-----Original Message-----
From: pjw@... [mailto:pjw@...]
Sent: Friday, October 29, 2004 9:02 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Wip report



Jasper,

Here is a copy of my query to show what's clocked in on setup on the shop
floor, first it was done with the wizard.
Next I basically added report builder type fitter items to each join area
Example "and LaborDetail.ActiveTrans = yes" etc....

Notice to I created Outer-joins - I did this so I could use this script for
Setup, Production or Indirect Labor. I just cut copied and pasted this in
the separate queries for each.

Also notice I changed the "EACH JobOper" to "First JobOper" to speed up
outer joins where I just wanted the first record. This is a little
performance tip I guess.

Also notice I created the EmpBasic join to display employee names which the
wizard does not do.



for each LaborDtl Where LaborDtl.Company = cur-comp
and LaborDtl.ActiveTrans = yes
and LaborDtl.LaborType = "S" no-lock,
First LaborHed Where LaborHed.Company = LaborDtl.Company
and LaborHed.LaborHedSeq = LaborDtl.LaborHedSeq no-lock,
First EmpBasic Where LaborHed.Company = EmpBasic.Company
and LaborHed.EmployeeNum = EmpBasic.EmpID,
First JobOper outer-join no-lock Where JobOper.Company = LaborDtl.Company
and JobOper.JobNum = LaborDtl.JobNum
and JobOper.AssemblySeq = LaborDtl.AssemblySeq
and JobOper.OprSeq = LaborDtl.OprSeq,
First JobHead Outer-join no-lock Where JobHead.Company = LaborDtl.Company
and JobHead.JobNum = LaborDtl.JobNum
BY LaborHed.PayrollDate
BY LaborDtl.WCCode:


Patrick Winter
sSc Specialty Screw Corporation
Vantage 6.10.514, Progress 9.1D08, Windows 2003 Server, Crystal 8.5.3.975




-----Original Message-----
From: Jasper Recto [mailto:jrecto@...]
Sent: Friday, October 29, 2004 7:49 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Wip report


We are on 5.2 and are not using data collection. We're still entering the
times sheets daily. How would you make it into a dashboard query in 6.1?
This would be most helpful even though there is a time lag between when the
job is done and when they enter in the time cards. Eventually, we will
start using data collection. Hopefully by the end of the year! How would
you make the query?

Thanks,
Jasper

-----Original Message-----
From: pjw@... [mailto:pjw@...]
Sent: Friday, October 29, 2004 8:38 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Wip report



Jasper,

What version of vantage are you on and are you using data collection. This
makes for a great dashboard query.


Patrick Winter


-----Original Message-----
From: Jasper Recto [mailto:jrecto@...]
Sent: Thursday, October 28, 2004 2:47 PM
To: Vantage Groups (E-mail)
Subject: [Vantage] Wip report


How would I create a report that could tell me on a daily basis what job is
running at each machine?
Any Ideas?

Thanks,
Jasper




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



------------------------ Yahoo! Groups Sponsor --------------------~--> Make
a clean sweep of pop-up ads. Yahoo! Companion Toolbar.
Now with Pop-Up Blocker. Get it for free!
http://us.click.yahoo.com/L5YrjA/eSIIAA/yQLSAA/PhFolB/TM
--------------------------------------------------------------------~->

Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have
already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and
Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links
Yahoo! Groups Links









Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have
already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and
Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links
Yahoo! Groups Links










Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have
already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and
Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links
Yahoo! Groups Links









Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and Crystal Reports and other 'goodies', please goto: http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto: http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto: http://groups.yahoo.com/group/vantage/links
Yahoo! Groups Links