Sum Qty in each row in SO using FMS

[Former Member]

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]

[Former Member]

Dear All!

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

[kothandaraman_nagarajan]

Please close this thread by marking correct/helpful answers.

[Former Member]

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

[kothandaraman_nagarajan]

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

[Former Member]

Hi,

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

Regards,

Tausif

[Former Member]

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