Skip to Content
0
Former Member
Dec 07, 2011 at 06:47 PM

SAP B1 Query

106 Views

Hi All,

On the query below i would like to display only one record per sales order and to have the total shipped weight.

I appreciate your help. Thanks.

SELECT T0.DocDueDate, T0.DocNum, T0.CardName, T1.whscode, T0.DocDate, T1.weight1

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' and

ORDER BY T0.DocDueDate, T0.DocNum