I have tried the following program for run the above requirement. this is only showing part passed through both tranasation.
I wand all trans, if trans not done it show zero value.
Please help me
SELECT T0.[ItemCode], T0.[ItemName], T0.[ItmsGrpCod],T1.[ItmsGrpNam], sum(T2.Quantity) 'GRN', Sum(t3.Quantity) 'Ship' FROM OITM T0
INNER JOIN OITB T1 ON T0.ItmsGrpCod = T1.ItmsGrpCod
INNER JOIN POR1 T2 ON T0.Itemcode = T2.Itemcode
INNER JOIN DLN1 T3 ON T0.ItemCode = T3.Itemcode GROUP BY T0.[ItemCode], T0.[ItemName], T0.[ItmsGrpCod],T1.[ItmsGrpNam] ORDER BY T0.[ItemCode]
Thanks
Anantha Desai