Assigning multiple warehouse to a part/Bulk updating part warehouses?

Kinetic ERP
1

Hello, are there any issues with assigning a part multiple warehouses?

We are going to be redoing our warehouse/bin locations and were wondering if adding a second warehouse to a part would cause any issues?

Also is there a way to bulk add a warehouse/change the primary warehouse for a product group?

Is it as simple as writing a sql statement to update the warehouseCode field in the PartWhse table or are there secondary tables that also need updated or a better way within epicor itself to do that?

2

STOP

3

Oh man, no, no way no. No SQL. I mean, this isn’t even some fringe case bug you are trying to fix, or some UD table with hundreds of thousands of rows that you are trying to bulk empty or something. This is just a normal task. Words can’t even express the damage that would be done this way.

Anyway, use DMT if you have it. Or make an updatable BAQ if you don’t have DMT.

4

Now that we’re done ribbing you, shouldn’t be a problem to add additional.

When you get there, we’ll try to help.

5

So the adding the second warehouse was just a question if doing so would cause issues?

If it wouldn’t actually cause any issues then we would need to do this for 1000s of parts.

Is the only way to do this easily thru DMT?

Also thank you for your response.

6

So the first example was just a question if adding a second warehouse would cause a problem for a part.

The second issue would be is there a way to do this for 1000s of parts easily without DMT or is DMT the only really viable solution.

Also thank you for your response

7

We use multiple warehouses for parts, and we don’t have any known problems that I know of.
I will admit, our usage of them is simple, so I will defer to others what the real ramifications
of that are.

The second part could probably be done with DMT, but as I don’t have DMT, I can’t speak to that.

It could also be done with a dashboard, and a BAQ, but a cursory glance looks like it would
require some custom programming for the update, but I could be wrong.

8

Well, yes, that’s the purpose of it. If a person (you) have not assigned warehouse X to a part, then that part cannot be transferred into warehouse X. It’s meant to control things.

Of course, people here find it a nuisance. I mean, our people are going to shoot first and then do the paperwork. If they can’t do the paperwork, they often will just give up (but not undo the physical movement…).

So, I don’t love it, but some do.

Easily, yes. As @klincecum said, there are adventurous ways to do this, too.

Do you not have DMT? It’s cheap and REALLY worth it. It’s easy to use also.

1 Like
9

Thanks for the reply, it looks like we have the data management tool licensed but not enabled. So I will work on resolving that and going forward from there.

Thank you.

10

Hi Thomas,

We have particular parts where we assigned two warehouses in Epicor. We did this mostly because we wanted to be able to assign two primary bins to the parts. One primary bin was to be the main receiving bin then the second primary bin was to be the shop cell bin for mfg. The difficulty with this arises in that the default bin for receiving, shipping, issuing to jobs will come from the plant / primary warehouse / primary bin. We needed to do BPM to help us use the cell mfg bin for job issues of mtls. since it wouldn’t default to pull from there. Now however ops doesn’t want the cell bins for some parts but wants the cell bins for other parts, and we also ship kits of parts and they like to change up where they pick those too. These things have provided some difficulty with management of both warehouses for parts for us.

Nancy

1 Like
11

Oh yes, amen to all of that. We are also working on a BPM now that arises from the same general problem.

Related to this, another challenge is cycle counts. You count by warehouse, not site. If you let the system pick parts to count, there’s no guarantee that it will tell you to count the same part in all warehouses on the same day - it’s basically nigh to impossible for that to happen.

1 Like
12

We have 120 Warehouses, which really need to be on ALL parts, as we move between them. Epicor “Used to” allow you to move things between warehouses with a drop-down list but since they added this limitation, it is really poorly implemented IMHO. There should be a system checkbox to allow ALL warehouses to be used at the Plant level if you wanted, as not all customers want this limitation. It affects transfers and adjustments, and since we have a Warehouse and IN/Out Bin on Resource Groups for Advanced Material Movement, it is a PITA for me. Even using the DMT to update QOH with Quantity Adjust fails because a Part does not have a Warehouse Added.
I am going to search and maybe add a Kinetic Idea for an Override box in Plant.
Just embarking on using the DMT to mass update 120 Warehouses onto 50,000 Part Numbers… ugh.
George Hicks