espero les sirva
select T0.DOCDATE,
T2.DocNum, T2.CardCode,T2.CardName,
t0.itemcode,
t0.dscription,
t4.SuppSerial,
t4.IntrSerial
from INV1 t0 with(nolock) inner join OITM t1 with(nolock)
on t0.ItemCode=t1.ItemCode
INNER JOIN OINV T2 WITH(NOLOCK)
ON T0.DocEntry=T2.DocEntry
inner JOIN SRI1 T3 ON T0.DocEntry=T3.BaseEntry and t0.ItemCode=t3.ItemCode
inner join OSRI t4 on t3.SysSerial=t4.SysSerial and t3.ItemCode=t4.ItemCode
where t1.ManSerNum='Y' AND ISNULL(t0.TrgetEntry,1)=1
order by T0.DOCDATE
