User Defined Values not auto refreshing

[jimbo1234]

We have a UDF on Sales Order - called "Customer Remarks". This field needs to auto-populate with the contents of the "Notes" field relating to the business partner that is added to the order. I have attached an image of the Values setup and the code in the query.

If users hit Shift+f2, the field fills correctly, but does not automatically when Customer/Vendor Code changes. I have tried 'Customer/Vendor name' field as well.Can anyone suggest how i can get this to work automatically?

SELECT T0.[Notes] FROM OCRD T0 WHERE T0.[CardCode]  = $[$4.0.0]

[kothandaraman_nagarajan]

Hi,

Tested and working in 9.3 as well.

Try,

1. Reassign the FMS to UDF again

2. SELECT T0.[Notes]FROM OCRD T0 WHERE T0.[CardCode]=$[ORDR.CardCode]

Regards,

Nagarajan

[Johan_H]

Hi Jim,

You need to set Refresh Regularly, for the value to refresh regularly.

Regards,

Johan

[jimbo1234]

Hi Johan

I tried that, but still the same result - works manually but not automatically?

[Johan_H]

Hi Jim,

It works on my system (8.8), so you can take a look at SAP note 2335958 about troubleshooting fmss, and next log a support ticket with SAP support.

Regards,

Johan