Skip to Content
0

FMS Blank Agreement to Sales Order UDF to UDF

Feb 08, 2017 at 04:01 PM

54

avatar image

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

10 |10000 characters needed characters left characters exceeded

Hi

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

Kind regards

Agustín

1
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Best Answer
Taseeb Saeed Feb 09, 2017 at 11:19 AM
0

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

Share
10 |10000 characters needed characters left characters exceeded