"VER1.0","Cuentas","Listado de Cuentas"
;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 : ",10,12,"ARIAL",8,0,0,"1000"
6,"Condiciones",35,12,"ARIAL",8,0,0,"1000",""
[FICAP]

[FIGRUP]

;tipo, NomGrup, Select, From, GropBy                                          P A B L O
[GRUP]
2,"CAB1", #FALSE#
"SELECT Sum(Apuntes.CantidadD) AS SumaTotalD, Sum(Apuntes.CantidadH) AS SumaTotalH, Sum(Apuntes.CantidadH)-Sum(Apuntes.CantidadD) as SumaTotalSaldo "
"FROM SubCuentas INNER JOIN Apuntes ON SubCuentas.CodCuenta = Apuntes.CodCuenta WHERE SubCuentas.CuentaExplotacion = true AND NOT EXISTS (SELECT 1 FROM Asientos AS A WHERE A.FechaAsiento = Apuntes.FechaAsiento AND A.Asiento = Apuntes.Asiento AND A.Seccion = Apuntes.Seccion AND A.Tipo IN ('R','C')) "
""

[CONDICIONS] 2
"Seccion","Seccion ",0,1
"Apuntes.FechaAsiento","Fecha",0,2
;"Subcuentas.CodCuenta","Codigo Cuenta",0,1

[ORDENACIONS] 0

[CAPSALERA]
0, 0, #TRUE#, 0, #TRUE#, #FALSE#, 0
; RAp(n), Alt(n), SMin(b), Salto(D), GA(b), All(b), Rel(D)
[CAMPS] 0
0,"Pgina",10,20,"ARIAL",28,0,0,"1000"
3,"CAB1","SumaTotalSaldo",15,12,"ARIAL",20,0,0,"1000","Total"
[FICAP]

[PEU]
0, 12, #TRUE#, 0, #TRUE#, #FALSE#, 0
; RAp(n), Alt(n), SMin(b), Salto(D), GA(b), All(b), Rel(D)
[CAMPS] 1
1, "Cuadro", 45, 20, 196, 35, 1, 0,
;0,"Total",130,2,"ARIAL",12,0,0,"1000"
;3,"CAB1","TotalGen",175,2,"ARIAL",10,0,1,"1000","Total"
[FIPEU]
[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] 12
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, "Balance de Explotacion", 105, 7, "ARIAL",20, 0, 2, "1000"
1,"lineaH1",5,17,200,17,,,
0,"Cuenta",5,18,"ARIAL",8,0,0,"1000"
0,"Titulo",30,18,"ARIAL",8,0,0,"1000"
0,"Debe",115,18,"ARIAL",8,0,1,"1000"
0,"Haber",155,18,"ARIAL",8,0,1,"1000"
0,"Saldo",195,18,"ARIAL",8,0,1,"1000"
1,"lineaH2",5,22,200,22,,,
[FICAP]

[PEU]
0, 25, #TRUE#, 0, #TRUE#, #FALSE#, 0
; RAp(n), Alt(n), SMin(b), Salto(D), GA(b), All(b), Rel(D)
[CAMPS] 6
0,"Totales :",50,10,"ARIAL",12,0,0,"1000"
5,0,"Total1",115,10,"ARIAL",10,0,1,"1000","Total"
5,0,"Total2",157,10,"ARIAL",10,0,1,"1000","Total"
0,"Beneficios / Perdidas :",50,15,"ARIAL",12,0,0,"1000"
5,0,"Total3",195,15,"ARIAL",10,0,1,"1000","Total"
3,"CAB1","SumaTotalD",15,12,"ARIAL",20,0,1,"1000","Total"


[FIPEU]


[FIGRUP]

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

;tipo, NomGrup, Select, From, GropBy
[GRUP]
3,"COS", #FALSE#
"SELECT SubCuentas.CodCuenta, First(SubCuentas.Titulo) AS Titulin, Sum(Apuntes.CantidadD) AS SumaD, Sum(Apuntes.CantidadH) AS SumaH, Sum(Apuntes.CantidadH)-Sum(Apuntes.CantidadD) as Saldo "
"FROM SubCuentas INNER JOIN Apuntes ON SubCuentas.CodCuenta = Apuntes.CodCuenta WHERE SubCuentas.CuentaExplotacion = true AND NOT EXISTS (SELECT 1 FROM Asientos AS A WHERE A.FechaAsiento = Apuntes.FechaAsiento AND A.Asiento = Apuntes.Asiento AND A.Seccion = Apuntes.Seccion AND A.Tipo IN ('R','C')) "
"GROUP BY SubCuentas.CodCuenta UNION SELECT  'z', 'Valor Existencias', ExisI, ExisF, ExisF-ExisI FROM Configuracion"

[CONDICIONS] 2
"Seccion","Seccin",5,1, "CAB1"
"Apuntes.FechaAsiento","Fecha",5,2, "CAB1"
;"Seccion","Seccion ",0,1
;"Apuntes.FechaAsiento","Fecha",0,2
;"Subcuentas.CodCuenta","Codigo Cuenta",0,1

[ORDENACIONS] 1
"SubCuentas.CodCuenta","Codigo Cuenta",3


[CAPSALERA]
0, 5, #TRUE#, 0, #TRUE#, #FALSE#, 0
; RAp(n), Alt(n), SMin(b), Salto(D), GA(b), All(b), Rel(D)
[CAMPS] 9
3,"COS","CodCuenta",5,0,"ARIAL",8,0,0,"0000",""
3,"COS","Titulin",30,0,"ARIAL",8,120,0,"0000",""
3,"COS","SumaD",115,0,"ARIAL",8,0,1,"0000","Total"
8, "1", "DIV((Campo('COS','SumaD')*100),Campo('CAB1','SumaTotalD')) ", 125, 0, "ARIAL", 8, 0, 1, "0000", "##0.00"
0,"%",126,0,"ARIAL",8,0,0,"1000"
3,"COS","SumaH",155,0,"ARIAL",8,0,1,"0000","Total"
8, "1", "DIV((Campo('COS','SumaH')*100),Campo('CAB1','SumaTotalH')) ", 165, 0, "ARIAL", 8, 0, 1, "0000", "##0.00"
0,"%",166,0,"ARIAL",8,0,0,"1000"
3,"COS","Saldo",195,0,"ARIAL",8,0,1,"0000","Total"
[FICAP]


[FIGRUP]

[CALCULS] 3
"Total1","COS","SumaD","GENERAL"
"Total2","COS","SumaH","GENERAL"
"Total3","COS","Saldo","GENERAL"
[FIDOCUM]
