Assembly Qty completed

Yahoo Archive
1
Jasper,
I dont know if this will come through twice. Our email isn't working
well.
You have to track completed assemblies by the last operation of the
assembly.
You can tag this operation by using the checkbox in job entry.
I added an analysis code 001 'final operation complete.'
I tag the last operation from every assembly with this analysis code.
Then query by JobOper.AnalysisCode = 001 and JobOper.OpComplete = yes
The query below is a query that I use to track every assembly
completed over the last 7 days.
I display it on a dashboard.
Hope this helps
Pat Maher

for each JobOper Where JobOper.Company = cur-comp
and JobOper.AnalysisCode = '001' and
JobOper.OpComplete = yes and
JobOper.RunQty > 0 and
JobOper.LastLaborDate > (TODAY - 7) no-lock,
each JobAsmbl Where JobAsmbl.Company = JobOper.Company
and JobAsmbl.JobNum = JobOper.JobNum
and JobAsmbl.AssemblySeq = JobOper.AssemblySeq no-lock
BY JobOper.LastLaborDate:





--- In vantage@yahoogroups.com, "Jasper Recto" <jrecto@l...> wrote:
> I'm having a little trouble with the logic on this. If I have a
job that has several subassemblies, how would I determine how many
subassemblies are complete? Is there a place in vantage where I
could just look at the qty complete on a particular assembly? How
would I put that on a report?
>
> Thanks,
> Jasper
>
>
>
>
> [Non-text portions of this message have been removed]
2
I'm having a little trouble with the logic on this. If I have a job that has several subassemblies, how would I determine how many subassemblies are complete? Is there a place in vantage where I could just look at the qty complete on a particular assembly? How would I put that on a report?

Thanks,
Jasper




[Non-text portions of this message have been removed]