Hi Expert !
I want to know about ,how to get current month goods issue data.
SELECT t0."DocNum" AS "DocNum", T0."DocDate" AS "Date", T1."ItemCode" AS "ItemCode",
T1."Dscription" AS "ItemDesc", t3."ItmsGrpNam", T1."Quantity" AS "Received Qty", T0."Comments"
FROM OIGE T0
INNER JOIN IGE1 T1 ON T1."DocEntry" = T0."DocEntry"
INNER JOIN OITM T2 ON T1."ItemCode" = T2."ItemCode"
INNER JOIN OITB t3 ON t2."ItmsGrpCod" = t3."ItmsGrpCod"
WHERE (MONTH(t0."DocDate") = '12' AND MONTH(NOW()) = '1' AND YEAR(t0."DocDate") = (YEAR(NOW()) -1)
Thanks
Danish