Resource has vanished

Epicor ERP 10
1

When we started work yesterday morning we had 3 Assembly resources at in our resource group assembly. Around 10:00 AM, one of them vanished. Has anyone seen this?

2

Hi Shawn, was there any labor transactions against that resource in the past? Maybe someone deleted it? If there were transactions maybe someone utilized the Move Resource option?
image
Seems super strange to have just vanished.

3

There were transactions in the past. Including that same morning! I will investigate the move resource - good call.

Any suggestions on how to do this?

4

The Move Resource allows a resource to be placed in another Resource Group. You would have to search through the other groups to see if you can find it. If the Resource ID is known then a simple query through a BAQ should get you there pretty quick.
Another thought, could someone have inadvertently checked the Inactive box?

5

You were right! Somehow it got moved.! Do you know how I can move it back to the correct site?
I see the move Resouce button, but no site option.

1 Like
6

It is giving me this error:

The resource ASSEMBLYC1 cannot be moved to a resource group ASSEMBLY in other site (AT02). Open shop load for this resource in the current site.

7

image
image783Ă—511 24.2 KB

8

You need to run some queries on ResourceTimeUsed for that resource to find the job(s) that got scheduled and use remove from schedule on those jobs, so you can move the resource back.

1 Like
9

Thanks Greg,

I did do that, however, there are still some jobs in the shop load . The trouble is I cannot see the jobs. The ones with the ResourceGrpID : ASSM are the problems. ANy idea how I can find out what Jobs these are coming from?

image
image1894Ă—603 44.1 KB

1 Like
10

Is that ResourceTimeUsed? The primary key for that table has JobNum in it.

If you have SSMS and can do a quick select for the ASSM resource it should show you the jobs. If not make a simple BAQ that just dumps ResourceTimeUsed for ASSM.

11

@gpayne has you on the right track here. Scary thing is how someone would “accidently” move a resource to a different site. You may want to check into the menu security for this to avoid future issues.

2 Likes