×
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Contact US

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

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

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

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

(OP)
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.

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

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.

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close