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]

Hello Mohd,

it is working now. I have entered this QUERY SELECT T0."CardFName" FROM OCRD T0 WHERE T0."CardCode" = $[$4.0.0]

If you try to run the query with this code you get an error message but it is not an issue as the FMS is working.

Best regards,

Jean-Julien

[MD1]

jjguyomar

CAN YOU SHARE THE UDF SCREEN WITH SYSTEM INFORMATION

[former_member724893]

It is working actually... even with the error message, the query works with the FMS. Thank you !

[former_member724893]

Could be linked to the fact that I have SAP B1 cloud version ?

[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?