Skip to Content

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.

To report this post you need to login first.

Be the first to leave a comment

You must be Logged on to comment or reply to a post.

Leave a Reply