Need to create a formatted search for a UDF to copy info from Delivery to Sales Orders

[Former Member]

Hi Experts,

I'm a novice when it comes to queries, and hope someone here can help me with the syntax. I'm trying to create a FMS for a UDF that I have created in both Sales and Delivery. I need the value inputted from the UDF in the Delivery to populate into the UDF in the sales order. Can anyone provide me with the correct syntax?

Here are my needs:

Need U_TrackRT1 from ODLN to populate into ORDR U_TrackRT1. The NumatCard field can be used to tie the 2 documents together in terms of reference.

Does this make sense? Is there a way of doing this?

Thanks,

Chris

[former_member185296 · Accepted solution]

Hi,

Use this FMS query

SELECT T0.U_TrackRT1 FROM ODLN T0 where t0.numatcard = $[$14.0]

Regards,

Vinoth

[Former Member · Accepted solution]

Hi Vinoth,

Thanks for the quick response! Tried that query, but when I run the FMS, I get "Internal Error 3006"  message 131-183

Thanks,

Chris

**EDIT: I have resolved the error by placing a negative sign in  - changed  $[$14.0] to $[$-14.0]  and it worked! Thank you!!