cancel
Showing results for 
Search instead for 
Did you mean: 

ayuda con consulta sobre comprobante diario de facturacion

Former Member
0 Kudos

Hola a todos

Tengo la siguiente consulta sobre comprobante diarios de facturacion porque la que me trae SAP no cumple con nuestros requerimientos, pero el inconveniente que tengo es con las notas credito porque las que se hacen manuales no estan ligadas a las facturas, para esto cree un campo de usuario en la tabla ORIN llamado U_Factura_Base donde se esta digitando el numero de la factura que corresponde a la devolucion, pero no se como integrar estas notas credito al informe porque la idea es que me muestre las devoluciones correspondientes a estas facturas con el rangode serie seleccionada para despues calcular el valor total

/* SELECT FROM .[OINV] P0 */

DECLARE @FD DATETIME

/* WHERE */

SET @FD = /* P0.DocDate */ '[%0]'

/* SELECT FROM .[OINV] P1 */

DECLARE @TD DATETIME

/* WHERE */

SET @TD = /* P1.DocDate */ '[%1]'

/* SELECT FROM .[NNM1] P2 */

DECLARE @SN VARCHAR(20)

/* WHERE */

SET @SN = /* P2.SeriesName */ '[%2]'

/* SELECT FROM .[NNM1] P3 */

DECLARE @T VARCHAR(50)

/* WHERE */

SET @T = /* P3.SeriesName */ '[%3]'

SELECT T0.[DocDate] as 'FECHA',T2.[SeriesName] AS 'SERIE',T0.[DocNum] AS 'N° DE FACTURA',T0.[CardCode] AS 'COD_CLIENTE',T0.[CardName] AS 'NOM_CLIENTE', T0.[BaseAmnt] AS 'BASE',(T0.[VatSum]/0.16) as 'BASES',T0.[VatSum] AS 'IVA',T0.[WTApplied] AS 'RETENCION',T0.[DocTotal] AS 'VALOR TOTAL',T3.[CashAcct] AS 'CUENTA',T3.[TrsfrAcct] AS 'MEDIO DE PAGO', (select sum(T0.[DocTotal]) from oinv T0 INNER JOIN OSLP T1 ON T0.SlpCode = T1.SlpCode INNER JOIN NNM1 T2 ON T0.Series = T2.Series INNER JOIN ORCT T3 ON T0.ReceiptNum = T3.DocEntry WHERE (T0.[DocDate] >=[%0] AND T0.[DocDate] <=[%1]) and (T2.[SeriesName] =[%2] or T2.[SeriesName] =[%3]) AND T3.[TrsfrAcct]='11050515') as 'TARJETA' ,

(select sum(T0.[DocTotal]) from oinv T0 INNER JOIN OSLP T1 ON T0.SlpCode = T1.SlpCode INNER JOIN NNM1 T2 ON T0.Series = T2.Series INNER JOIN ORCT T3 ON T0.ReceiptNum = T3.DocEntry WHERE (T0.[DocDate] >=[%0] AND T0.[DocDate] <=[%1]) and (T2.[SeriesName] =[%2] or T2.[SeriesName] =[%3]) AND T3.[TrsfrAcct] is null) as 'EFECTIVO' , T1.[SlpName] AS 'NOM EMPLEADO',@FD AS ' FECHA DE EMISION'

FROM OINV T0 INNER JOIN OSLP T1 ON T0.SlpCode = T1.SlpCode INNER JOIN NNM1 T2 ON T0.Series = T2.Series INNER JOIN ORCT T3 ON T0.ReceiptNum = T3.DocEntry WHERE (T0.[DocDate] >=[%0] AND T0.[DocDate] <=[%1]) and (T2.[SeriesName] =[%2] or T2.[SeriesName] =[%3]) ORDER BY T2.[SeriesName]

Agradezco enormemente cualquier ayuda que me puedan brindar

cordial saludo

jcarito

Accepted Solutions (0)

Answers (2)

Answers (2)

Former Member
0 Kudos

ya pude solucionar

Former Member
0 Kudos

Hola como lograste solucionar el caso de comprobante para Colombia?

Gracias,

Former Member
0 Kudos

Hola...

Puedes agregar la tabla ORIN al query, ejemplo:

OINV T0 INNER JOIN ORIN T1 ON T0.DocNum = T1.U_Factura _Base

Donde DocNum corresponde al número de la factura (desconozco si es el número de SAP u otro)

Saludos Cordiales,