RDD, Table Criteria

Epicor ERP 9
1

We’re on 9.05.605 – I’m trying to create a modified report data definition to use for EDI, to filter out child lines on sales kits.

I’ve duplicated the Epicor default EDIPckSl Report Data Definition, but when I try to add a Table Criteria to the ShipDtl table, to filter out those lines with parent products, I get this error:

Criteria can not be added to System Defined Report Tables.

image
image780×570 30.2 KB

In addition, I’ve added a table, and was able to add criteria on it … just not on the tables that originally came with this RDD.

Is there a way to add this type of filter/criteria to ShipDtl? Or is there a better place to add it?

Thanks for any help.

2

Can you just delete ShipDtl and then add it back (so it seems like you added it and its not system generated).

3

I found an alternative that avoids deleting and recreating the system-defined table.

Haso’s approach works, but deleting the table means rebuilding its configuration manually such as its parent relationship, linked fields, included fields and any other table-level setup that was present in the original RDD.

Two ways to change it:

  1. Create an Updatable BAQ against RptTable and update IsSystemTable from true to false for the relevant RDD and table.

  2. Export the RDD, modify the XML, then import it again. Search for the RptTable section and confirm you have the correct RptTableID, then look for the IsSystemTable field and change the value from true to false.

After the change, Epicor allows a criteria to be added to the table.