FMS for Line Quantity

[Former Member]

Hi,

I am trying to fetch the total document quantity by adding the Quantity field - RDR1.Quantity on a UDF - ORDR.U_TotalQuantity.

My FMS looks like this :-

SELECT SUM($[$38.Quantity])

I am not able to get the results, i you can guide either by FMS or by SDK i am ok with both.

Regards

[Former Member]

Hi,

You are right these queries are not working. Another way is to use SP to update it but i want to avoid it.

Is there any way we can update the field when the form is still active and show data in it?

Regards

[Former Member]

You need SDK for it.

[Former Member]

Anything new on this topis, I also need a query for the Total Qty for a Sales Doc

[Former Member]

Hi,

This FMS will not work.

Unless you could run it after you adding the order, you may try:

SELECT SUM(T0.Quantity) FROM RDR1 T0

WHERE T0.DocEntry= $[RDR1.DocEntry.number\]

Thanks,

Gordon

[Former Member]

Hi,

Try this one

SELECT SUM(T0.Quantity)  FROM RDR1 T0 WHERE T0.DocEntry = $[ORDR.DocEntry]

THanks.

CLint