FMS Query for Quantity column into freight field

[amol_bairagi]

Dear Experts,

I need a query from Sales Order Quantity value copy to freight column UDF at document level.

Regards

Amol

[kothandaraman_nagarajan]

Hi,

Try this query,

Select sum(t0.quantity) from Rdr1 t0 inner join ordr t1 on t0.docentry = t1.DocEntry where t1.docentry = $[ORDR.DocNum]

Note, the UDF filed will be updated after adding the document.

Regards,

Nagarajan

[anand_singh]

Dear Amol,

Try below as FMS:-

Select sum(t0.quantity) from Rdr1 t0 
inner join ordr t1 on t0.docentry = t1.DocEntry
where t1.docnum = $[Ordr.Docnum]  and t1.FinncPriod = $[Ordr.FinncPriod]

Regards,

Anand Singh