# Warehouse got assigned wrong

**URL:** <https://www.epiusers.help/t/warehouse-got-assigned-wrong/39320>\
**Category:** Epicor ERP 9\
**Created:** [July 17, 2017, 5:56pm UTC](https://www.epiusers.help/t/warehouse-got-assigned-wrong/39320 "2017-07-17T17:56:46Z")\
**Posts on this page:** 10\
**Page:** 1

<div class="post-metadata">

**Author:** ![Kimberley](https://www.epiusers.help/user_avatar/www.epiusers.help/kimberley/32/50847_2.png) [@Kimberley](https://www.epiusers.help/u/Kimberley)\
**Post date:** [July 17, 2017, 5:56pm UTC](https://www.epiusers.help/t/warehouse-got-assigned-wrong/39320/1 "2017-07-17T17:56:47Z")

</div>

Ok, here is strange one and I am not even sure how it could have happened. We have multiple plants under one company. I have a warehouse from plant B got assigned to a part under plant A. Not even functionally possible. The warehouse only exists in plant B and is not a shared warehouse. I can’t remove it because of transactions…not sure if it is really a transaction issue in plant A or if it is seeing the transactions from Plant B. It is causing some inventory confusion.

Thanks Kim

---

<div class="post-metadata">

**Author:** ![Rick\_Bird](https://www.epiusers.help/user_avatar/www.epiusers.help/rick_bird/32/77664_2.png) [@Rick\_Bird](https://www.epiusers.help/u/Rick_Bird)\
**Post date:** [July 17, 2017, 9:02pm UTC](https://www.epiusers.help/t/warehouse-got-assigned-wrong/39320/2 "2017-07-17T21:02:53Z")

</div>

Kimberley,  
You will need to review the PartTran data for the part to make sure the Plant and warehouse are properly aligned.  
The only times I can thing of that this type of association can be made is:

1. Shared warehouses are enabled in Plant Config.
2. Some weird jacked up DMT load

-Rick  
www.getaligned.solutions

---

<div class="post-metadata">

**Author:** ![Kimberley](https://www.epiusers.help/user_avatar/www.epiusers.help/kimberley/32/50847_2.png) [@Kimberley](https://www.epiusers.help/u/Kimberley)\
**Post date:** [July 18, 2017, 3:15pm UTC](https://www.epiusers.help/t/warehouse-got-assigned-wrong/39320/3 "2017-07-18T15:15:55Z")

</div>

my worry was an error on a DMT load but i didn’t think i updated anything recently that would have affected this. I know that the Shared ware house is not enabled.

thanks Kim

---

<div class="post-metadata">

**Author:** ![Kimberley](https://www.epiusers.help/user_avatar/www.epiusers.help/kimberley/32/50847_2.png) [@Kimberley](https://www.epiusers.help/u/Kimberley)\
**Post date:** [July 18, 2017, 3:28pm UTC](https://www.epiusers.help/t/warehouse-got-assigned-wrong/39320/4 "2017-07-18T15:28:38Z")

</div>

I looked in Part Tran and the warehouse in question doesn’t show under that part and plant. Any ideas how to remove it?

---

<div class="post-metadata">

**Author:** ![MiguelS](https://www.epiusers.help/user_avatar/www.epiusers.help/miguels/32/99_2.png) [@MiguelS](https://www.epiusers.help/u/MiguelS)\
**Post date:** [July 18, 2017, 5:27pm UTC](https://www.epiusers.help/t/warehouse-got-assigned-wrong/39320/5 "2017-07-18T17:27:55Z")

</div>

I have seen this when a Job material has the wrong warehse. Then I see the PartWhse table showing demand. Once I fix the job, I run FixAllPlantWhse.r and sometimes it fixes the Part Tracker

---

<div class="post-metadata">

**Author:** ![Kimberley](https://www.epiusers.help/user_avatar/www.epiusers.help/kimberley/32/50847_2.png) [@Kimberley](https://www.epiusers.help/u/Kimberley)\
**Post date:** [July 18, 2017, 7:57pm UTC](https://www.epiusers.help/t/warehouse-got-assigned-wrong/39320/6 "2017-07-18T19:57:46Z")

</div>

I looked at the JobMtl Table and I see the part but none to the wrong warehouse. Problem is this part could be in multiple plants and warehouses. I must be missing something on Job Mtl table. can you point me in the correct directions.

---

<div class="post-metadata">

**Author:** ![MiguelS](https://www.epiusers.help/user_avatar/www.epiusers.help/miguels/32/99_2.png) [@MiguelS](https://www.epiusers.help/u/MiguelS)\
**Post date:** [July 18, 2017, 8:34pm UTC](https://www.epiusers.help/t/warehouse-got-assigned-wrong/39320/7 "2017-07-18T20:34:32Z")

</div>

Do a query in JobMtl for the PN and display the Mtl Warehouse. You can also do a query on the PO Rel…

---

<div class="post-metadata">

**Author:** ![Kimberley](https://www.epiusers.help/user_avatar/www.epiusers.help/kimberley/32/50847_2.png) [@Kimberley](https://www.epiusers.help/u/Kimberley)\
**Post date:** [July 19, 2017, 1:46pm UTC](https://www.epiusers.help/t/warehouse-got-assigned-wrong/39320/8 "2017-07-19T13:46:09Z")

</div>

Ok so I was correct on my JobMtl pull I did but i don’t see any issues. The correct plants on the jobs match the correct warehouse code. I haven’t checked the PO Rel yet.

![](https://epiusers.help/uploads/default/original/2X/0/0a4c0ebea3c1536866c08192b734e9f7c22641c5.png)

this is the warehouse that is wrong in Epicor.

 ![](https://epiusers.help/uploads/default/original/2X/6/612e92e009a7c44be2309ba984b1bb8334958056.jpg)

---

<div class="post-metadata">

**Author:** ![MiguelS](https://www.epiusers.help/user_avatar/www.epiusers.help/miguels/32/99_2.png) [@MiguelS](https://www.epiusers.help/u/MiguelS)\
**Post date:** [July 19, 2017, 3:51pm UTC](https://www.epiusers.help/t/warehouse-got-assigned-wrong/39320/9 "2017-07-19T15:51:26Z")

</div>

I usually find the problem before any transaction, so I am able to change it on the job. Since there is a transaction already, I am not sure if you can remove the warehouse from the plant record.

---

<div class="post-metadata">

**Author:** ![Kimberley](https://www.epiusers.help/user_avatar/www.epiusers.help/kimberley/32/50847_2.png) [@Kimberley](https://www.epiusers.help/u/Kimberley)\
**Post date:** [July 21, 2017, 5:47pm UTC](https://www.epiusers.help/t/warehouse-got-assigned-wrong/39320/10 "2017-07-21T17:47:25Z")

</div>

That is what I was afraid of
