Hi Aaron,
For Direct labour, if you start production activity at 14:00 and end activity at 14:30 (60 minute clock), the LaborHrs tell me that is 0.5 hr which is correct. It does this if I record a qty > 0 or = 0.
Hoever, the same does not apply for Indirect Activity. I dont see why it shouldnt. If I start Indirect Activity at 14:00 and End Activity at 14:30 (30 minutes) it doesnt allow me to record a qty, but that shouldnt make any difference. Shouldn't the LaborHrs still be 0.5 hr as that is the different between the Start and End times?
Is this working how it is supposed to be working? To me, it should calculate the LaborHrs regardless of whether it was direct or indirect labor.
Regards,
CHRIS
________________________________
From: Aaron Hoyt <aaron.hoyt@...>
To: vantage@yahoogroups.com
Sent: Monday, 20 July, 2009 16:48:21
Subject: Re: [Vantage] Vantage - Indirect Labour
Â
Chris,
The LaborDtl table is only updated when someone either Reports Quantity
(to a job and it updates LaborQty) or logs out of the activity
(calculates the time/burden, efficiency, etc) and updates the record.
You can determine the time by doing math based on the current time and
when they logged in (might be wise to include date and time), but you
will have to create a calculated field for any activity (record) that is
marked as active.
sudo code would be something like...
if LaborDtl.ActiveTran s then
current time - clockin time
else LaborDtl.LaborHrs
end
This is also true of the LaborHed table.
Aaron Hoyt
Vantage Plastics
Chris Thompson wrote:
[Non-text portions of this message have been removed]
For Direct labour, if you start production activity at 14:00 and end activity at 14:30 (60 minute clock), the LaborHrs tell me that is 0.5 hr which is correct. It does this if I record a qty > 0 or = 0.
Hoever, the same does not apply for Indirect Activity. I dont see why it shouldnt. If I start Indirect Activity at 14:00 and End Activity at 14:30 (30 minutes) it doesnt allow me to record a qty, but that shouldnt make any difference. Shouldn't the LaborHrs still be 0.5 hr as that is the different between the Start and End times?
Is this working how it is supposed to be working? To me, it should calculate the LaborHrs regardless of whether it was direct or indirect labor.
Regards,
CHRIS
________________________________
From: Aaron Hoyt <aaron.hoyt@...>
To: vantage@yahoogroups.com
Sent: Monday, 20 July, 2009 16:48:21
Subject: Re: [Vantage] Vantage - Indirect Labour
Â
Chris,
The LaborDtl table is only updated when someone either Reports Quantity
(to a job and it updates LaborQty) or logs out of the activity
(calculates the time/burden, efficiency, etc) and updates the record.
You can determine the time by doing math based on the current time and
when they logged in (might be wise to include date and time), but you
will have to create a calculated field for any activity (record) that is
marked as active.
sudo code would be something like...
if LaborDtl.ActiveTran s then
current time - clockin time
else LaborDtl.LaborHrs
end
This is also true of the LaborHed table.
Aaron Hoyt
Vantage Plastics
Chris Thompson wrote:
>[Non-text portions of this message have been removed]
>
> Hi Rob,
>
> I have attached my BAQ so far.
>
> I already have the LaborDtl as the parent and IndirectCode as the
> child and outer joined.
>
> I want to create a time analysis which will show all activities of our
> shop floor personnel.
>
> For example, I want to see which job they have worked on, when and how
> long it too them.
>
> I also want to see any Indirect Labour they are on and how long it has
> taken them.
>
> For the work they do on Jobs, the time in LaborHrs shows correctly and
> I have created a calculated field to multiply the LaborHrs by 60 and
> set them to round to the nearest minute (60min/hr not 100min/hr).
>
> However, for Indirect jobs, althought the Start and End times work,
> the LaborHrs stays at zero which is not correct.
>
> Any help would be appreciated.
>
> Regards,
>
> CHRIS
>
> ____________ _________ _________ __
> From: Rob Bucek <rbucek@dsmfg. com <mailto:rbucek% 40dsmfg.com> >
> To: vantage@yahoogroups .com <mailto:vantage% 40yahoogroups. com>
> Sent: Friday, 17 July, 2009 15:53:51
> Subject: RE: [Vantage] Vantage - Indirect Labour
>
>
> Parent table should be LaborDtl, child Indirect try IndirectCode for
> your KeyID and check the OuterJoin check box
>
> Rob Bucek
>
> Manufacturing Engineer
>
> PH: (715) 284-5376 ext 3111
>
> FAX: (715)284-4084
>
> <http://www.dsmfg com/>
>
> (Click the logo to view our site) <http://www.dsmfg com/>
>
> From: vantage@yahoogroups .com [mailto:vantage@ yahoogroups .com] On Behalf
> Of Chris Thompson
> Sent: Friday, July 17, 2009 9:43 AM
> To: vantage@yahoogroups .com
> Subject: [Vantage] Vantage - Indirect Labour
>
> Hi,
>
> I have been asked to create a BAQ which will show any Indirect Labour
> that a shopfloor employee has done.
>
> They will log this in MES in the Start Indirect Activity section.
>
> I can get it to display, when I combine the LaborDtl with the Indirect
> tables, but for any Indirect activities, the LaborDtl.Laborhrs value is
> always zero.
>
> I have tested this by leaving the user logged against Indirect Labor for
> 30 minutes and when I have checked the tables after ending the activity,
> it is displaying as 0 in the LaborHrs field.
>
> Either I have linked the wrong tables, or the system is incorrect.
>
> Any help would be appreciated.
>
> Cheers.
>
> [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]
>
>
[Non-text portions of this message have been removed]