Issue where LaborHrs = 0

Kinetic ERP
1

I’m having an issue where our laborHrs is coming back as 0 despite there being clock in and clock out date/time. I’ve turned off all BPMs on labor update and end activity and still the same issue. The only real trend I’m seeing is that these entries all say false for WorkflowComplete. This is not happening across the board. Just on certain jobs. Any thoughts?

1 Like
2

LaborQty is not Labor hours. It is the number of pieces they document as having completed. Are you sure you are looking at the right field? Do you require users to input a quantity when completing an operation? Are you backflushing quantities?

3

So we do not require inputting a quantity (it can be 0). We do allow for backflushing quantities. And my bad. Its labor Hours we are getting 0 on.

1 Like
4

LaborQty is the quantity they reported as complete, so if you don’t require it, then it is not weird that there is a 0 there. Double check your operations, make sure backflushing is turned on. I think backflush doesn’t happen until the next operation that gets completed.

5

Yeah that was my bad. Its actually LaborHrs that we are getting 0 on that we expect to not have 0.

For example:

image
I’d expect labor hours to have SOMETHING here

1 Like
6

This BAQ shows you all the labor entries in the last 90 days that have 0 laborhrs. look them over and find a pattern to help solve this problem. Could it be only certain resource groups, or operations?


select  
	[LaborHed].[EmployeeNum] as [LaborHed_EmployeeNum], 
	[LaborHed].[PayrollDate] as [LaborHed_PayrollDate], 
	[LaborHed].[ClockInDate] as [LaborHed_ClockInDate], 
	[LaborHed].[ClockInTime] as [LaborHed_ClockInTime], 
	[LaborHed].[ClockOutTime] as [LaborHed_ClockOutTime], 
	[LaborHed].[PayHours] as [LaborHed_PayHours], 
	[LaborDtl].[LaborType] as [LaborDtl_LaborType], 
	[LaborDtl].[JobNum] as [LaborDtl_JobNum], 
	[LaborDtl].[AssemblySeq] as [LaborDtl_AssemblySeq], 
	[LaborDtl].[OprSeq] as [LaborDtl_OprSeq], 
	[LaborDtl].[JCDept] as [LaborDtl_JCDept], 
	[LaborDtl].[ResourceGrpID] as [LaborDtl_ResourceGrpID], 
	[LaborDtl].[OpCode] as [LaborDtl_OpCode], 
	[LaborDtl].[LaborHrs] as [LaborDtl_LaborHrs], 
	[LaborDtl].[BurdenHrs] as [LaborDtl_BurdenHrs], 
	[LaborDtl].[LaborQty] as [LaborDtl_LaborQty], 
	[LaborDtl].[ScrapQty] as [LaborDtl_ScrapQty] 

from Erp.LaborHed as [LaborHed]
left outer join Erp.LaborDtl as [LaborDtl] on 
	  LaborHed.Company = LaborDtl.Company
	and  LaborHed.LaborHedSeq = LaborDtl.LaborHedSeq
	and ( LaborDtl.LaborHrs = 0  )
where (LaborHed.PayrollDate >= dateadd(day, -90, Constants.Today))

NoLabor90Days.baq (10.6 KB)

7

Make sure to add LaborDtl_WFComplete to that BAQ I posted to see if that has any bearing.

8

It was that we had Production Standard set to 0!!!

1 Like