BAQ to return scheduled resource on a op 10 of a job

Epicor ERP 10
1

image
image.png1038×780 31.3 KB

As you can see in the screenshot the binding for this tab is not straight forward.
Would anyone know how in a BAQ I can reference a job, an op in that job, the op detail for that op and find what resource is scheduled so that I can return the resourceID?

Thanks,
Eric

2

I have got a dashboard for this, here is the BAQ, it maybe contains things that you don’t need to link. so just trim it to your need.

image
image.png988×569 17.3 KB

111-ScheduledResource.baq (41.3 KB)

3

Erp.ResourceTimeUsed has which resources are actually scheduled for a particular operation. It contains the JobNum, AssemblySeq, OprSeq, REsourceGroupID, and ResourceID. It may also have the OpDtlSeq, but I’m not sure of that off the top of my head.

1 Like
4

thanks tyler! That table had the exact info I needed.