Skip to Content
0
Sep 24, 2014 at 06:16 AM

Need One Column in Query report

19 Views

Dear All,

i have one error in below query ie i want to add production order planning qty in my query .Kindly suggest me how to add planning qty and how to linkup standard tables to UDT in below query.

Select distinct T0.[U_POSTDT] ,T1.[U_ITEMCODE],T1.[U_ITEMNAME], sum(T1.[U_QTY]) FROM [dbo].[@VSP_INVMAN] T0 INNER JOIN [dbo].[@VSP_INVMAN1] T1 ON T0.DocEntry = T1.DocEntry WHERE t0.[u_frwh] like 'gwh' and T0.[U_INVTRNS] IS NOT NULL AND T0.[U_POSTDT]>=[%0] and T0.[U_POSTDT]<=[%1] and T1.[U_SERIAL] is not null and T1.[U_QTY] <> 0 group by T0.[U_POSTDT] ,T1.[U_ITEMCODE],T1.[U_ITEMNAME]

thanks