MtlTags RDD Table Relations Problem

Epicor ERP 10
,
1

We just upgraded from 10.2.500 to 10.2.600.11 over the weekend and have run into an issue with the MtlTags. Currently, when this report gets run (custom report to print labels) it just hangs in Active Tasks. If I restart the Task Agent, the tasks get cancelled. I am re-making the RDD and currently have it working, but it takes forever to generate. I wanted to add the Part table to the report, so here is my relation:

image
image691Ă—609 56 KB

When I look at the report database though, I find that it is actually pulling all of our parts:

image
image1310Ă—698 230 KB

Am I just missing something here?

2

Why have you set the Relation Type to “Definition Only”? Shouldn’t it be “Output”?

3

I actually tried both. It didn’t make a difference at all.

4

How many records in the MtlTags table?

5

1 Row

6

That seems very odd. However, if you need a field from the Part Table that isn’t a UD field, have you tried using the Linked Table instead? It is faster for the system anyway.

7

I thought about that, but there are no links for the MtlTags table

image
image1207Ă—680 85.1 KB

8

Is PartRev getting the right number of records? If so, try linking to PartRev instead. Again, if you aren’t using UD fields, you can use the Linked Tables.

1 Like
9

Since you are joining from the MtlTags table, what is the output of that row?

10

You were right, PartRev only had one row. I think I got all the links working now from that. I appreciate the direction. I was getting so frustrated that the Part table wasn’t working correctly and kinda tunnel visioned. Still confused on why that was pulling everything though. Thanks!

1 Like
11

Good news. Glad it worked.