Job planned resource vs scheduled resource

[aidenhoffman]

Hi everyone,

I have jobs that can be scheduled to machines that are not always their primary resource/planner.
I’m trying to find the table & linkage so I can create a BAQ showing the resource a job is released to.

In the image below I have a job with a primary resource of machine 6, but it was released to machine 7.
This job shows up in the work queue for machine 7. (2nd image, 2nd line)

Below that are the tables I’ve been looking through but I only find references to machine 6.
Any thoughts or feedback would be appreciated, thank you!

[jkane (John Kane)]

Are both resources in the same resource group?

[mbilodeau (Mathieu Bilodeau)]

In your first screenshot, the “planner” field is not the resource and has no impact on the schedule.

Anyway, take a look at erp.resourcetimeused table, you will find your operation assigned to machine 7.

[aidenhoffman]

‘ResourceTimeUsed’ table is what I needed! thank you @mbilodeau

Both resources are in the same group and I will read up on the difference between planners and resources.

[MikeGross]

In Job Entry -. Manufacturing → Operations you’ll see a Scheduling Resources tab. and if you click on that, the next level down appears with a tab called Scheduled Resources. (This is all ‘classic’ interface).

Scheduling - this is what you asked for - either from the MOM or from manual entry.
Scheduled - this is what the scheduler decided (Erp.ResourceTimeUsed table).

It should be noted that you should only have ONE option on the Scheduling tab - Capability, Resource, or Resource Group. If you have two things listed, the scheduler cannot(potentially) fulfill both requirements at the same time when run in Finite mode.

If you add Capability in there, there is an extra layer of complexity with priorities, links to resources, and all that.