Hi,
I would like to pull through the Final Operation that is for a Make Direct Part to see if the job has been completed. The Final Operation tick box isn’t a field so not sure how to do this for non-inventory parts.
How do I go about doing this?
Regards
Jack
In your query, use the MAX function to pull back the highest operation sequence.
I believe the FinalOpr field is on JobAsmbl if that helps
1 Like
It is a field on JobAsmbl, but when not selected ( = 0 ), Epicor knows to resort to the last operation by sequence.
So to reproduce, you’ll need the Case where the final operation is selected then use that one, else your going to need MAX operation sequence.
From a recent BAQ example that I was working on…
case JobAsmbl.FinalOpr
when 0 then max(JobOper.OprSeq)
else JobAsmbl.FinalOpr
end
