Field from table added to PO Entry RDD not showing

Kinetic ERP
, , ,
1

My engineers have added internal cross reference part number into Kinetic for a number of parts and they would like them to show up on the PO form. I copied the RDD for the poform and added the PartXRefInt table to it. I removed the exclusions from the fields I needed and setup a relationship with the PODetail table. I then set up a new Report Style using the duplicated RDD and downloaded the style. I updated the query in Report Builder to pull in the table and the fields I wanted. The report saves in Report Builder and it runs just fine, but it isn’t pulling in the information into the field. I made sure that there was an internal Part Number setup for the one I chose, so I’m kinda stumped at this point. I’ve done this before without problems, but this is the first time in Kinetic, so I’m wondering if I’m missing something. Screenshots attached.

image
image1277Ă—367 37.8 KB

image
image502Ă—508 9.81 KB

image

1 Like
2

Is there a reason you’re using “First” in your SSRS field expression?

3

Also, is it coming up with “NUM” capitalized in the RDD?

Not capitalized in BAQ Designer:
image

4

Didn’t notice the First. I’ll remove that. And I think in the RDD it isn’t NUM but Num. Would that make a difference?

5

Fixed those. No change. Still don’t get anything in the field.

6

Just trying to go through my mental checklist… is the RDD relationship set to output?

7

No, it wasn’t and that was the issue. Thanks for the help!

1 Like