"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,23,"ARIAL",8,0,0,"1000"
6,"Condiciones",45,23,"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 Compras", 95, 3, "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"
"FROM _DiarioIvasCompras"
"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",""
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]


