Skip to Content

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

To report this post you need to login first.

1 Comment

You must be Logged on to comment or reply to a post.

Leave a Reply