Silly Question (2 man crews)

Yahoo Archive
1
Depends on how you set-up the labor entry in the BOM. If the labor entry is quantity only (where you don't enter time) then it's better to split the quantity so both crewmembers get time credit. If, as it appears, both time and quantity is entered, Vantage allows one person to enter quantity and time while the other enters only his time against the operation. This may be appropriate where one person in a crew has reporting responsibilities.

HTH,
Gil Amilbangsa
Australian Healthcare Equipment - Murphy Furniture
gil.amilbangsa@...

-----Original Message-----
From: Shirley Graver [mailto:shirleyg@...]
Sent: Wednesday, 13 August 2003 1:30 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Silly Question (2 man crews)



We are trying out data collection. I have an operation that is a two
man crew. Do both crew clock in as direct labor to the job. When they
clock out do they split production between them or all production to one
crew.

Shirley Graver
Sys Admin
Rubber Associates

Tracking #: 198124CB5119AC4F887522E244A997899C063A25


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



Yahoo! Groups Sponsor

ADVERTISEMENT
<http://rd.yahoo.com/M=251812.3170658.4537139.1261774/D=egroupweb/S=1705007183:HM/A=1693353/R=0/SIG=11t71ok4g/*http://www.netflix.com/Default?mqso=60178294&partid=3170658> click here
<http://us.adserver.yahoo.com/l?M=251812.3170658.4537139.1261774/D=egroupmail/S=:HM/A=1693353/rand=531265252>

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

Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service <http://docs.yahoo.com/info/terms/> .




[Non-text portions of this message have been removed]
2
I need a little Report Builder help, please! I need to create a report
that will show all jobs that have one certain operation: Sonic Slitting.
The report will need to show detail of all operations on these particular
jobs, but I only want jobs that have this operation.

I know I can filter for that operation, but I then lose all the operations
for the detail of the report. I'm hoping it's something easy that I
haven't thought of. Any ideas?

Gary Grenier
IT Manager
Bell Manufacturing Co.
207-784-2961 x245
mailto:ggrenier@...
3
Start with JobOper as the master table, join to the JobHead.
Filter for the certain operation you want.
Create a join from JobHead to JobOper with the alias of JobOper2.
Now for each operation you filtered for you get the job and all the
operation for the job.
Group and sort by job. Show the job number on the group header line and all
the operation on the record line.

Have fun.

Patrick Winter


-----Original Message-----
From: ggrenier@... [mailto:ggrenier@...]
Sent: Monday, August 11, 2003 3:13 PM
To: vantage@yahoogroups.com
Subject: [Vantage] RB - Jobs with Operation


I need a little Report Builder help, please! I need to create a report that
will show all jobs that have one certain operation: Sonic Slitting. The
report will need to show detail of all operations on these particular jobs,
but I only want jobs that have this operation.

I know I can filter for that operation, but I then lose all the operations
for the detail of the report. I'm hoping it's something easy that I haven't
thought of. Any ideas?

Gary Grenier
IT Manager
Bell Manufacturing Co.
207-784-2961 x245
mailto:ggrenier@...



------------------------ Yahoo! Groups Sponsor ---------------------~--> Buy
Ink Cartridges or Refill Kits for Your HP, Epson, Canon or Lexmark Printer
at Myinks.com. Free s/h on orders $50 or more to the US & Canada.
http://www.c1tracking.com/l.asp?cid=5511
http://us.click.yahoo.com/l.m7sD/LIdGAA/qnsNAA/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

Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
4
There might be a simpler way but I think I would try checking each operaiton on a job and setting a counter to 1 if the target oper is found otherwise 0, then pre-pass aggregate on the counter (reset on job). If the counter > zero you know the job has that oper in it and can conditionally print that job's details.
-Todd C.

-----Original Message-----
From: ggrenier@... [mailto:ggrenier@...]
Sent: Monday, August 11, 2003 3:13 PM
To: vantage@yahoogroups.com
Subject: [Vantage] RB - Jobs with Operation


I need a little Report Builder help, please! I need to create a report
that will show all jobs that have one certain operation: Sonic Slitting.
The report will need to show detail of all operations on these particular
jobs, but I only want jobs that have this operation.

I know I can filter for that operation, but I then lose all the operations
for the detail of the report. I'm hoping it's something easy that I
haven't thought of. Any ideas?

Gary Grenier
IT Manager
Bell Manufacturing Co.
207-784-2961 x245
mailto:ggrenier@...




Yahoo! Groups Sponsor

ADVERTISEMENT
<http://rd.yahoo.com/M=244522.3656190.4921519.1261774/D=egroupweb/S=1705007183:HM/A=1595054/R=0/SIG=1246b0b92/*http://ashnin.com/clk/muryutaitakenattogyo?YH=3656190&yhad=1595054> Click Here!
<http://us.adserver.yahoo.com/l?M=244522.3656190.4921519.1261774/D=egroupmail/S=:HM/A=1595054/rand=837706427>

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

Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service <http://docs.yahoo.com/info/terms/> .




[Non-text portions of this message have been removed]
5
Have fun? I certainly did! That worked, thank you. I never joined a
table in a report, twice, like that. Didn't know it was possible! I don't
remember learning that in the RB class...

Thanks again!

Gary Grenier

From: pjw@...
Subject: RE: RB - Jobs with Operation

Start with JobOper as the master table, join to the JobHead.
Filter for the certain operation you want.
Create a join from JobHead to JobOper with the alias of JobOper2.
Now for each operation you filtered for you get the job and all the
operation for the job.
Group and sort by job. Show the job number on the group header line and all
the operation on the record line.

Have fun.

Patrick Winter
6
If you really want to blow your mind with joining tables back to themselves,
look at the BOM RB report that is in the files section of this list. I
think that does a circle about 7 times.

Aaron Hoyt

-----Original Message-----
From: ggrenier@... [mailto:ggrenier@...]
Sent: Tuesday, August 12, 2003 11:23 AM
To: vantage@yahoogroups.com
Subject: [Vantage] RE: RB - Jobs with Operation



Have fun? I certainly did! That worked, thank you. I never joined a
table in a report, twice, like that. Didn't know it was possible! I don't
remember learning that in the RB class...

Thanks again!

Gary Grenier

From: pjw@...
Subject: RE: RB - Jobs with Operation

Start with JobOper as the master table, join to the JobHead.
Filter for the certain operation you want.
Create a join from JobHead to JobOper with the alias of JobOper2.
Now for each operation you filtered for you get the job and all the
operation for the job.
Group and sort by job. Show the job number on the group header line and all
the operation on the record line.

Have fun.

Patrick Winter




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

Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
7
We are trying out data collection. I have an operation that is a two
man crew. Do both crew clock in as direct labor to the job. When they
clock out do they split production between them or all production to one
crew.

Shirley Graver
Sys Admin
Rubber Associates

Tracking #: 198124CB5119AC4F887522E244A997899C063A25


[Non-text portions of this message have been removed]
8
Actually Aaron I think I put eight tail swallowing joins on that one.

Shirley

-----Original Message-----
From: Aaron Hoyt [mailto:aaron.hoyt@...]
Sent: Tuesday, August 12, 2003 11:27 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] RE: RB - Jobs with Operation

If you really want to blow your mind with joining tables back to
themselves,
look at the BOM RB report that is in the files section of this list. I
think that does a circle about 7 times.

Aaron Hoyt

-----Original Message-----
From: ggrenier@... [mailto:ggrenier@...]
Sent: Tuesday, August 12, 2003 11:23 AM
To: vantage@yahoogroups.com
Subject: [Vantage] RE: RB - Jobs with Operation



Have fun? I certainly did! That worked, thank you. I never joined a
table in a report, twice, like that. Didn't know it was possible! I
don't
remember learning that in the RB class...

Thanks again!

Gary Grenier

From: pjw@...
Subject: RE: RB - Jobs with Operation

Start with JobOper as the master table, join to the JobHead.
Filter for the certain operation you want.
Create a join from JobHead to JobOper with the alias of JobOper2.
Now for each operation you filtered for you get the job and all the
operation for the job.
Group and sort by job. Show the job number on the group header line and
all
the operation on the record line.

Have fun.

Patrick Winter




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/.
<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

Your use of Yahoo! Groups is subject to
http://docs.yahoo.com/info/terms/








Yahoo! Groups Sponsor


ADVERTISEMENT

<http://rd.yahoo.com/M=251812.3170658.4537139.1261774/D=egroupweb/S=1705
007183:HM/A=1693352/R=0/SIG=11tralmvc/*http:/www.netflix.com/Default?mqs
o=60178293&partid=3170658> click here


<http://us.adserver.yahoo.com/l?M=251812.3170658.4537139.1261774/D=egrou
pmail/S=:HM/A=1693352/rand=982008187>

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/.
<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

Your use of Yahoo! Groups is subject to the Yahoo!
<http://docs.yahoo.com/info/terms/> Terms of Service.

Tracking #: EE80D85E800A3D4D9EB94155E76A110814F31FA5


[Non-text portions of this message have been removed]
9
Yep have them both clock in. When you say split production I assume you
mean "how many did you complete?" if so you need to make a call on how
to handle that. I would suggest you have each do 50%, if you rely on
one or the other to enter the whole amount, someone will usually forget.

Dan Tisone
Operations / IT Consultant
dan.tisone@...






-----Original Message-----
From: Shirley Graver [mailto:shirleyg@...]
Sent: Tuesday, August 12, 2003 8:30 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Silly Question (2 man crews)



We are trying out data collection. I have an operation that is a two
man crew. Do both crew clock in as direct labor to the job. When they
clock out do they split production between them or all production to one
crew.

Shirley Graver
Sys Admin
Rubber Associates

Tracking #: 198124CB5119AC4F887522E244A997899C063A25


[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

Your use of Yahoo! Groups is subject to
http://docs.yahoo.com/info/terms/
10
We have a three man crew that clocks in and out of the operation
individually. They split the total quantity complete among themselves. Ex.
600pcs complete = 200pcs/man. We have been doing this for over a year and
it works well.

Tom Ford
Cost Accountant
Mid-West Spring and Stamping

-----Original Message-----
From: Shirley Graver [mailto:shirleyg@...]
Sent: Tuesday, August 12, 2003 10:30 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Silly Question (2 man crews)


We are trying out data collection. I have an operation that is a two
man crew. Do both crew clock in as direct labor to the job. When they
clock out do they split production between them or all production to one
crew.

Shirley Graver
Sys Admin
Rubber Associates

Tracking #: 198124CB5119AC4F887522E244A997899C063A25


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




Yahoo! Groups Sponsor
ADVERTISEMENT
click here
<http://rd.yahoo.com/M=251812.3170658.4537139.1261774/D=egroupweb/S=17050071
83:HM/A=1693353/R=0/SIG=11t71ok4g/*http://www.netflix.com/Default?mqso=60178
294&partid=3170658>


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

Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service
<http://docs.yahoo.com/info/terms/> .


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