"VER1.0","Albaranes","Listado de Facturas"
;Versio, Categoria, Descripcion

;Ampla, Llarg, [EspaiCos]
;MargenX,MargenY, EtiLin, EtiPag
[DOCUM]
0, 0, 0
0,0,0,0

; Tipo, NomGrup, InicNumPag,   Select, From, GropBy
[GRUP]
1,"CABECERA", #FALSE#
"SELECT * , CodigoPostal & ' - ' & Poblacion as Direc, 'Tel : ' & Telefono1 as Tel "
"FROM Configuracion"
""
[CAPSALERA]
0, 0, #FALSE#, 0, #FALSE#, #TRUE#, 0
; RAp(n), Alt(n), SMin(b), Salto(D), GA(b), All(b), Rel(D)
[CAMPS] 4
3,"CABECERA","NombreComercial",10,0,"ARIAL",22,0,0,"1000",""
3,"CABECERA","Nif",10,8,"ARIAL",8,0,0,"1000",""
0,"Condiciones : ",20,30,"ARIAL",8,0,0,"1000"
6,"Condiciones",45,30,"ARIAL",8,0,0,"1000",""
[FICAP]

[FIGRUP]

;-----------------------------------------

; Tipo, NomGrup, InicNumPag,   Select, From, GropBy
[GRUP]
0, "GENERAL", #FALSE#
""
""
""
;[ordenaciones] y [condiciones]
[CAPSALERA]
10, 35, #TRUE#, 0, #TRUE#, #TRUE#, 0
; RAp(n), Alt(n), SMin(b), Salto(D), GA(b), All(b), Rel(D)
[CAMPS] 13
0,"Pgina :",170,0,"ARIAL",8,0,0,"1000"
6,"Pagina",200,0,"ARIAL",8,0,1,"1000",""
0,"Fecha :",170,5,"ARIAL",8,0,0,"1000"
6,"Fecha",200,5,"ARIAL",8,0,1,"1000",""
0, "Resumen Iva Ventas", 95, 7, "ARIAL", 20, 0, 2, "1000"
1,"lineaH1",5,26,200,26,,,
0,"%IVA",40,28,"ARIAL",10,0,1,"1000"
0,"%RE",55,28,"ARIAL",10,0,1,"1000"
0,"Base Imp.",90,28,"ARIAL",10,0,1,"1000"
0,"IVA",120,28,"ARIAL",10,0,1,"1000"
0,"RE",150,28,"ARIAL",10,0,1,"1000"
0,"Total",180,28,"ARIAL",10,0,1,"1000"
1,"lineaH2",5,32,200,32,,,
;0,"%RE",155,18,"ARIAL",8,0,1,"1000"
[FICAP]

[PEU]
0, 5, #TRUE#, 0, #FALSE#, #FALSE#, 0
; RAp(n), Alt(n), SMin(b), Salto(D), GA(b), All(b), Rel(D)
[CAMPS] 6
1,"lineaH3",5,0,200,0,,,
0,"Totales:",5,2,"ARIAL",10,0,0,"1000"
5,0,"TBI", 90,2,"ARIAL",10,0,1,"1000","Total"
5,0,"TIVA", 120,2,"ARIAL",10,0,1,"1000","Total"
5,0,"TRE", 150,2,"ARIAL",10,0,1,"1000","Total"
5,0,"T",180,2,"ARIAL",12,0,1,"1000","Total"
[FIPEU]

[FIGRUP]

;-----------------------------------------

;tipo, NomGrup, Select, From, GropBy
;"SELECT *"
;" FROM ResumenIva "
[GRUP]
3,"COS", #FALSE#
"SELECT  Ivap, Rep, Sum(Iva) AS Total_Iva, Sum(Re) AS Total_Re, Sum(BaseImponible) AS Total_BaseImponible, Sum(BaseImponible + iif(Iva is null,0,Iva)+iif(re is null,0,re)) AS Total_General"
; 3/11 (auditoria de listados): la consulta guardada _DiarioIvasVentas no la crea ningun .dbq y el listado
; salia vacio. Va aqui como subconsulta: una fila por tipo de IVA (1, 2 y 3), el Total solo en la primera.
; Lleva CodCliente (el filtro por cliente no tenia columna) y NumSerieFactura (para que el motor pueda
; dejar fuera los tickets canjeados, r641).
"FROM (SELECT FechaFactura, Seccion, NumFactura, NombreFiscal, CodCliente, NIF, FechaAsiento, Asiento, NOrden, NumSerieFactura, BaseImponible1 AS BaseImponible, Iva1 AS IvaP, TIva1 AS Iva, RE1 AS ReP, TRE1 AS Re, Total FROM VenFacturas WHERE BaseImponible1 <> 0 OR TIva1 <> 0 UNION ALL SELECT FechaFactura, Seccion, NumFactura, NombreFiscal, CodCliente, NIF, FechaAsiento, Asiento, NOrden, NumSerieFactura, BaseImponible2, Iva2, TIva2, RE2, TRE2, 0 FROM VenFacturas WHERE BaseImponible2 <> 0 OR TIva2 <> 0 UNION ALL SELECT FechaFactura, Seccion, NumFactura, NombreFiscal, CodCliente, NIF, FechaAsiento, Asiento, NOrden, NumSerieFactura, BaseImponible3, Iva3, TIva3, RE3, TRE3, 0 FROM VenFacturas WHERE BaseImponible3 <> 0 OR TIva3 <> 0) AS DIV"
"GROUP BY IvaP, Rep"


[CONDICIONS] 2
"Seccion","Seccin",0,1
"FechaFactura","Fecha",0,2
;"NombreFiscal","Nombre Cliente",0,1


[ORDENACIONS] 0
;"FechaFactura, NumFactura","Fecha Factura",3
;"FechaFactura","Fecha",3



[CAPSALERA]
0, 5, #TRUE#, 0, #TRUE#, #FALSE#, 0
; RAp(n), Alt(n), SMin(b), Salto(D), GA(b), All(b), Rel(D)
[CAMPS] 6
3, "COS", "IVAP", 40,0,"ARIAL",10,0,1,"0000","0.00"
3, "COS", "REP", 55,0,"ARIAL",10,0,1,"0000","#"
3, "COS", "Total_BaseImponible", 90,0,"ARIAL",10,0,1,"0000","Total"
3, "COS", "Total_IVA", 120,0,"ARIAL",10,0,1,"0000","Total"
3, "COS", "Total_RE", 150,0,"ARIAL",10,0,1,"0000","Total"
3, "COS", "Total_General", 180,0,"ARIAL",10,0,1,"0000","Total"
[FICAP]
[FIGRUP]


[CALCULS] 4
"TBI","COS","Total_BaseImponible","GENERAL"
"TIVA","COS","Total_Iva","GENERAL"
"TRE","COS","Total_RE","GENERAL"
"T","COS","Total_General","GENERAL"

[FIDOCUM]


