Skip to Content
0
Apr 17, 2014 at 12:37 PM

Sales report with Batch number & expiry dates

56 Views

Hello friends,

would any one please help me to frame this query to achieve the above ..

my query is as bellow, but I want to add the batch number & expiry dates along with the other information.....

SELECT T0.[DocNum], T0.[DocDate], T0.[CardCode], T0.[CardName], T0.[NumAtCard], T1.[ItemCode], T1.[Dscription], T1.[Quantity] FROM OINV T0 INNER JOIN INV1 T1 ON T0.DocEntry = T1.DocEntry WHERE T1.[ItemCode] >=[%0] AND T1.[ItemCode] <=[%1] AND T0.[DocDate] >=[%2] AND T0.[DocDate] <=[%3]

So which table to join to get the batch & expiry...

Rgds

Suman