Skip to Content
0
Former Member
Dec 08, 2009 at 06:34 AM

customer sales report

26 Views

Hi experts,

am facing prbs in this follwng query while selecting doctype as 's' service query fails but for item it gives output

pls sugest any way to overcum this prob.

SELECT 
T0.[DocNum],
 T0.[DocType], 
T0.[CardCode],
 T0.[CardName], 
T1.[ItemCode],
 T1.[Dscription],
 T1.[Quantity]
 FROM 
[dbo].[OINV]  
T0 INNER JOIN [dbo].[INV1]  T1
 ON T0.DocEntry = T1.DocEntry 
INNER JOIN OITM T2
ON T1.ItemCode = T2.ItemCode 
INNER JOIN 
[dbo].[@ITMG]  T3 
ON T2.U_itmg = T3.Code
WHERE T0.[DocType] =[%0]

pls help me for this

ketan