Skip to Content
Author's profile photo Former Member

Informe de Devoluciones por Sucursal y Asesor Comercial

Cordial Saludo:

Comparto con ustedes este informe de devoluciones de mercancía.

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.

Assigned Tags

      Be the first to leave a comment
      You must be Logged on to comment or reply to a post.