Skip to Content
0
Former Member
Jan 11, 2014 at 04:20 PM

All transction report by part /Name / - Purchase / Sale /Produce / Issue

26 Views

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