Skip to Content
avatar image
Former Member

FMS Help Needed

Dear Expert,

Can anybody help me to get FMS query. Actually my requirement is like I want value from production order header to Receipt from production header level. We have one UDF in production order as U_Batch_No where we write Batch No and we want to fetch that value into receipt from production UDF.

I tried with 1 FMS query but it works at Row level only.

SELECT T0.[U_UDF FROM PRODUCTION WITH BATCH DETAILS] FROM OWOR T0 WHERE T0.[DocNum] = $[IGE1.BaseRef]

Please correct me and help.

Regards,

Harshal Makwana

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

4 Answers

  • Best Answer
    Jan 14, 2015 at 12:43 AM

    Hi,

    Why your UDF so descrptive?

    SELECT T0.[U_UDF FROM PRODUCTION WITH BATCH DETAILS] FROM OWOR T0 WHERE T0.[DocNum] = $[$13.61.number]

    Thanks & Regards,

    Nagarajan

    Add comment
    10|10000 characters needed characters exceeded

  • Jan 13, 2015 at 08:01 PM

    Hi,

         Try this

    SELECT T0.[U_UDF FROM PRODUCTION WITH BATCH DETAILS] FROM OWOR T0 WHERE T0.[DocNum] = $[IGN1.BaseRef]



    Regards,

    Manish

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hi Manish,

      That works at row level only and at Header level it shows internal error.

      Regards,

      Harshal

  • avatar image
    Former Member
    Jan 14, 2015 at 01:48 AM

    Hi Harshal,

    Production order in the receipt from production is in the row level. Do you always have only one production order to receipt?

    Thanks,

    Gordon

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jan 17, 2015 at 04:48 AM

    Dear All,

    Thanks for all your valuable response.

    Regards,

    Harshal

    Add comment
    10|10000 characters needed characters exceeded