RDD - Connecting tables Part to Country

Kinetic ERP
1

Hi,
I am building a RDD from scratch to create a certificat of origin report. I need to show the country of origin of the parts we ship. I tried connecting the part table to the country table via the field Part.ISOrigCountryNum but these are the only option I get in the RDD:

image
image668Ă—514 20.3 KB

There seems to have a table in the background named CountryList, which I tried to connect but still it did not work. Any pointers on how to fix it?

2

Make sure the “ExcludeColumn” is not checked on the fields for relationships and the ones wanted on the report. Some versions of Epicor need you to save, clear, then reload the RDD too then make the relationship.

image
image847Ă—340 22.1 KB

1 Like
3

Wow thanks for the quick reply and that solution works. Weird that I did not have to do this for all other tables. The relations existed automatically as soon as I did a refresh even with all fields excluded.

Fields are added.
image

1 Like
4

RDD Maintenance can be a fickle tool.

1 Like