How to create a BAQ that provides Parents jobs and child jobs

Epicor ERP 10
, ,
1

Goal is to get a list of all jobs related to sales order, since MRP does not populated project ID to child jobs via make direct flag, i need to pull out a report for all children jobs and DMT in the project ID.

If you guys have a BAQ or a way to link child jobs with project ID.

Thanks

2

For Production jobs, the linking sequence goes OrderRel > JobProd. Any Make Direct sales order release will link to its job via this path.

For Project jobs (jobs created directly from within Project Entry), there is a Project ID field in the JobHead table.