I would like to be able to report downtime on a Resource, but when the operator is logged into more than one resource at a time, the system wants to apply the downtime to every job the operator is logged into. How can I log downtime against just the resource? I am trying to track downtime by downtime codes for each machine in our primary operation. Any help would be greatly appreciated.
We do this here VIA Indirect Activities.
By default an indirect activity is reported against an entire resource group, but we pop up a BPM form asking for the ResourceID and use that in reporting.
We did ours (and the rest of our production reporting) in Access.
We used indirect like @hackaphreaka mentioned above.
Tables LaborDtl, OpMaster and Indirect.
LaborDtl to OpMaster (join by Company and OpCode)
LaborDtl to Indirect (join by Company and IndirectCode)
SQL code here
SELECT Erp_LaborDtl.Downtime, Erp_LaborDtl.Company, Erp_LaborDtl.RefJobNum, Erp_LaborDtl.OpCode, Erp_OpMaster.OpDesc, Erp_Indirect.IndirectCode, Erp_Indirect.Description, Erp_LaborDtl.LaborNote, Erp_LaborDtl.EmployeeNum, CDate([ClockInDate]) AS ClockDate, Erp_LaborDtl.DspClockInTime, Erp_LaborDtl.DspClockOutTime, [ClockOutTime]-[ClockInTime] AS Hours
FROM (Erp_LaborDtl INNER JOIN Erp_OpMaster ON (Erp_LaborDtl.OpCode = Erp_OpMaster.OpCode) AND (Erp_LaborDtl.Company = Erp_OpMaster.Company)) INNER JOIN Erp_Indirect ON (Erp_LaborDtl.IndirectCode = Erp_Indirect.IndirectCode) AND (Erp_LaborDtl.Company = Erp_Indirect.Company)
WHERE (((Erp_LaborDtl.Downtime)=True));
1 Like
Thank you, that’s helpful information.
John,
Thank you for the information and for the SQL code. I’ll have my IT guys give it a whirl!
1 Like