Linking tables in RDD

Epicor ERP 10
, ,
1

I am trying to update a copy of the PO Report to show some contact fields for the buyer. I have copied the base PO RDD, then linked in the PurAuth table to get the Contact ID for the Buyer ID from the POHeader table, then linked the PurAuth contact to the PerCon table. This is not returning any data from the PerCon table. The Report Builder does not give me an error since it sees the fields in the report, but when I run the report the fields are blank.

What am I doing wrong? I believe the link from POHeader to PurAuth to PerCon is the only way to access the data I am looking for.

The other thing that is interesting is that the RDD has created a BuyerID_PerConID field that I can show and it does show the proper PerConID number.I have also tried printing the fields from both the POHeader (where they now show up) and from the PerCon dataset but nothing is working.

2

Make sure the relationship type on the RDD is set to “Output”:

image

1 Like
3

Which relationship do I put that on? I put it on the PerCon and nothing happens. I did do a SyncDataset on the Report Style too but nothing.

4

If you are using the POForm RDD, you should be using the Linked Tables fields.

image

image

Most related data can be found in these links.

Did you change the RDD that is referenced on the Report Style? Also, you should never sync dataset.

1 Like
5

I have linked the BuyerID in the PO Header into the PurAgent

image
image984Ă—683 34.8 KB

Then I have the PurAgent linked to the PerCon
image
image984Ă—683 34.6 KB

The fields I want are not in the Buyer table so I can’t use the Pick Links as you show since the PerCon table is not available.

6

What information are you trying to get? We could probably provide a better answer if we know what fields you are after.

7

I am trying to get the phone numbers and email address as stored in the person/contact table. Our buyers have separate fax numbers so we need to pull their office phone and fax from there. I realize the email address is on the buyer record but having it come from the contact record means one less place to maintain email addresses.

8

Do not use a Key, always leave it blank. Change the Relation Type to Output for both links.

Did you update the dataset query to include the new fields?

1 Like
9

Yes, I already updated the dataset query. Changing the relationships worked! Thanks for the tip about not using the keys.