Labor hours in Vantage

Yahoo Archive
1
I too would like to see that report. Could you post it on the group.

Kathy Hambleton
Electron Energy Corporation

-----Original Message-----
From: Wayne Cox [mailto:wmc20@...]
Sent: Thursday, July 25, 2002 4:15 PM
To: vantage@yahoogroups.com
Subject: Re: [Vantage] Labor hours in Vantage....


At 03:32 PM 7/25/2002 -0400, you wrote:
>I noticed that Job tracker uses the field JobOper.ActProdHours to summarize
>the labor hours, whereas most of the reports I inherited get their totals
>from LaborDtl.WCCode, which categorizes the hours into Work Centers. The
>problem is that the fields do not always agree. Could anyone tell me where

If you report on LaborDtl and subtotal at JobNum-AssemblySeq-OprSeq and sum
up LaborDtl.LaborHrs, you should get the same number as
JobOper.ActProdHours.

If you do the same but break at JobNum-AssemblySeq you should get the same
number as JobAsmbl.TLAProdHrs.

Breaking on Work Center won't produce consistent results, since the same WC
can be used at multiple places in the job and assembly. Also, during labor
entry you can override the work center specified on the job operation and
enter a different one (eg - machine was broken down or overloaded, so you
used an alternate.)

If you'd like, I have a report that compares job totals with the sum of the
details and lists discrepancies. the labor and burden came up
clean. Material and subcontract were a mess, however!

-Wayne Cox
Twenty Three -- Information Technology Consulting
828-685-2338





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/
1 Like
2
All,

I noticed that Job tracker uses the field JobOper.ActProdHours to summarize
the labor hours, whereas most of the reports I inherited get their totals
from LaborDtl.WCCode, which categorizes the hours into Work Centers. The
problem is that the fields do not always agree. Could anyone tell me where
differences are created? We don't use rework or set up functions, just
straight clocked hours...

TIA,

Paul
3
The JobOper.ActProdHours, I believe, total all Burden hours on the job,
perhaps you are totaling Labor hours and no burden hours in your other
reports?




[Non-text portions of this message have been removed]
4
At 03:32 PM 7/25/2002 -0400, you wrote:
>I noticed that Job tracker uses the field JobOper.ActProdHours to summarize
>the labor hours, whereas most of the reports I inherited get their totals
>from LaborDtl.WCCode, which categorizes the hours into Work Centers. The
>problem is that the fields do not always agree. Could anyone tell me where

If you report on LaborDtl and subtotal at JobNum-AssemblySeq-OprSeq and sum
up LaborDtl.LaborHrs, you should get the same number as JobOper.ActProdHours.

If you do the same but break at JobNum-AssemblySeq you should get the same
number as JobAsmbl.TLAProdHrs.

Breaking on Work Center won't produce consistent results, since the same WC
can be used at multiple places in the job and assembly. Also, during labor
entry you can override the work center specified on the job operation and
enter a different one (eg - machine was broken down or overloaded, so you
used an alternate.)

If you'd like, I have a report that compares job totals with the sum of the
details and lists discrepancies. the labor and burden came up
clean. Material and subcontract were a mess, however!

-Wayne Cox
Twenty Three -- Information Technology Consulting
828-685-2338
5
Thanks to Wayne and Sarah....

I would love to see the report you mentioned Wayne. But I must add that I
spoke too soon when posing my question. I was looking at the output of a
job in one report and comparing it to a different job on screen in Vantage.
Figures that the numbers wouldn't match.... In my defense, it is late, and
I have been celebrating my birthday for the last two days....

Paul


-----Original Message-----
From: Wayne Cox [mailto:wmc20@...]
Sent: Thursday, July 25, 2002 4:15 PM
To: vantage@yahoogroups.com
Subject: Re: [Vantage] Labor hours in Vantage....


At 03:32 PM 7/25/2002 -0400, you wrote:
>I noticed that Job tracker uses the field JobOper.ActProdHours to summarize
>the labor hours, whereas most of the reports I inherited get their totals
>from LaborDtl.WCCode, which categorizes the hours into Work Centers. The
>problem is that the fields do not always agree. Could anyone tell me where

If you report on LaborDtl and subtotal at JobNum-AssemblySeq-OprSeq and sum
up LaborDtl.LaborHrs, you should get the same number as
JobOper.ActProdHours.

If you do the same but break at JobNum-AssemblySeq you should get the same
number as JobAsmbl.TLAProdHrs.

Breaking on Work Center won't produce consistent results, since the same WC
can be used at multiple places in the job and assembly. Also, during labor
entry you can override the work center specified on the job operation and
enter a different one (eg - machine was broken down or overloaded, so you
used an alternate.)

If you'd like, I have a report that compares job totals with the sum of the
details and lists discrepancies. the labor and burden came up
clean. Material and subcontract were a mess, however!

-Wayne Cox
Twenty Three -- Information Technology Consulting
828-685-2338





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/