How to get a relationship in a RDD to "filter" the results (inner join)?

Kinetic ERP
, ,
1

I am trying to get the GenSO RDD to filter the results to only show lines whose PartNum’s are assigned a KBCode in the PartWhse table. I have spent many hours working on this and can’t afford to waste any more time on it. I tried every conceivable option of relationships and criterias and nothing filters my results, only filters whether the PartWhse/KBCode data outputs or not-- but all OrderLine’s / Releases show in the data.

I could have sworn there was a way to inner join with the table relationships to filter the results but nothing is working on my end. Any help is appeciated.

This is for the GenSO Bartender Label Report Style / Report Data Definition.

2

For anyone that stumbles on this post in the future-- what I ended up doing to circumvent the Epicor RDD and Bartender Limitations was write some functions to export BAQ results as bartender formatted files which worked fantastic and allows me to create my own datasets via BAQ and send any results to bartender any time. I never did find a way to make the GenSO label RDD to work how we needed it to.

1 Like