# Retrieve lot parts

**URL:** <https://www.epiusers.help/t/retrieve-lot-parts/75781>\
**Category:** Epicor ERP 10\
**Tags:** parts\
**Created:** [February 19, 2021, 3:03pm UTC](https://www.epiusers.help/t/retrieve-lot-parts/75781 "2021-02-19T15:03:15Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![josue.rmz](https://www.epiusers.help/letter_avatar_proxy/v4/letter/j/838e76/32.png) [@josue.rmz](https://www.epiusers.help/u/josue.rmz)\
**Post date:** [February 19, 2021, 3:03pm UTC](https://www.epiusers.help/t/retrieve-lot-parts/75781/1 "2021-02-19T15:03:15Z")

</div>

Is there a wat to search for lot parts, is there a table where this parts are stored?

---

<div class="post-metadata">

**Author:** ![utaylor](https://www.epiusers.help/user_avatar/www.epiusers.help/utaylor/32/64664_2.png) [@utaylor](https://www.epiusers.help/u/utaylor)\
**Post date:** [February 19, 2021, 3:15pm UTC](https://www.epiusers.help/t/retrieve-lot-parts/75781/2 "2021-02-19T15:15:46Z")

</div>

Part.TrackLots is the field in part maintenance that you can check to make a part lot tracked.

There are a few other places you set up how you would like to collect this though, but that is the main field you check to get started.

In short, if you query the part table where Part.TrackLots = 1 or true then you should get a list of parts that are lot tracked.

---

<div class="post-metadata">

**Author:** ![Jason\_Woods](https://www.epiusers.help/user_avatar/www.epiusers.help/jason_woods/32/80101_2.png) [@Jason\_Woods](https://www.epiusers.help/u/Jason_Woods)\
**Post date:** [February 19, 2021, 4:47pm UTC](https://www.epiusers.help/t/retrieve-lot-parts/75781/3 "2021-02-19T16:47:26Z")

</div>

@utaylor is correct. Also, the actual lots that have been made are store in PartLot and the lots on hand are stored in PartBin.

---

<div class="post-metadata">

**Author:** ![josue.rmz](https://www.epiusers.help/letter_avatar_proxy/v4/letter/j/838e76/32.png) [@josue.rmz](https://www.epiusers.help/u/josue.rmz)\
**Post date:** [February 19, 2021, 5:29pm UTC](https://www.epiusers.help/t/retrieve-lot-parts/75781/4 "2021-02-19T17:29:40Z")

</div>

Is there a way to convert one part to part lot from the parts table?

---

<div class="post-metadata">

**Author:** ![Jason\_Woods](https://www.epiusers.help/user_avatar/www.epiusers.help/jason_woods/32/80101_2.png) [@Jason\_Woods](https://www.epiusers.help/u/Jason_Woods)\
**Post date:** [February 19, 2021, 6:24pm UTC](https://www.epiusers.help/t/retrieve-lot-parts/75781/5 "2021-02-19T18:24:14Z")

</div>

Not sure what you mean here. If you want to start tracking lots for a part, you need to Qty Adjust out any on hand inventory, flip the “Track Lots” checkbox on Part Entry, and the, Qty Adjust them back in with a Lot Number.