"VER1.0","Diario","Resumen Asiento"
;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] 2
3,"CABECERA","NombreComercial",10,0,"ARIAL",22,0,0,"1000",""
3,"CABECERA","Nif",10,8,"ARIAL",8,0,0,"1000",""
[FICAP]

[FIGRUP]

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

; Tipo, NomGrup, InicNumPag,   Select, From, GropBy
[GRUP]
0, "GENERAL", #FALSE#
""
""
""
;[ordenaciones] y [condiciones]
[CAPSALERA]
10, 25, #TRUE#, 0, #TRUE#, #TRUE#, 0
; RAp(n), Alt(n), SMin(b), Salto(D), GA(b), All(b), Rel(D)
[CAMPS] 13
0,"Pgina :",165,0,"ARIAL",8,0,0,"1000"
6,"Pagina",195,0,"ARIAL",8,0,1,"1000",""
0,"Fecha :",165,5,"ARIAL",8,0,0,"1000"
6,"Fecha",195,5,"ARIAL",8,0,1,"1000",""
0, "Resumen de asientos", 105, 7, "ARIAL", 22, 0, 2, "1000"
1,"lineaH1",5,17,195,17,,,
1,"lineaH2",5,22,195,22,,,
0,"Ao",30,18,"ARIAL",8,0,1,"1000"
0,"Mes",60,18,"ARIAL",8,0,1,"1000"
0,"Nmero Apuntes",90,18,"ARIAL",8,0,1,"1000"
0,"Cantidad Debe",120,18,"ARIAL",8,0,1,"1000"
0,"Cantidad Haber",150,18,"ARIAL",8,0,1,"1000"
0,"Descuadre",180,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] 4
0,"Totales :",30,5,"ARIAL",8,0,1,"1000"
5,0,"TD",120,5,"ARIAL",8,0,1,"1000","Total"
5,0,"TH",150,5,"ARIAL",8,0,1,"1000","Total"
5,0,"TDescuadre",180,5,"ARIAL",8,0,1,"1000","Total"
[FIPEU]

[FIGRUP]

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

;tipo, NomGrup, Select, From, GropBy
[GRUP]
3,"COS", #FALSE#
"SELECT Year(Asientos.FechaAsiento) AS Ao, Month(Asientos.FechaAsiento) AS Mes, Count(Apuntes.Asiento) AS CuentaDeAsiento, Sum(CantidadD) AS SumaDeCantidadD, Sum(CantidadH) AS SumaDeCantidadH, Sum((CantidadD - CantidadH)) AS Descuadre "
"FROM Asientos INNER JOIN Apuntes ON (Asientos.Seccion = Apuntes.Seccion) AND (Asientos.Asiento = Apuntes.Asiento) AND (Asientos.FechaAsiento = Apuntes.FechaAsiento) "
"GROUP BY Year(Asientos.FechaAsiento), Month(Asientos.FechaAsiento) "

[CONDICIONS] 2
"Year(Asientos.FechaAsiento)","Ao",0,1
"Apuntes.Seccion","Seccin",0,1

[ORDENACIONS] 0
;"FechaAsiento, Asiento, Apunte","Fecha",3
;"Apunte","Nmero de Apunte",3
;"Asiento","Nmero de Asiento",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", "Ao", 30,0,"ARIAL",8,0,1,"0000",""
3, "COS", "Mes", 60,0,"ARIAL",8,115,1,"0000",""
3, "COS", "CuentaDeAsiento", 90,0,"ARIAL",8,0,1,"0000",""
3, "COS", "SumaDeCantidadD", 120,0,"ARIAL",8,0,1,"0000","Total"
3, "COS", "SumaDeCantidadH", 150,0,"ARIAL",8,30,1,"0000","Total"
3, "COS", "Descuadre", 180,0,"ARIAL",8,55,1,"0000","Total"
[FICAP]
[FIGRUP]


[CALCULS] 3
"TD","COS","SumaDeCantidadD","GENERAL"
"TH","COS","SumaDeCantidadH","GENERAL"
"TDescuadre","COS","Descuadre","GENERAL"

[FIDOCUM]




