Skip to Content

FMS Auto populate

Hi Friends

I have created UDF fields in SAles order screen.

Sales order quantity have to Auto populate in that UDF field through FMS

How to acheive that.

Thanks

vinoth

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

5 Answers

  • Jul 12, 2017 at 11:24 AM

    Hi

    Try this set auto refresh based on quantity

    SELECT $[$38.11.0]

    Regards:

    Balaji.S

    Add comment
    10|10000 characters needed characters exceeded

  • Jul 12, 2017 at 03:35 PM

    You either put your FMS on a matrix column or you will need to save the record first than use a query in your FMS.

    Add comment
    10|10000 characters needed characters exceeded

    • Hi

      I have created UDF fields in sales order

      my quantity fields in sales order have to come automatically in the UDF.

      In my UDF i have set that particular FMS but its not triggering

  • Jul 13, 2017 at 06:14 AM

    Hi Vinoth,

    What value do you want to populate the quantity column with?

    Regards,

    Johan

    Add comment
    10|10000 characters needed characters exceeded

  • Jul 14, 2017 at 01:02 PM

    Hi,

    UDF created in sales order row level or header level?

    Do you want to display stock in that UDF?

    Regards,

    Nagarajan

    Add comment
    10|10000 characters needed characters exceeded

    • Hi

      UDF Created in header level.

      Few of the item groups i don't want to calculate the qty field

      eg:

      t6.ItmsGrpCod NOT IN (100,108,109,110,116,131,132,133,134,136,137,139,140,141)

      Is it clear if not please tell me

  • Jul 18, 2017 at 06:17 AM

    Hi Vinoth,

    Please use this query in your FMS:

    SELECT ISNULL(SUM(r.Quantity), 0)
    FROM RDR1 r
         INNER JOIN ORDR h ON r.DocEntry = h.DocEntry
         INNER JOIN OITM i ON r.ItemCode = r.ItemCode
    WHERE h.DocNum = $[ORDR.DocNum]
      AND ISNULL(i.InvntItem, 'N') = 'Y'

    I recommend using Auto Refresh When Field Changes, with Document Total, and Refresh regularly

    Regards,
    Johan

    Add comment
    10|10000 characters needed characters exceeded