I currently have a BAQ built that gives me sale order number, the part number associated and all the job numbers. I have the opseq that is has been clocked in for a given job but can’t seem to pull the remaining operation (which hasn’t been clocked in yet). Any ideas on how I can go about this?
JobOper table should show you all the operations for the job.
Actual labor hrs reported = (JobOper.ActualSetupHours + JobOper.ActProdHours)
Total Qty for the job operation = JobOper.RunQty
Total Qty Completed = JobOper.QtyCompleted