Skip to Content
avatar image
Former Member

Sum Qty in each row in SO using FMS

Hi all!

i would like to sum qty in each row in SO with query below but it seem not correct. Pls help !!!

select SUM(ISNULL(B.invqty,0)) from ORDR a JOIN RDR1 b ON a.DocEntry=b.DocEntry where a.DocEntry=$[ORDR.DocNum]

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

4 Answers

  • avatar image
    Former Member
    Dec 30, 2014 at 01:47 AM

    Dear All!

         Even my case cannot be solved by FMS but really appreciate your help. Thanks 😊

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Dec 29, 2014 at 10:46 AM

    Hi,

    i suggest you to add the total through post Transaction notification.


    Regards,

    Tausif


    Add comment
    10|10000 characters needed characters exceeded

    • Hi Dara Ros,

      For this problem required Add on because in matrix Sum function not work Properly.

      if you want sum the quantity. than first add the document than update the form with this FMS.


      SELECT SUM(T1.[Quantity]) FROM ORDR T0  INNER JOIN RDR1 T1 ON T0.[DocEntry] = T1.[DocEntry] WHERE T1.[DocEntry] =[%0]


      Regards,

      Bhanu

  • Dec 29, 2014 at 02:05 PM

    Hi,

    Try:

    select SUM(ISNULL(B.invqty,0)) from ORDR a JOIN RDR1 b ON a.DocEntry=b.DocEntry where a.DocEntry=$[ORDR.Docentry]


    Thanks & Regards,

    Nagarajan

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Dec 30, 2014 at 01:37 AM

    Hi,

    This is not a proper place to use FMS. Only if you have created SO and saved, you may manually run it. That is not the user friendly solution.

    Thanks,

    Gordon

    Add comment
    10|10000 characters needed characters exceeded