Invalid Site under Part Master

Epicor ERP 10
, , ,
1

We have 2 Parts in our system that have two sites:

  • The normal “Main Site”
  • A site that has no name

When I try to delete the site that has no name, I receive an error stating there are warehouse definitions for that part which must be deleted first, as shown here:

image
image1144×638 45.5 KB

So, I drill down to the Warehouse level and try to get rid of them from that site:

image
image702×360 17.2 KB

So, I decide to take a look at Part Transaction History Tracker to see what is going on in there. When I click the dropdown for the sites, it only shows the Main Site.
image

Okay - Onto the database now:

image
image931×578 44.2 KB

What can I do in order to remove those 2 invalid records from the system? I am running out of ideas here.

2

Do a search in parttran for just the parts forget the plant part that should show all part transactions related to the part.

As far as the site name, It is most likely empty in Site Maintenance, that’s why it’s not showing.

3

There are 2,669 transactions for that Part going back to 2020. But all of those are associated with the proper plant (MfgSys).

We only have 1 site - MfgSys
image

1 Like
4

PartPlant definitely does not look correct there. DF perhaps from Epicor… In the Main Site what are the warehouses? Are we illuding to the fact that the Plant field on PartPlant should be MfgSys?

5

Do you see any shared warehouses in Site Configuration?

1 Like
6

There are no shared warehouses for MfgSys :thinking:

image
image847×359 13.8 KB

1 Like
7

Not exactly, no. Those 2 parts already have MfgSys plants. They just have these 2 other ‘non existent’ plants.
image

8

If you look up the Fisher plant in the Warehse table, do you get any value in the corresponding Plant column?

There’s also a PlantShared table… anything interesting in there?

9

Nothing in Warehse that shouldn’t be there.
image

And there are no records at all in PlantShared.
image

10

you need to contact support and get a datafix for this issue. There should never be a case where the site field is blank.

1 Like
11

I believe that you can actually have a site name that “Appears” to be blank, however it is “space bar”

image
image1017×731 24.6 KB

this is just a guess, but the screenshot shows that the system wants to know if I want to “Add new?”

12

But that would still cause it to appear in the database though, right?

image

When I look at the Erp.Plant table, the only thing there is MfgSys (Main Site).