Skip to Content
avatar image
Former Member

FMS Query for Quantity column into freight field

Dear Experts,

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

Regards

Amol

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Apr 20 at 02:29 PM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • Apr 20 at 11:46 AM

    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

    Add comment
    10|10000 characters needed characters exceeded