Skip to Content
0

FMS Query to display the current service contract

Mar 08, 2017 at 02:45 PM

40

avatar image

Hi Experts,

Please help me in creating a FMS to make a link between service contract and sale order.

SELECT T3.[ContractID] FROM ORDR T0 INNER JOIN ODRF T1 ON T0.[draftKey] = T1.[DocEntry] INNER JOIN ORCP T2 ON T1.[DocEntry] = T2.[DraftEntry] INNER JOIN CTR2 T3 ON T2.[AbsEntry] = T3.[RcpEntry] WHERE T2.[DraftEntry] = $[ORCP.[DraftEntry]

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

2 Answers

J Srinivas Mar 08, 2017 at 03:11 PM
0

I want to update remarks field of sale order at the time of creating recurring template from service contract.

How can i create fms for this?


demo.jpg (201.7 kB)
Share
10 |10000 characters needed characters left characters exceeded
J Srinivas Mar 15, 2017 at 06:43 AM
0

Hello experts, please help me in the above scenario.

Share
10 |10000 characters needed characters left characters exceeded