FMS Blank Agreement to Sales Order UDF to UDF

[Former Member]

Dear Experts

I am trying to get some information from Blank Agreement to the following Sales Order. The information is saved as UDF on table OOAT and should be take over to an UDF on ORDR. Is there any connection to solve my issue.

If I am going to take two or more blank agreement as source it would be okay to take the first line which will be found.

Hope it's understandable

Thanks ahead

[agustin_marcoscividanes]

Hi

the blank agreement and the sales order are related by the table RDR1.agrno field.

Kind regards

Agustín

[Former Member · Accepted solution]

Hello,

You can make one UDF on sales order for Blanket Agreement and make a FMS on your current UDF based on that.

SELECT t0.UDFName
FROM dbo.OOAT T0
WHERE t0.AbsID = $[ORDR.BlanketAgreement UDF]

Thanks,

Engr. Taseeb Saeed