Issue on FMS and UDF

[former_member724893]

Hello,

I have SAP B1 Cloud (10.0). I have created a UDF "Customer Foreign Name" in Sales documents. I want to display it in the quotation and invoice. To do so I have created a FMS to bring back the field CardFName from OCRD table.
However, my FMS is in error. Could you help me please ?

Here is the query : SELECT T0."CardFName" FROM OCRD T0 WHERE T0."CardCode" = $[$4.0.0]

And the error message on the query : 1). [SAP AG][LIBODBCHDB DLL][HDBODBC] Syntax error or access violation;257 sql syntax error: incorrect syntax near "$": line 1 col 58 'Job de planification de backend' (OBSJ) (at pos 58)

Thank you

[former_member566317]

I hope one of this will work

SELECT T0."CardFName" FROM OCRD T0 WHERE T0."CardCode" = $[ORDR."CardCode"]

SELECT T0."CardFName" FROM OCRD T0 WHERE T0."CardCode" = $[OCRD."CardCode"]

[former_member724893]

Thank you Manish. I still have the same error message : 1). [SAP AG][LIBODBCHDB DLL][HDBODBC] Syntax error or access violation;257 sql syntax error: incorrect syntax near "$": line 1 col 58 'Valeurs définies par l'utilisateur' (CSHS) (at pos 58)

[Cindal]

I have the same error. how did you fix it

[Cindal]

I have the same error. how did you fix it?