PENDIENTES POR ENTREGAR EN FACTRAS DE RESERVA

[former_member671177]

Cordial Saludo

de que manera puedo generar un informe por vendedor donde me muestre que productos con sus respectivas cantidades que realizo dicho vendedor en una factura de reserva esta pendiente de entregar o ya se entrego?

de antemano gracias

[former_member326598]

YO HICE UNO PARA PROVEEDORES QUE PARTE DESDE LA ORDEN DE COMPRA

PARA TU CASO SERIA DESDE LA ORDEN DE VENTA - ENTREGA - FACTURA DE RESERVA

LO QUE HACE ESTE QUERY ES CER SU TU ORDEN DE VENTA HA SIDO ENTREGADA TOTAL O PRCIALMENTE LUEGO LA FACTURA DE RESERV SI HA SIDO CANCELADA Y CUANDO

ESPERO TE SEA DE AYUDA SOLO ES CUESTION DE CAMBIAR LAS TABLAS Y CAMPOS

SELECT 
T0.[DocNum] AS 'SAP', 
T0.[DocDate] AS 'FECHA SAP', 
T0.[U_QA_NROQA] AS 'QA-ORDER', 

T0.[CardName] AS 'PROVEEDOR', 
T1.[Dscription] AS 'ARTICULO',
T1.[Quantity] AS 'CANT.', 
T1.[unitMsr] AS 'U.M.', 
T0.U_QA_PACKING AS 'PACKING',
T2.[PymntGroup] AS 'PAYMENT TERMS',  
T0.[U_QA_INCOTERM] AS 'TERM.', 
T0.[DocCur] AS 'MONE.', 
T1.[PriceBefDi] AS 'VALOR', 
(T1.[Quantity] * T1.[PriceBefDi]) AS 'VALOR ORDER',
CASE T1.[U_QA_TT] 
	WHEN 'A' THEN 'AEREO'
	WHEN 'M' THEN 'MARITIMO'
	WHEN 'T' THEN 'TERRESTRE'END AS 'TIP.EMBARQUE', 
T1.[U_QA_ETD] AS 'ETS', 
T1.[U_QA_ETA] AS 'ETA', 
T0.U_QA_SHIP AS 'PUERTO',
T1.[U_QA_GENV] AS 'BL',
T3.DOCDATE AS 'ING. ALM.',
T4.[Quantity] as 'CANT.ING',
T5.DOCDATE AS 'FECHA FACT.',
CONVERT(varchar,t5.FolioPref) + '-' + CONVERT(varchar,t5.FolioNum) AS 'FACTURA',
CASE T5.CURSOURCE
	WHEN 'L' THEN (T5.DOCTOTAL)
	WHEN 'S' THEN (T5.DOCTOTAL)
	WHEN 'C' THEN (T5.DOCTOTALFC) END AS 'VALOR FACT.',
T5.DOCDUEDATE AS 'VENC. PAGO',
T5.[ReceiptNum] AS 'N° PAGO'
FROM 
OPOR T0  
INNER JOIN POR1 T1 ON T0.DocEntry = T1.DocEntry 
INNER JOIN OCTG T2 ON T0.GroupNum = T2.GroupNum,
OPDN T3  INNER JOIN PDN1 T4 ON T3.DocEntry = T4.DocEntry,
OPCH T5  INNER JOIN PCH1 T6 ON T5.DocEntry = T6.DocEntry
WHERE 
T1.[ItemCode] LIKE 'A%' and
T0.[Indicator] IS NULL 
AND T5.[isIns] = 'Y'
AND T1.TRGETENTRY = T4.DOCENTRY
AND T4.TRGETENTRY = T6.DOCENTRY
AND t1.linenum=t4.baseline
AND t4.linenum=t6.baseline

[Former Member]

Hola

Prueba con esta y adáptala a lo que necesitas:

SELECT T0.[DocNum], T0.[CardCode], T0.[SlpCode],  T2.[SlpName],  T0.[CardName],  T1.[ItemCode], T1.[Dscription], T1.[Quantity], T1.[OpenQty] FROM OINV T0  INNER JOIN INV1 T1 ON T0.DocEntry = T1.DocEntry INNER JOIN OSLP T2 ON T0.SlpCode = T2.SlpCode WHERE T0.[isIns] = 'Y' AND (T0.[DocDate] > = '[%0]' AND  T0.[DocDate] < = '[%1]') AND T2.[SlpName] =[%2]

Un saludo,

Tere

Edited by: Teresa Pestana on Dec 26, 2011 12:09 AM