Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

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

Status
Not open for further replies.
Aug 20, 2015
3
US
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.
 
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.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top