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

MillsBatman · Aug 25, 2015

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 · Oct 19, 2015

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.

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!

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

MillsBatman

MIS

wellsth

IS-IT--Management

Similar threads

Part and Inventory Search

Sponsor