# BAQ showing inactive Bins

**URL:** <https://www.epiusers.help/t/baq-showing-inactive-bins/99167>\
**Category:** Kinetic ERP\
**Tags:** baq\
**Created:** [February 6, 2023, 1:44pm UTC](https://www.epiusers.help/t/baq-showing-inactive-bins/99167 "2023-02-06T13:44:47Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![BenVarner](https://www.epiusers.help/letter_avatar_proxy/v4/letter/b/e68b1a/32.png) [@BenVarner](https://www.epiusers.help/u/BenVarner)\
**Post date:** [February 6, 2023, 1:44pm UTC](https://www.epiusers.help/t/baq-showing-inactive-bins/99167/1 "2023-02-06T13:44:47Z")

</div>

Im fairly new at working with BAQ’s. We keep on running into an issue where a parts primary bin is set to a bin that is inactive. I can pull all the information just fine except I cannot figure out how to show on the baq if the bin is inactive or not. I would love to make a BAQ that is a list of all the inactive bins that I can compare it to a parts list of the parts and primary bin numbers. Any help would be appreciated!

---

<div class="post-metadata">

**Author:** ![Banderson](https://www.epiusers.help/user_avatar/www.epiusers.help/banderson/32/50875_2.png) [@Banderson](https://www.epiusers.help/u/Banderson)\
**Post date:** [February 6, 2023, 2:36pm UTC](https://www.epiusers.help/t/baq-showing-inactive-bins/99167/2 "2023-02-06T14:36:37Z")

</div>

So I was going to go on a “Teachable moment” walk… but when I looked at that field, the field help has the DB field blank. Annoying, but it happens.

However, there is a field on that table that shows whether the bin is inactive or not.

 ![image](https://www.epiusers.help/uploads/default/original/3X/6/6/6696389865749c01d7b147c3f2e98c705b8c25dd.png)

![image](https://www.epiusers.help/uploads/default/original/3X/4/9/49ef331f3d6701fa142401e7a6e352392c9a8d26.png)

 ![image](https://www.epiusers.help/uploads/default/original/3X/9/9/99266986925ab726cc9466b6cb9cd45c58de0485.png)

---

<div class="post-metadata">

**Author:** ![DaveOlender](https://www.epiusers.help/user_avatar/www.epiusers.help/daveolender/32/260_2.png) [@DaveOlender](https://www.epiusers.help/u/DaveOlender)\
**Post date:** [February 6, 2023, 5:29pm UTC](https://www.epiusers.help/t/baq-showing-inactive-bins/99167/3 "2023-02-06T17:29:32Z")

</div>

I believe the PrimaryBin is in the table PlantWhse.PrimBin - then you can join WhseBin to look for Inactive.

DaveO

---

<div class="post-metadata">

**Author:** ![BenVarner](https://www.epiusers.help/letter_avatar_proxy/v4/letter/b/e68b1a/32.png) [@BenVarner](https://www.epiusers.help/u/BenVarner)\
**Post date:** [February 6, 2023, 6:27pm UTC](https://www.epiusers.help/t/baq-showing-inactive-bins/99167/4 "2023-02-06T18:27:29Z")

</div>

Thanks that helped immensely! Glad to know I wasnt going crazy when the DB field was blank. Not a fan of some of the inconsistancies in Epicor

---

<div class="post-metadata">

**Author:** ![BenVarner](https://www.epiusers.help/letter_avatar_proxy/v4/letter/b/e68b1a/32.png) [@BenVarner](https://www.epiusers.help/u/BenVarner)\
**Post date:** [February 6, 2023, 6:27pm UTC](https://www.epiusers.help/t/baq-showing-inactive-bins/99167/5 "2023-02-06T18:27:51Z")

</div>

This helped me puzzle it out thanks so much!