"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, 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, "Diferencias Saldo Contable y Efectos Pendientes", 95, 8, "ARIAL",13, 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,"Saldo",145,18,"ARIAL",8,0,1,"1000"
0,"Pendiente",170,18,"ARIAL",8,0,1,"1000"
0,"",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] 0
;0,"Totales :",80,10,"ARIAL",12,0,0,"1000"
;5,0,"Total1",145,10,"ARIAL",10,0,1,"1000","Total"
;5,0,"Total2",170,10,"ARIAL",10,0,1,"1000","Total"
;0,"Beneficios / Perdidas :",80,15,"ARIAL",12,0,0,"1000"
;5,0,"Total3",195,15,"ARIAL",10,0,1,"1000","Total"
[FIPEU]


[FIGRUP]

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

;tipo, NomGrup, Select, From, GropBy
[GRUP]
3,"COS", #FALSE#
"SELECT CodCliente, Nombre, (SELECT Sum(CantidadD-CantidadH) FROM Apuntes WHERE Apuntes.CodCuenta = Clientes.CodCliente) AS SaldoC, (SELECT Sum(Importe) FROM VenRecibos WHERE VenRecibos.CodCliente = Clientes.CodCliente AND VenRecibos.CodPago<>'F' AND VenRecibos.Contabilizado=False) AS Pendiente "
"FROM Clientes WHERE (ABS((SELECT Sum(CantidadD-CantidadH) FROM Apuntes WHERE Apuntes.CodCuenta = Clientes.CodCliente) - (SELECT Sum(Importe) FROM VenRecibos WHERE VenRecibos.CodCliente = Clientes.CodCliente AND VenRecibos.CodPago<>'F' AND VenRecibos.Contabilizado=False)) >= 0.005) OR (ABS((SELECT Sum(CantidadD-CantidadH) FROM Apuntes WHERE Apuntes.CodCuenta = Clientes.CodCliente)) >= 0.005 AND (SELECT Sum(Importe) FROM VenRecibos WHERE VenRecibos.CodCliente = Clientes.CodCliente AND VenRecibos.CodPago<>'F' AND VenRecibos.Contabilizado=False) Is Null) OR ((SELECT Sum(CantidadD-CantidadH) FROM Apuntes WHERE Apuntes.CodCuenta = Clientes.CodCliente) Is Null AND ABS((SELECT Sum(Importe) FROM VenRecibos WHERE VenRecibos.CodCliente = Clientes.CodCliente AND VenRecibos.CodPago<>'F' AND VenRecibos.Contabilizado=False)) >= 0.005)"
""

[CONDICIONS] 0

[ORDENACIONS] 0


[CAPSALERA]
0, 5, #TRUE#, 0, #TRUE#, #FALSE#, 0
; RAp(n), Alt(n), SMin(b), Salto(D), GA(b), All(b), Rel(D)
[CAMPS] 4
3,"COS","CodCliente",5,0,"ARIAL",8,0,0,"0000",""
3,"COS","Nombre",30,0,"ARIAL",8,120,0,"0000",""
3,"COS","SaldoC",145,0,"ARIAL",8,0,1,"0000","Total"
3,"COS","Pendiente",170,0,"ARIAL",8,0,1,"0000","Total"
;3,"COS","Saldo",195,0,"ARIAL",8,0,1,"0000","Total"
[FICAP]


[FIGRUP]

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






