Hi All,
I have searched query relates to batch item and find this following one i.e.:
SELECT DISTINCT T2.[BaseRef][No. SO], T4.[SlpName][Sales], T2.[Dscription][Description], CASE WHEN t3.batchnum is null THEN t2.quantity ELSE 0 END [Non Batch Qty], t2.unitmsr[ ], T3.[Quantity][Batch Quantity], t2.unitmsr[ ], T3.[BatchNum][Batch Code] FROM ODLN T0 INNER JOIN DLN1 T2 ON T0.DocEntry = T2.DocEntry LEFT OUTER JOIN IBT1 T3 ON T0.DocNum = T3.BaseNum AND T3.ItemCode = T2.ItemCode inner JOIN OCRD T1 ON T0.CardCode = T1.CardCode inner JOIN OSLP T4 ON T2.SlpCode = T4.SlpCode WHERE T0.[DocNum] ='[%0]'
I have used it to customize a PLD report but when I generate a delivery order report that have item type text, for example bonus in the delivery row document, the report did not have it. pls give advice if the query will not include the text and how to add the text that available in the DLN10 table in the query ?
Rajh