Skip to Content
avatar image
Former Member

FMS Query to display the current service contract

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]

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • avatar image
    Former Member
    Mar 08, 2017 at 03:11 PM

    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?

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Mar 15, 2017 at 06:43 AM

    Hello experts, please help me in the above scenario.

    Add comment
    10|10000 characters needed characters exceeded