Vantage 8.03.408A
Below is a BAQ that I have put together that does all but one thing I really want.
Basically I am pulling in all Parts with a specific Part Class and then pulling in Open Jobs matching those Parts. You'll see I am also pulling in ONLY Open Operations on those respective Open Jobs. In my display I am viewing the JobOper.RunQty and JobOper.QtyCompleted. I then have a Calculated Field to provide the Remaining Operation Quantity (difference between the two).
The problem comes when we run more then what is stated in JobOper.RunQty. The Completed Operations JobOper.QtyCompleted will show this (remember though Completed Operations are filtered out). To bring these lines in makes the BAQ to large.
Is there any way of seeing the JobOper.QtyCompleted from the last Completed Operation?
for each Part where (Part.ClassID = 'F026') no-lock , each JobHead where (JobHead.PartNum = Part.PartNum AND JobHead.JobComplete <> True) and (Part.Company = JobHead.Company and Part.PartNum = JobHead.PartNum) no-lock , each JobOper where (JobOper.OpComplete <> True) and (JobHead.Company = JobOper.Company and JobHead.JobNum = JobOper.JobNum) no-lock , each NonConf outer-join where (JobHead.Company = NonConf.Company and JobHead.JobNum = NonConf.JobNum) no-lock by Part.PartNum by JobHead.JobNum by JobOper.AssemblySeq by JobOper.OprSeq.
I hope that makes sense.
Jeff
Below is a BAQ that I have put together that does all but one thing I really want.
Basically I am pulling in all Parts with a specific Part Class and then pulling in Open Jobs matching those Parts. You'll see I am also pulling in ONLY Open Operations on those respective Open Jobs. In my display I am viewing the JobOper.RunQty and JobOper.QtyCompleted. I then have a Calculated Field to provide the Remaining Operation Quantity (difference between the two).
The problem comes when we run more then what is stated in JobOper.RunQty. The Completed Operations JobOper.QtyCompleted will show this (remember though Completed Operations are filtered out). To bring these lines in makes the BAQ to large.
Is there any way of seeing the JobOper.QtyCompleted from the last Completed Operation?
for each Part where (Part.ClassID = 'F026') no-lock , each JobHead where (JobHead.PartNum = Part.PartNum AND JobHead.JobComplete <> True) and (Part.Company = JobHead.Company and Part.PartNum = JobHead.PartNum) no-lock , each JobOper where (JobOper.OpComplete <> True) and (JobHead.Company = JobOper.Company and JobHead.JobNum = JobOper.JobNum) no-lock , each NonConf outer-join where (JobHead.Company = NonConf.Company and JobHead.JobNum = NonConf.JobNum) no-lock by Part.PartNum by JobHead.JobNum by JobOper.AssemblySeq by JobOper.OprSeq.
I hope that makes sense.
Jeff