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
Showing results for 
Search instead for 
Did you mean: 
Former Member
0 Kudos

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.

Labels in this area