Skip to Content
0
Former Member
Sep 21, 2008 at 11:21 AM

Query for batch item and item type text

279 Views

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