avatar image
Former Member

Query report for ggod issue

Hiii Experts,

I am created query

SELECT T0."DocNum", T0."U_Dept", T0."DocDate", T1."ItemCode", T1."Dscription", T1."Quantity", T1."Price" ,( (T1."Price" + (T1."Price" * 0.2))* T1."Quantity") as Value FROM OIGE T0 INNER JOIN IGE1 T1 ON T0."DocEntry" = T1."DocEntry" WHERE T0."DocDate" =[%0] and T0."U_Dept" BETWEEN [%1] and [%2]

In this query i want group by U_Dept and also U_dept wise sum of quantity and price

How we can do that?

Thanks in Advance.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

0 Answers

Skip to Content