Skip to Content
author's profile photo Former Member
Former Member

Need FMS query on Issue for Production Form!

Dear All,

I need an FMS query which fetch the Batch No.(UDF) from Production order to Issue for Production form.

Thanks in advance.

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

2 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Feb 08, 2012 at 08:16 AM

    Hi Param Deshwal,

    As per my understanding you have add Batch No UDF at Title level in production Order, & fetch this value in Issue for production screen at title level UDF.

    let me know

    Thanks,

    Srujal Patel

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hi Param,

      YOu may create a row level udf on issue for production and use the fms mentioned below to capture the details;

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

      Thanks,

      Joseph

  • author's profile photo Former Member
    Former Member
    Posted on Feb 08, 2012 at 11:16 AM

    Hi Param Deshwal,

    For meet your requirement first pick Production Order Title level UDF value in Issue for Production screen in raw level through FMS

    SELECT T0.[U_TTT]  FROM [dbo].[OWOR]  T0 WHERE T0.[DocNum] = $[IGE1.BaseRef]

    After pick up the value you need run SP_Notification to pick this value in Title level UDF of Issue for Production.

    Deleted

    Thanks,

    Srujal Patel

    Edited by: GordonDu on Feb 9, 2012 9:23 AM

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.