How Do I Get There? POHeader to JobOper Table

Epicor ERP 10
1

Writing a report showing Open POs. From there I need to link to the JobOper table to grab Due Date of Operation.

Seems simple enough, but I’m stumped. Is the answer right in front of me?

In Purchase Order Tracker I can see the associated Job Number when I click the “Lines” Tab and then the “Details” Tab under that.

Field help says that the field where Job # is stored is called “CalcJobNum” but I can’t find that field anywhere.

Any advice, hive-mind?

Steven

2

POHeader.PONum>PORel.PONum>PORel.JobNum>JobOper.JobNum?

6 Likes
3

Thank you so much.

That was easy.

4

Thank you from 5 years in the future

2 Likes
5

it’s what this place is for!

1 Like