I need to find the source of epibinding in Epicor 9.05.700 for job tracker/job details/operations/sc

[MillsBatman]

I keep losing my resources when the BOM is changed with material or the revision is changed. It is happening at the job tracker/job details/operations/scheduling resources/scheduled resources. I need to know how to build a report that can show me how to find this information without looking through all of my open jobs.

 

[wellsth]

You need to create a query on JobOpDtl. Bring in the company, Jobnum, Assemblyseq,Oprseq, and Opdtlseq. On OpDtlSeq change the Total line to "Count". Save the query, and create a new query joining the JobOper table and the Query you just created. From JobOper bring in the company, JobNum, AssemblySeq, OprSeq, and from you query bring in field CountOfOpDtlSeq. When you run the query the CountOfOpDtlSeq field will be blank the operations with the missing resources.