Skip to Content
0

FMS Query for Quantity column into freight field

6 days ago

31

avatar image

Dear Experts,

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

Regards

Amol

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

2 Answers

Nagarajan K 2 days ago
0

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

Share
10 |10000 characters needed characters left characters exceeded
Anand Singh 3 days ago
0

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

Share
10 |10000 characters needed characters left characters exceeded