Adding a table twice to RDD for two different purposes

Epicor ERP 10
,
1

I’m working with a copy of the JobTrav RDD. What I need to do is add some fields from the part for both the raw material parts being consumed and also add some fields for the finished good part being produced.

Specifically, I want to add to the PartHeight and UPCCode1 of the ram materials and I want to add the CommercialBrand of the part being produced to the report.

I can do either of these by adding the part table. But, after I add the part table for the raw material, it will not allow me to add the part table again for the finished good. Does anyone have a way to accomplish this?

2

You can get those fields for the material in the Linked Table.

image

1 Like
3

I think you’ll have to do what jkane suggested twice.

The first is with Pick Field Link of PartNum (this is the part made by the job), and pick field for the CommercialBrand

The second would be on Field Link to MtlPartNum, for picking UPCCode1

4

For the Commercial Brand, you want to use the Linked Tables for JobHead.

For the other 2 fields, you want to use the Linked Tables for JobMtl.

Once you have them exposed in your RDD you will need to add them to your rdl file. To add Linked Table fields, you use the convention of the main table first, then “_” and the field.

So, your Commercial Brand would probably be T1.JobHead_CommercialBrand.

5

To answer your original question, you cant add a table twice to RDD for two different purposes.

You usually use the methods as described above and in worst case scenario you change that tables JOIN to be generic, to get lot more data into .rdl and then filter in the .rdl side

Based on your request the above answers, seem the right direction.

6

Thanks everyone. Super helpful.