PartTran.BinNum2 BAQ restriction in 10.2.600

Epicor ERP 10
, ,
1

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.

2

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

3

Epicor has advised that this will be corrected in 10.2.600.16.

4

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

The Results of a BAQ:

image

A query in SSMS shows:

image
image787×288 8.6 KB

5

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

<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.