# Multiple Records From PartQty Table Per Part

**URL:** <https://www.epiusers.help/t/multiple-records-from-partqty-table-per-part/60553>\
**Category:** Epicor ERP 10\
**Tags:** e10\
**Created:** [October 7, 2019, 3:17pm UTC](https://www.epiusers.help/t/multiple-records-from-partqty-table-per-part/60553 "2019-10-07T15:17:30Z")\
**Posts on this page:** 7\
**Page:** 1

<div class="post-metadata">

**Author:** ![kp11](https://www.epiusers.help/letter_avatar_proxy/v4/letter/k/50afbb/32.png) [@kp11](https://www.epiusers.help/u/kp11)\
**Post date:** [October 7, 2019, 3:17pm UTC](https://www.epiusers.help/t/multiple-records-from-partqty-table-per-part/60553/1 "2019-10-07T15:17:30Z")

</div>

I am curious to why I am getting multiple records per part for some components in the PartQty table. Looks like it has multiple UOMs but I am unsure of where this could be coming from. The part record displays the UOM of each, for Inventory,Purch, and Sales UOMs. It is also displaying different values for Demand and OnHand quantities which is weird. I checked and there are not multiple part records for these parts. Any ideas?! ![part](https://epiusers.help/uploads/default/original/3X/9/3/9383aabcb41de99f4a8b64009e87e7cafdee8bc7.jpeg) ![MultRecord](https://epiusers.help/uploads/default/original/3X/a/0/a00dae79d96822dffbaecf994770bd6fd82e8e24.jpeg)

---

<div class="post-metadata">

**Author:** ![JasonMcD](https://www.epiusers.help/user_avatar/www.epiusers.help/jasonmcd/32/22326_2.png) [@JasonMcD](https://www.epiusers.help/u/JasonMcD)\
**Post date:** [October 7, 2019, 3:27pm UTC](https://www.epiusers.help/t/multiple-records-from-partqty-table-per-part/60553/2 "2019-10-07T15:27:03Z")

</div>

I’m guessing the parts are in multiple warehouses.

---

<div class="post-metadata">

**Author:** ![kp11](https://www.epiusers.help/letter_avatar_proxy/v4/letter/k/50afbb/32.png) [@kp11](https://www.epiusers.help/u/kp11)\
**Post date:** [October 7, 2019, 3:28pm UTC](https://www.epiusers.help/t/multiple-records-from-partqty-table-per-part/60553/3 "2019-10-07T15:28:28Z")

</div>

One warehouse. I checked that as well.  
 ![OneWarehouse](https://epiusers.help/uploads/default/original/3X/a/2/a2fcaec463326d76cdcc22c33391c6def4f5b7f0.jpeg)

---

<div class="post-metadata">

**Author:** ![Hogardy](https://www.epiusers.help/user_avatar/www.epiusers.help/hogardy/32/18785_2.png) [@Hogardy](https://www.epiusers.help/u/Hogardy)\
**Post date:** [October 7, 2019, 3:48pm UTC](https://www.epiusers.help/t/multiple-records-from-partqty-table-per-part/60553/4 "2019-10-07T15:48:37Z")

</div>

Could it be that the UOM of that part was pk100, and then was changed to Each?  
Is there any field with a qty for that pk100 row? if not maybe there is a data fix available from support to remove it…

Pierre

---

<div class="post-metadata">

**Author:** ![markdamen](https://www.epiusers.help/user_avatar/www.epiusers.help/markdamen/32/54917_2.png) [@markdamen](https://www.epiusers.help/u/markdamen)\
**Post date:** [October 7, 2019, 5:09pm UTC](https://www.epiusers.help/t/multiple-records-from-partqty-table-per-part/60553/5 "2019-10-07T17:09:05Z")

</div>

The unique index is this:

![image](https://epiusers.help/uploads/default/original/3X/e/a/ea1976aa3d029563be59aa7dd2177451838b85fc.png)

So you’ve either got multiple Warehouses (not the case, as you’ve ruled that out) or you’ve got demand against multiple UOMs

Couple of places to check:

OrderDtl table:

```auto
select distinct(SalesUM)
from erp.orderdtl
where PartNum = 'your_part_here'

```

JobMtl table:

```auto
select distinct(IUM)
from erp.JobMtl
where PartNum = 'your_part_here'

```

Transfer Order table:

```auto
select distinct(OurStockQtyUOM)
from erp.TFOrdDtl
where PartNum = 'your_part_here'

```

---

<div class="post-metadata">

**Author:** ![gpayne](https://www.epiusers.help/user_avatar/www.epiusers.help/gpayne/32/55751_2.png) [@gpayne](https://www.epiusers.help/u/gpayne)\
**Post date:** [October 7, 2019, 5:21pm UTC](https://www.epiusers.help/t/multiple-records-from-partqty-table-per-part/60553/6 "2019-10-07T17:21:35Z")

</div>

Check if the part has Track Multiple UOMs set

---

<div class="post-metadata">

**Author:** ![JasonMcD](https://www.epiusers.help/user_avatar/www.epiusers.help/jasonmcd/32/22326_2.png) [@JasonMcD](https://www.epiusers.help/u/JasonMcD)\
**Post date:** [October 7, 2019, 6:18pm UTC](https://www.epiusers.help/t/multiple-records-from-partqty-table-per-part/60553/7 "2019-10-07T18:18:53Z")

</div>

Oh, duh, you have warehouse in the query pic. Is there a :walk away in shame: emoji?