Cordial Saludo:
Comparto informe de Ordenes de pedido detalladas por proveedor y Asesor Comercial
SELECT (T0.[DocDate]) as Fecha, (T0.[CardCode]) as 'Codigo SN', (T0.[CardName]) as Proveedor, (T2.[SeriesName]) as Sucursal, (T0.[DocNum]) as Documento, (T1.[ItemCode]) as 'Codigo del Articulo', (T1.[Dscription]) as 'Nombre Articulo', T1.[Quantity], T1.[Price], T1.[LineTotal], (T3.[SlpName]) as Responsable FROM OPCH T0 INNER JOIN PCH1 T1 ON T0.DocEntry = T1.DocEntry INNER JOIN NNM1 T2 ON T0.Series = T2.Series INNER JOIN OSLP T3 ON T0.SlpCode = T3.SlpCode WHERE T0.[DocDate] Between [%0] and [%1] ORDER BY T0.[DocDate], T0.[DocNum]
A espera de sus comentarios y sugerencias.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
3 | |
2 | |
2 | |
2 | |
2 | |
2 | |
1 | |
1 | |
1 | |
1 |