Last operation start date

Epicor ERP 9
, , , ,
1

Hello,

i’ am using the jobasmbl table and jobopertabel to pull my final opr start date, i’ am not sure if that data i’ am seeing is correct,

what would be the best method of pulling the start date of th final operation and would i need to filter any date on this?

Thanks

2

Do you use Final Operation in your MOMs…if so Query

for each JobAsmbl no-lock ,
each JobOper no-lock where
(JobAsmbl.Company = JobOper.Company and
JobAsmbl.JobNum = JobOper.JobNum and
JobAsmbl.AssemblySeq = JobOper.AssemblySeq ) and

CRITERIA
JobOper.OprSeq = JobAsmbl.FinalOpr .

1 Like