Need to get he serials of the Delivery done

[Former Member]

Hi experts,

I need to get the Serial numbers of the products delivered through product delivery. can any one tell me how to get the details using the OSRI, SRI1 and ODLN tables. Or better if u can get me the SQL statement.

thanks

Asela

[Former Member · Accepted solution]

Hi Asela.....

Try this......

SELECT Distinct T1.IntrSerial
FROM SRI1 T0
Inner Join OSRI T1 On T0.SysSerial=T1.SysSerial AND T1.ItemCode=T0.ItemCode
INNER JOIN DLN1 T2 ON T2.DocEntry=T0.BaseEntry AND T2.ItemCode=T0.ItemCode
inner join ODLN T3 on T2.DocEntry = T3.DocEntry 
WHERE T0.BaseType = 15

Regards,

Rahul

[kvbalakumar]

Hi,

Try this

SELECT T0.DocDate, T0.CardCode,T0.CardName,T0.DocNum,T1.ItemCode,T1.Dscription,T3.IntrSerial
from ODLN T0 inner join DLN1 T1 on T0.DocEntry = T1.DocEntry
left outer join SRI1 T2 on T2.BaseEntry=T1.DocEntry and T2.BaseType= T0.ObjType and T2.BaseLinNum = T1.LineNum
left outer join OSRI T3 on T2.SysSerial = T3.SysSerial

Regards,

Bala