Skip to Content
0
Former Member
Dec 07, 2011 at 09:11 PM

SAP B1 Query Question

45 Views

Hi,

I was wondering if is possible to add an order count/total weight per day for the query below.

Thanks,

Steve

SELECT T0.DocDueDate, T0.DocNum, T0.CardName, T1.whscode, T0.DocDate, SUM(T1.weight1) 'Weight'

FROM ORDR T0 INNER JOIN RDR1 T1 ON T0.DocEntry = T1.DocEntry

WHERE T0.DocDueDate>=[%0] and T0.DocDueDate<=[%1] and T1.whscode LIKE '%[%2]%' and T0.DocStatus = 'C'

GROUP BY T0.DocDueDate, T0.DocNum, T0.CardName, T1.whscode, T0.DocDate,

ORDER BY T0.DocDueDate, T0.DocNum