Bartender Autolabel STK-MTL not printing Project ID

Epicor ERP 10
1

I am trying to edit my autoprint PartTran STK-MTL label to include the Project ID. I get the Project ID by adding the JobHead table to the existing ones in the group: Company, Part, and PartTran.

If I write a simple SQL query and join PartTran to JobHead I can pick up the ProjectID for each PartTran, if there is any.

However, if I add JobHead to the Report Data Definition I just get blanks. In the .BT file I do see the headers from the JobHead fields I added. I have the following (default) Relationship Fields between PartTran and JobHead: Company & JobNum. The type is Definition Only.

What am I overlooking here?

Thanks!

Paul

2

See what happens when you change your relation from definition only to output.