on 07-10-2010 4:54 PM
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
DECLARE @FD DATETIME
/* WHERE */
SET @FD = /* P0.DocDate */ '[%0]'
DECLARE @TD DATETIME
/* WHERE */
SET @TD = /* P1.DocDate */ '[%1]'
DECLARE @SN VARCHAR(20)
/* WHERE */
SET @SN = /* P2.SeriesName */ '[%2]'
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
ya pude solucionar
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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,
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
91 | |
8 | |
7 | |
4 | |
4 | |
3 | |
3 | |
3 | |
3 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.