Hi All,
I have a query which i have used in a udf at row level. Its a test query applied in PO.
Declare @TaxAmt Decimal(16,3) Set @TaxAmt = ( SELECT Sum(T0.[TaxSum]) FROM POR4 T0 Where Docentry = (Select Docentry = OPOR.Docentry from OPOR INNER JOIN POR1 ON OPOR.DocEntry = POR1.DocEntry Where DocNum = $[OPOR.DocNum] and Series = $[OPOR.Series] and POR1.[ItemCode]= $[POR1.ItemCode]) and statype = 8) Select @TaxAmt
This query gives error. Please let me know.
Thanks,
Joseph