Skip to Content
Former Member
Nov 20, 2012 at 09:11 AM

Goods Issue Vs Goods Receipt


Hi All,

I have the following Querry, i want to see how much of items were received and how much of items were issued. the items and quantities keep repeating.

SELECT T0.[ItemCode], T0.[Dscription], T0.[Quantity], T1.[ItemCode], T2.[ItemName], T1.[IssuedQty], T2.[BWeight1] FROM IGN1 T0 , WOR1 T1 INNER JOIN OITM T2 ON T1.ItemCode = T2.ItemCode WHERE T0.[ItemCode] Like 'fs%%' and T1.[ItemCode] Like '%%db%%' and T0.[DocDate] >= '[%0]' and T0.[DocDate] <= '[%1]'

Any help would be appreciated.