RDD UD Field - SSRS

Epicor ERP 10
1

Hello Epicorist,

I added a UD field ( ICCountryName_c ) in orderel table, the field holds country description if its intercompany sales order.

In my material queue report, i want to show this country description. Therefore, i added orderhed, orderdtl, orderrel table to the data definition.

when i generate the report, system not showing the UD field (ICCountryName_c) value , when the value does exist in orderrel table.

How can I make it work?

(Note: Data model is regenerated, client cache cleared, 100% sure that i am querying the right table from the reports db …)

2

Make sure that the SysRowID column is not excluded from the OrderRel table. We need that to hook up to the UD table and retrieve the column value. I believe this is fixed in 10.2 to auto-magically include the SysRowID column.

2 Likes
3

Ahh,… foreign key. thanks for the reply Jeff. dont know how i missed it.