# PartTran.BinNum2 BAQ restriction in 10.2.600

**URL:** <https://www.epiusers.help/t/parttran-binnum2-baq-restriction-in-10-2-600/71013>\
**Category:** Epicor ERP 10\
**Tags:** baq, e10, 102600\
**Created:** [September 16, 2020, 8:58pm UTC](https://www.epiusers.help/t/parttran-binnum2-baq-restriction-in-10-2-600/71013 "2020-09-16T20:58:24Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![danvoss](https://www.epiusers.help/user_avatar/www.epiusers.help/danvoss/32/86637_2.png) [@danvoss](https://www.epiusers.help/u/danvoss)\
**Post date:** [September 16, 2020, 8:58pm UTC](https://www.epiusers.help/t/parttran-binnum2-baq-restriction-in-10-2-600/71013/1 "2020-09-16T20:58:24Z")

</div>

A word of caution if you use PartTran.BinNum2 as a BAQ criteria. In 10.2.600 a restriction has been placed on the field that prevents its use as a BAQ criteria unless you have AMM licensed. I don’t know whether the restriction is a bug or is intentional, but I have an open ticket with Epicor seeking to have this restriction removed. This security restriction has brought our planned upgrade from 10.2.300 to 10.2.600 to a screeching halt.

---

<div class="post-metadata">

**Author:** ![Chris\_Conn](https://www.epiusers.help/user_avatar/www.epiusers.help/chris_conn/32/93797_2.png) [@Chris\_Conn](https://www.epiusers.help/u/Chris_Conn)\
**Post date:** [September 16, 2020, 10:25pm UTC](https://www.epiusers.help/t/parttran-binnum2-baq-restriction-in-10-2-600/71013/2 "2020-09-16T22:25:40Z")

</div>

That’s pretty petty to make an integral field for part transactions limited to an additional purchase license in my humble opinion.

---

<div class="post-metadata">

**Author:** ![danvoss](https://www.epiusers.help/user_avatar/www.epiusers.help/danvoss/32/86637_2.png) [@danvoss](https://www.epiusers.help/u/danvoss)\
**Post date:** [October 30, 2020, 3:14pm UTC](https://www.epiusers.help/t/parttran-binnum2-baq-restriction-in-10-2-600/71013/3 "2020-10-30T15:14:27Z")

</div>

Epicor has advised that this will be corrected in 10.2.600.16.

---

<div class="post-metadata">

**Author:** ![ckrusen](https://www.epiusers.help/user_avatar/www.epiusers.help/ckrusen/32/50584_2.png) [@ckrusen](https://www.epiusers.help/u/ckrusen)\
**Post date:** [October 30, 2020, 3:43pm UTC](https://www.epiusers.help/t/parttran-binnum2-baq-restriction-in-10-2-600/71013/4 "2020-10-30T15:43:50Z")

</div>

FWIW - in 10.2.300 (without AMM) that field is “secretly restricted”. Same for `Warehouse2`

The Results of a BAQ:

![image](https://www.epiusers.help/uploads/default/original/3X/b/d/bd6ef42048092dee11bd6f50f1e34f039a96b162.png)

A query in SSMS shows:

 ![image](https://www.epiusers.help/uploads/default/original/3X/5/7/575c473e78d181fc6f2996b2c2982566aa01153b.png)

---

<div class="post-metadata">

**Author:** ![ckrusen](https://www.epiusers.help/user_avatar/www.epiusers.help/ckrusen/32/50584_2.png) [@ckrusen](https://www.epiusers.help/u/ckrusen)\
**Post date:** [October 30, 2020, 3:52pm UTC](https://www.epiusers.help/t/parttran-binnum2-baq-restriction-in-10-2-600/71013/5 "2020-10-30T15:52:54Z")

</div>

A Trace of the BAQ being tested shows two interesting entries:

```xml
<QueryFieldAttribute>
          <Company>MC</Company>
          <QueryID>E10-PartTran-Bin2</QueryID>
          <SubQueryID>a9d90e9b-b3e9-45ae-8a56-513b5179e77c</SubQueryID>
          <TableID>PartTran</TableID>
          <FieldName>WareHouse2</FieldName>
          <AttributeName>Caption</AttributeName>
          <Value>Whse2</Value>
          <SystemFlag>false</SystemFlag>
          <SysRevID>0</SysRevID>
          <SysRowID>43556d1e-ef3d-4d08-a03f-9732fb91e77c</SysRowID>
          <IsOverriden>true</IsOverriden>
          <BitFlag>0</BitFlag>
          <RowMod>A</RowMod>
        </QueryFieldAttribute>
        <QueryFieldAttribute>
          <Company>MC</Company>
          <QueryID>E10-PartTran-Bin2</QueryID>
          <SubQueryID>a9d90e9b-b3e9-45ae-8a56-513b5179e77c</SubQueryID>
          <TableID>PartTran</TableID>
          <FieldName>BinNum2</FieldName>
          <AttributeName>Caption</AttributeName>
          <Value>Bin2</Value>
          <SystemFlag>false</SystemFlag>
          <SysRevID>0</SysRevID>
          <SysRowID>b1ddde39-af54-4721-9aa4-a756f692e77c</SysRowID>
          <IsOverriden>true</IsOverriden>
          <BitFlag>0</BitFlag>
          <RowMod>A</RowMod>
        </QueryFieldAttribute>

```

Specifically, the `<IsOverriden>true</IsOverriden>` entries.

Also, the `<QueryFieldAttribute>` nodes only exist for `Warehouse2` and `Bin2`.