Skip to Content
avatar image
Former Member

FMS Blank Agreement to Sales Order UDF to UDF

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    avatar image
    Former Member
    Feb 09, 2017 at 11:19 AM

    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

    Add comment
    10|10000 characters needed characters exceeded