Is there a way to find any jobs that have not labor detail. We would like a report or dashboard that would locate jobs that have been released, but for some reason, never worked on.
You could create a BAQ that looks at JobHead where the released flag is set and the job number is not found in LaborDtl. Then use that BAQ for a dashboard.
-Jeff
Thank you. I’m a basic user. I created a baq with jobhead and labor dtl. I added criteria to pull jobs not completed, released and having a start date earlier than 5 days ago. I’ve tried all the different join options for the tables but am not able to pull just jobs not present in the labor detail but it does include those jobs. So I copied to excel and filtered there. Anything else is beyond my scope of knowledge. Are the steps to pull just jobs not in labordtl simple to describe? if not, the excel will work for now. I appreciate your help!
You could query the JobAsmbl table specifically where TLAProdHours > 0. If your jobs have more than one assembly, you would need to group by job number and then summarize that column in your dashboard.
In addition to what others have already mentioned.
Here is an example you could try and import.
CUS-JobNoLab.baq (29.7 KB)
Note that I just can’t help taking the Rube Goldberg approach sometimes.
So the other suggestions would be cleaner than this, just not as “interesting” to me.