/scripts/ahub.form.attachments.js
0

Query report for ggod issue

May 06, 2017 at 10:09 AM

30

avatar image

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.

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

0 Answers

Skip to Content