Display Employee Name linked in Item Master in Order Recommendation Report

[Former Member]

Dear Experts,

My requirement is that the "Employee Name" linked in Item master have to be displayed next to the item in MRP Order Recommendation Report.

I have created a header level UDF "Employee Name" in Item master and have selected an employee in this field. I have also created another UDF in Order Recommendation Report as "Internal Buyer" as a column. But the employee linked to the Item is not getting displayed in the Order Recommendation Report.

FMS query used in "Internal Buyer" is

SELECT T0.U_Employee FROM OITM T0 where T0.ItemCode=$[oitm.Itemcode]

Regards,

G.Shankar Ganesh

[Former Member · Accepted solution]

Hi Shankar

The problem is not with your query, but the event that triggers it. What did you set the refresh on?

Kind regards

Peter Juby

[Former Member · Accepted solution]

Dear Peter,

I set Refresh on for ItemCode.

With Regards,

G.shankar Ganesh

[vijay_kumar1]

Hi Shankar,

Could you try with this query

SELECT T1.[U_Employee ] FROM [dbo].[OITM] T1 WHERE T1.[ItemCode] =$ ORCM.ItemCode

Regards,

Vijay kumar