Skip to Content
Author's profile photo Roger Jovel

Informe Series Facturadas

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

Assigned Tags

      1 Comment
      You must be Logged on to comment or reply to a post.
      Author's profile photo Former Member
      Former Member

      Me ayudo mucho pero también necesito las series en proceso como lo haría