Enterprise Resource Planning Blogs by Members
Gain new perspectives and knowledge about enterprise resource planning in blog posts from community members. Share your own comments and ERP insights today!
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Informe Series Facturadas

rjovel
Active Participant
‎2013 Jun 14 4:33 PM
0 Kudos
320

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

1 Comment
juandfranco
Explorer
‎2014 Feb 25 10:39 PM
0 Kudos

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

Labels in this area
Popular Blog Posts