Query para impresion de Factura

Hola, esta vez venimos para enseñarte de que manera puedes utilizar un query para la creacion de una impresion de Factura. El query es muy sencillo el cual abarcaremos como numero de lotes, serie, vendedor, descuentos.

Aqui invocamos al query de Factura




declare @Numdoc int
set @Numdoc = '67223' -- este campo lo comentas cuando creas el Stored procedure y dejas el @numdoc como variable


SELECT OINV.DocEntry, OINV.FolioNum, OINV.FolioPref, OINV.DocNum, OINV.DocDate, OINV.DocDueDate,
OINV.Address, OINV.Address2, OINV.NumAtCard, OINV.VatSum, OINV.VatSumFC, OINV.DocCur, OINV.DocTotal,
OINV.DocTotalFC, OINV.Comments, OINV.Series, INV1.VatPrcnt, INV1.GTotal, INV1.TaxCode, INV1.DiscPrcnt,
OINV.Header, OINV.LicTradNum, INV1.LineTotal, INV1.TotalFrgn, INV1.FreeTxt, round(INV1.PriceBefDi,3) 'PriceBefDi',
round(INV1.Price,3) 'Price', INV1.OpenQty, INV1.Price as 'U_EXD_LPRECIO', INV1.unitMsr,
INV1.ItemCode, INV1.SWW, INV1.Dscription, OCRD.CardCode, OCRD.CardName, OCRD.CardFName, OCRD.ZipCode, OCRD.City, OSLP.SlpName, OBTN.DistNumber, OBTN.MnfSerial,
OBTN.ExpDate, NNM1.SeriesName, NNM1.NextFolio,NNM1.FolioPref, OCRD.MailStrNo, OCTG.PymntGroup, ITL1.Quantity, OSHP.TrnspName,DLN1.BaseRef,
OINV.Printed FROM OINV WITH (NOLOCK) INNER JOIN
INV1 WITH (NOLOCK) ON OINV.DocEntry = INV1.DocEntry INNER JOIN
OCRD WITH (NOLOCK) ON OINV.CardCode = OCRD.CardCode INNER JOIN
NNM1 WITH (NOLOCK) ON OINV.Series = NNM1.Series INNER JOIN
OSLP WITH (NOLOCK) ON OINV.SlpCode = OSLP.SlpCode INNER JOIN
OCTG WITH (NOLOCK) ON OINV.GroupNum = OCTG.GroupNum INNER JOIN
OITL WITH (NOLOCK) ON INV1.BaseRef = OITL.DocNum AND INV1.BaseLine = OITL.DocLine AND INV1.BaseType = OITL.DocType AND INV1.ItemCode = OITL.ItemCode AND OINV.CardCode = OITL.CardCode INNER JOIN
ITL1 WITH (NOLOCK) ON OITL.LogEntry = ITL1.LogEntry AND ITL1.Quantity < '0' INNER JOIN
OBTN WITH (NOLOCK) ON ITL1.MdAbsEntry = OBTN.AbsEntry INNER JOIN
OSHP WITH (NOLOCK) ON INV1.TrnsCode = OSHP.TrnspCode FULL OUTER JOIN
DLN1 WITH (NOLOCK) ON OINV.DocEntry = DLN1.TrgetEntry AND INV1.LineNum = DLN1.LineNum
WHERE OINV.DocEntry = @Numdoc ORDER BY INV1.Dscription

Este query lo guardas como SP y despues lo llamas en un crystal report, el cual permitira abrir la Factura creada.

Factura Creada Lista para imprimir