"VER1.0","Centro de Costes","Cuadro de subcuentas por centro de coste (apaisado)"
;Versio, Categoria, Descripcion
;
; CentroCosteCuadro.txt -- 03/10/2026. Cuadro de doble entrada: una fila por subcuenta de los grupos
; 6 y 7, una columna por centro de coste, el importe en el cruce, el total de la fila en la última
; columna y, al pie, los totales de cada centro (ingresos, gastos y resultado).
;
; POR QUÉ ESTÁ HECHO ASÍ (leer antes de tocar):
; - Las columnas de un impreso son FIJAS, y los códigos de centro son de cada empresa. Para no
;   escribir códigos en el fichero, los centros se numeran por orden de código (la subconsulta R:
;   cuántos centros tienen un código menor o igual). La columna 1 es el primero, y así hasta 10.
; - OTROS recoge lo que no cabe: los centros a partir del 11º y los apuntes SIN centro. Así el
;   total de la fila y los del pie cuadran siempre con la contabilidad de las cuentas 6 y 7.
; - Los títulos de las columnas (código y nombre de cada centro) salen de la consulta de TITULOS.
; - Pablo pidió poder elegir entre centros y "familias de centros", pero confirmó que hoy no hay
;   familias: CentrosCoste solo tiene código y descripción. Cuando exista ese campo, la versión por
;   familias es este mismo fichero numerando familias en vez de centros.
; - Mismo criterio de importes que CentroCosteDetalle.txt: ingreso = Haber - Debe de las cuentas 7,
;   gasto = Debe - Haber de las 6. Los dos salen en positivo: los ingresos en verde y los gastos
;   en rojo. El RESULTADO del pie es ingresos menos gastos.
; - Por cada columna hay cinco campos: VIn / VGn son lo que se imprime (en blanco si es 0, para que
;   el cuadro se lea); SIn / SGn / SRn son las mismas cifras sin blanquear y solo alimentan los
;   [CALCULS] del pie. Una fila es de ingreso o de gasto, nunca las dos: por eso VIn y VGn pueden
;   compartir sitio.
; - La subconsulta R no lleva WHERE (usa un JOIN con <=) a propósito: el motor busca un WHERE en la
;   consulta para añadir los filtros con AND y no debe tropezar con el de una subconsulta.
; - Primero los ingresos y luego los gastos: la ordenación empieza por IIF(cuenta<'7', 1, 0), que
;   también está en el GROUP BY para que Access la admita.
; - NO usa funciones de fecha. El periodo se elige con el filtro Fecha del asiento.
; - Letra a 7 puntos y 17 mm por centro: cabe "123.456,78". Un importe de un millón o más en una
;   sola casilla se cortaría con puntos suspensivos.

;Ampla, Llarg, [EspaiCos]     9 = A4
;MargenX,MargenY, EtiLin, EtiPag
[DOCUM]
H, 9, 10
10,8,0,0

[GRUP]
1,"CABECERA", #FALSE#
"SELECT * "
"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] 1
3,"CABECERA","NombreComercial",0,7.5,"ARIAL",9,150,0,"0000","","",9
[FICAP]
[PEU]
0, 17, #TRUE#, 0, #TRUE#, #FALSE#, 0
; RAp(n), Alt(n), SMin(b), Salto(D), GA(b), All(b), Rel(D)
[CAMPS] 41
1,"lineaTot",0,1,277,1,,,
0,"TOTAL INGRESOS",20,2.3,"ARIAL",7,48,0,"1000","","",3
0,"TOTAL GASTOS",20,6.6,"ARIAL",7,48,0,"1000","","",4
0,"RESULTADO",20,11.2,"ARIAL",7,48,0,"1000","","",7
1,"lineaRes",0,10.6,277,10.6,,,
5,0,"TI1",70.5,2.3,"ARIAL",7,16.5,1,"1000","","",3
5,1,"TG1",70.5,6.6,"ARIAL",7,16.5,1,"1000","","",4
5,2,"TR1",70.5,11.2,"ARIAL",7,16.5,1,"1000","","",7
5,3,"TI2",87.5,2.3,"ARIAL",7,16.5,1,"1000","","",3
5,4,"TG2",87.5,6.6,"ARIAL",7,16.5,1,"1000","","",4
5,5,"TR2",87.5,11.2,"ARIAL",7,16.5,1,"1000","","",7
5,6,"TI3",104.5,2.3,"ARIAL",7,16.5,1,"1000","","",3
5,7,"TG3",104.5,6.6,"ARIAL",7,16.5,1,"1000","","",4
5,8,"TR3",104.5,11.2,"ARIAL",7,16.5,1,"1000","","",7
5,9,"TI4",121.5,2.3,"ARIAL",7,16.5,1,"1000","","",3
5,10,"TG4",121.5,6.6,"ARIAL",7,16.5,1,"1000","","",4
5,11,"TR4",121.5,11.2,"ARIAL",7,16.5,1,"1000","","",7
5,12,"TI5",138.5,2.3,"ARIAL",7,16.5,1,"1000","","",3
5,13,"TG5",138.5,6.6,"ARIAL",7,16.5,1,"1000","","",4
5,14,"TR5",138.5,11.2,"ARIAL",7,16.5,1,"1000","","",7
5,15,"TI6",155.5,2.3,"ARIAL",7,16.5,1,"1000","","",3
5,16,"TG6",155.5,6.6,"ARIAL",7,16.5,1,"1000","","",4
5,17,"TR6",155.5,11.2,"ARIAL",7,16.5,1,"1000","","",7
5,18,"TI7",172.5,2.3,"ARIAL",7,16.5,1,"1000","","",3
5,19,"TG7",172.5,6.6,"ARIAL",7,16.5,1,"1000","","",4
5,20,"TR7",172.5,11.2,"ARIAL",7,16.5,1,"1000","","",7
5,21,"TI8",189.5,2.3,"ARIAL",7,16.5,1,"1000","","",3
5,22,"TG8",189.5,6.6,"ARIAL",7,16.5,1,"1000","","",4
5,23,"TR8",189.5,11.2,"ARIAL",7,16.5,1,"1000","","",7
5,24,"TI9",206.5,2.3,"ARIAL",7,16.5,1,"1000","","",3
5,25,"TG9",206.5,6.6,"ARIAL",7,16.5,1,"1000","","",4
5,26,"TR9",206.5,11.2,"ARIAL",7,16.5,1,"1000","","",7
5,27,"TI10",223.5,2.3,"ARIAL",7,16.5,1,"1000","","",3
5,28,"TG10",223.5,6.6,"ARIAL",7,16.5,1,"1000","","",4
5,29,"TR10",223.5,11.2,"ARIAL",7,16.5,1,"1000","","",7
5,30,"TI11",240.5,2.3,"ARIAL",7,16.5,1,"1000","","",3
5,31,"TG11",240.5,6.6,"ARIAL",7,16.5,1,"1000","","",4
5,32,"TR11",240.5,11.2,"ARIAL",7,16.5,1,"1000","","",7
5,33,"TI12",257.5,2.3,"ARIAL",7,19.5,1,"1000","","",3
5,34,"TG12",257.5,6.6,"ARIAL",7,19.5,1,"1000","","",4
5,35,"TR12",257.5,11.2,"ARIAL",7,19.5,1,"1000","","",7
[FIPEU]
[FIGRUP]

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

[GRUP]
1,"TITULOS", #FALSE#
"SELECT Max(IIF(R.Orden=1, R.CodCentroCoste, '')) AS TC1, Max(IIF(R.Orden=1, R.NombreCentro, '')) AS TN1, Max(IIF(R.Orden=2, R.CodCentroCoste, '')) AS TC2, Max(IIF(R.Orden=2, R.NombreCentro, '')) AS TN2, Max(IIF(R.Orden=3, R.CodCentroCoste, '')) AS TC3, Max(IIF(R.Orden=3, R.NombreCentro, '')) AS TN3, Max(IIF(R.Orden=4, R.CodCentroCoste, '')) AS TC4, Max(IIF(R.Orden=4, R.NombreCentro, '')) AS TN4, Max(IIF(R.Orden=5, R.CodCentroCoste, '')) AS TC5, Max(IIF(R.Orden=5, R.NombreCentro, '')) AS TN5, Max(IIF(R.Orden=6, R.CodCentroCoste, '')) AS TC6, Max(IIF(R.Orden=6, R.NombreCentro, '')) AS TN6, Max(IIF(R.Orden=7, R.CodCentroCoste, '')) AS TC7, Max(IIF(R.Orden=7, R.NombreCentro, '')) AS TN7, Max(IIF(R.Orden=8, R.CodCentroCoste, '')) AS TC8, Max(IIF(R.Orden=8, R.NombreCentro, '')) AS TN8, Max(IIF(R.Orden=9, R.CodCentroCoste, '')) AS TC9, Max(IIF(R.Orden=9, R.NombreCentro, '')) AS TN9, Max(IIF(R.Orden=10, R.CodCentroCoste, '')) AS TC10, Max(IIF(R.Orden=10, R.NombreCentro, '')) AS TN10"
"FROM (SELECT C1.CodCentroCoste, Max(C1.Descripcion) AS NombreCentro, Count(*) AS Orden FROM CentrosCoste AS C1 INNER JOIN CentrosCoste AS C2 ON C2.CodCentroCoste <= C1.CodCentroCoste GROUP BY C1.CodCentroCoste) AS R"
""
[CAPSALERA]
0, 0, #FALSE#, 0, #FALSE#, #TRUE#, 0
; RAp(n), Alt(n), SMin(b), Salto(D), GA(b), All(b), Rel(D)
; Alt 0 y All = #TRUE#: se dibuja encima de DISENY en cada página, como CABECERA.
[CAMPS] 20
3,"TITULOS","TC1",70.5,16.2,"ARIAL",7,16.5,1,"1000","","",9
3,"TITULOS","TN1",70.5,19.8,"ARIAL",6,16.5,1,"0000","","",1
3,"TITULOS","TC2",87.5,16.2,"ARIAL",7,16.5,1,"1000","","",9
3,"TITULOS","TN2",87.5,19.8,"ARIAL",6,16.5,1,"0000","","",1
3,"TITULOS","TC3",104.5,16.2,"ARIAL",7,16.5,1,"1000","","",9
3,"TITULOS","TN3",104.5,19.8,"ARIAL",6,16.5,1,"0000","","",1
3,"TITULOS","TC4",121.5,16.2,"ARIAL",7,16.5,1,"1000","","",9
3,"TITULOS","TN4",121.5,19.8,"ARIAL",6,16.5,1,"0000","","",1
3,"TITULOS","TC5",138.5,16.2,"ARIAL",7,16.5,1,"1000","","",9
3,"TITULOS","TN5",138.5,19.8,"ARIAL",6,16.5,1,"0000","","",1
3,"TITULOS","TC6",155.5,16.2,"ARIAL",7,16.5,1,"1000","","",9
3,"TITULOS","TN6",155.5,19.8,"ARIAL",6,16.5,1,"0000","","",1
3,"TITULOS","TC7",172.5,16.2,"ARIAL",7,16.5,1,"1000","","",9
3,"TITULOS","TN7",172.5,19.8,"ARIAL",6,16.5,1,"0000","","",1
3,"TITULOS","TC8",189.5,16.2,"ARIAL",7,16.5,1,"1000","","",9
3,"TITULOS","TN8",189.5,19.8,"ARIAL",6,16.5,1,"0000","","",1
3,"TITULOS","TC9",206.5,16.2,"ARIAL",7,16.5,1,"1000","","",9
3,"TITULOS","TN9",206.5,19.8,"ARIAL",6,16.5,1,"0000","","",1
3,"TITULOS","TC10",223.5,16.2,"ARIAL",7,16.5,1,"1000","","",9
3,"TITULOS","TN10",223.5,19.8,"ARIAL",6,16.5,1,"0000","","",1
[FICAP]
[PEU]
0, 0, #FALSE#, 0, #FALSE#, #FALSE#, 0
; RAp(n), Alt(n), SMin(b), Salto(D), GA(b), All(b), Rel(D)
[CAMPS] 0
[FIPEU]
[FIGRUP]

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

[GRUP]
0,"DISENY", #FALSE#
""
""
""
[CAPSALERA]
0, 26, #TRUE#, 0, #TRUE#, #TRUE#, 0
; RAp(n), Alt(n), SMin(b), Salto(D), GA(b), All(b), Rel(D)
[CAMPS] 10
0,"Subcuentas por centro de coste",0,0,"ARIAL",16,180,0,"1000","","",7
0,"Página",263,1.5,"ARIAL",8,12,0,"0000","","",1
6,"Pagina",277,1.5,"ARIAL",8,0,1,"1000","","",7
0,"Cuentas de ingreso (7, en verde) y de gasto (6, en rojo). OTROS = apuntes sin centro y centros a partir del 11º.",0,11.5,"ARIAL",7,257,0,"0000","","",1
1,"lineaSup",0,15,277,15,,,
0,"SUBCUENTA",0,16.2,"ARIAL",7,19,0,"1000","","",9
0,"TÍTULO",20,16.2,"ARIAL",7,48,0,"1000","","",9
0,"OTROS",240.5,16.2,"ARIAL",7,16.5,1,"1000","","",9
0,"TOTAL",257.5,16.2,"ARIAL",7,19.5,1,"1000","","",7
1,"lineaInf",0,24,277,24,,,
[FICAP]
[PEU]
0, 0, #FALSE#, 0, #FALSE#, #FALSE#, 0
; RAp(n), Alt(n), SMin(b), Salto(D), GA(b), All(b), Rel(D)
[CAMPS] 0
[FIPEU]
[FIGRUP]

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

[GRUP]
3,"COS", #FALSE#
"SELECT SubCuentas08.CodCuenta, SubCuentas08.Titulo, IIF(Sum(IIF(R.Orden=1 AND SubCuentas08.CodCuenta>='7', Nz(Apuntes.CantidadH,0)-Nz(Apuntes.CantidadD,0), 0))=0, Null, Sum(IIF(R.Orden=1 AND SubCuentas08.CodCuenta>='7', Nz(Apuntes.CantidadH,0)-Nz(Apuntes.CantidadD,0), 0))) AS VI1, IIF(Sum(IIF(R.Orden=1 AND SubCuentas08.CodCuenta<'7', Nz(Apuntes.CantidadD,0)-Nz(Apuntes.CantidadH,0), 0))=0, Null, Sum(IIF(R.Orden=1 AND SubCuentas08.CodCuenta<'7', Nz(Apuntes.CantidadD,0)-Nz(Apuntes.CantidadH,0), 0))) AS VG1, Sum(IIF(R.Orden=1 AND SubCuentas08.CodCuenta>='7', Nz(Apuntes.CantidadH,0)-Nz(Apuntes.CantidadD,0), 0)) AS SI1, Sum(IIF(R.Orden=1 AND SubCuentas08.CodCuenta<'7', Nz(Apuntes.CantidadD,0)-Nz(Apuntes.CantidadH,0), 0)) AS SG1, Sum(IIF(R.Orden=1, Nz(Apuntes.CantidadH,0)-Nz(Apuntes.CantidadD,0), 0)) AS SR1, IIF(Sum(IIF(R.Orden=2 AND SubCuentas08.CodCuenta>='7', Nz(Apuntes.CantidadH,0)-Nz(Apuntes.CantidadD,0), 0))=0, Null, Sum(IIF(R.Orden=2 AND SubCuentas08.CodCuenta>='7', Nz(Apuntes.CantidadH,0)-Nz(Apuntes.CantidadD,0), 0))) AS VI2, IIF(Sum(IIF(R.Orden=2 AND SubCuentas08.CodCuenta<'7', Nz(Apuntes.CantidadD,0)-Nz(Apuntes.CantidadH,0), 0))=0, Null, Sum(IIF(R.Orden=2 AND SubCuentas08.CodCuenta<'7', Nz(Apuntes.CantidadD,0)-Nz(Apuntes.CantidadH,0), 0))) AS VG2, Sum(IIF(R.Orden=2 AND SubCuentas08.CodCuenta>='7', Nz(Apuntes.CantidadH,0)-Nz(Apuntes.CantidadD,0), 0)) AS SI2, Sum(IIF(R.Orden=2 AND SubCuentas08.CodCuenta<'7', Nz(Apuntes.CantidadD,0)-Nz(Apuntes.CantidadH,0), 0)) AS SG2, Sum(IIF(R.Orden=2, Nz(Apuntes.CantidadH,0)-Nz(Apuntes.CantidadD,0), 0)) AS SR2, IIF(Sum(IIF(R.Orden=3 AND SubCuentas08.CodCuenta>='7', Nz(Apuntes.CantidadH,0)-Nz(Apuntes.CantidadD,0), 0))=0, Null, Sum(IIF(R.Orden=3 AND SubCuentas08.CodCuenta>='7', Nz(Apuntes.CantidadH,0)-Nz(Apuntes.CantidadD,0), 0))) AS VI3, IIF(Sum(IIF(R.Orden=3 AND SubCuentas08.CodCuenta<'7', Nz(Apuntes.CantidadD,0)-Nz(Apuntes.CantidadH,0), 0))=0, Null, Sum(IIF(R.Orden=3 AND SubCuentas08.CodCuenta<'7', Nz(Apuntes.CantidadD,0)-Nz(Apuntes.CantidadH,0), 0))) AS VG3, Sum(IIF(R.Orden=3 AND SubCuentas08.CodCuenta>='7', Nz(Apuntes.CantidadH,0)-Nz(Apuntes.CantidadD,0), 0)) AS SI3, Sum(IIF(R.Orden=3 AND SubCuentas08.CodCuenta<'7', Nz(Apuntes.CantidadD,0)-Nz(Apuntes.CantidadH,0), 0)) AS SG3, Sum(IIF(R.Orden=3, Nz(Apuntes.CantidadH,0)-Nz(Apuntes.CantidadD,0), 0)) AS SR3, IIF(Sum(IIF(R.Orden=4 AND SubCuentas08.CodCuenta>='7', Nz(Apuntes.CantidadH,0)-Nz(Apuntes.CantidadD,0), 0))=0, Null, Sum(IIF(R.Orden=4 AND SubCuentas08.CodCuenta>='7', Nz(Apuntes.CantidadH,0)-Nz(Apuntes.CantidadD,0), 0))) AS VI4, IIF(Sum(IIF(R.Orden=4 AND SubCuentas08.CodCuenta<'7', Nz(Apuntes.CantidadD,0)-Nz(Apuntes.CantidadH,0), 0))=0, Null, Sum(IIF(R.Orden=4 AND SubCuentas08.CodCuenta<'7', Nz(Apuntes.CantidadD,0)-Nz(Apuntes.CantidadH,0), 0))) AS VG4, Sum(IIF(R.Orden=4 AND SubCuentas08.CodCuenta>='7', Nz(Apuntes.CantidadH,0)-Nz(Apuntes.CantidadD,0), 0)) AS SI4, Sum(IIF(R.Orden=4 AND SubCuentas08.CodCuenta<'7', Nz(Apuntes.CantidadD,0)-Nz(Apuntes.CantidadH,0), 0)) AS SG4, Sum(IIF(R.Orden=4, Nz(Apuntes.CantidadH,0)-Nz(Apuntes.CantidadD,0), 0)) AS SR4, IIF(Sum(IIF(R.Orden=5 AND SubCuentas08.CodCuenta>='7', Nz(Apuntes.CantidadH,0)-Nz(Apuntes.CantidadD,0), 0))=0, Null, Sum(IIF(R.Orden=5 AND SubCuentas08.CodCuenta>='7', Nz(Apuntes.CantidadH,0)-Nz(Apuntes.CantidadD,0), 0))) AS VI5, IIF(Sum(IIF(R.Orden=5 AND SubCuentas08.CodCuenta<'7', Nz(Apuntes.CantidadD,0)-Nz(Apuntes.CantidadH,0), 0))=0, Null, Sum(IIF(R.Orden=5 AND SubCuentas08.CodCuenta<'7', Nz(Apuntes.CantidadD,0)-Nz(Apuntes.CantidadH,0), 0))) AS VG5, Sum(IIF(R.Orden=5 AND SubCuentas08.CodCuenta>='7', Nz(Apuntes.CantidadH,0)-Nz(Apuntes.CantidadD,0), 0)) AS SI5, Sum(IIF(R.Orden=5 AND SubCuentas08.CodCuenta<'7', Nz(Apuntes.CantidadD,0)-Nz(Apuntes.CantidadH,0), 0)) AS SG5, Sum(IIF(R.Orden=5, Nz(Apuntes.CantidadH,0)-Nz(Apuntes.CantidadD,0), 0)) AS SR5, IIF(Sum(IIF(R.Orden=6 AND SubCuentas08.CodCuenta>='7', Nz(Apuntes.CantidadH,0)-Nz(Apuntes.CantidadD,0), 0))=0, Null, Sum(IIF(R.Orden=6 AND SubCuentas08.CodCuenta>='7', Nz(Apuntes.CantidadH,0)-Nz(Apuntes.CantidadD,0), 0))) AS VI6, IIF(Sum(IIF(R.Orden=6 AND SubCuentas08.CodCuenta<'7', Nz(Apuntes.CantidadD,0)-Nz(Apuntes.CantidadH,0), 0))=0, Null, Sum(IIF(R.Orden=6 AND SubCuentas08.CodCuenta<'7', Nz(Apuntes.CantidadD,0)-Nz(Apuntes.CantidadH,0), 0))) AS VG6, Sum(IIF(R.Orden=6 AND SubCuentas08.CodCuenta>='7', Nz(Apuntes.CantidadH,0)-Nz(Apuntes.CantidadD,0), 0)) AS SI6, Sum(IIF(R.Orden=6 AND SubCuentas08.CodCuenta<'7', Nz(Apuntes.CantidadD,0)-Nz(Apuntes.CantidadH,0), 0)) AS SG6, Sum(IIF(R.Orden=6, Nz(Apuntes.CantidadH,0)-Nz(Apuntes.CantidadD,0), 0)) AS SR6, IIF(Sum(IIF(R.Orden=7 AND SubCuentas08.CodCuenta>='7', Nz(Apuntes.CantidadH,0)-Nz(Apuntes.CantidadD,0), 0))=0, Null, Sum(IIF(R.Orden=7 AND SubCuentas08.CodCuenta>='7', Nz(Apuntes.CantidadH,0)-Nz(Apuntes.CantidadD,0), 0))) AS VI7, IIF(Sum(IIF(R.Orden=7 AND SubCuentas08.CodCuenta<'7', Nz(Apuntes.CantidadD,0)-Nz(Apuntes.CantidadH,0), 0))=0, Null, Sum(IIF(R.Orden=7 AND SubCuentas08.CodCuenta<'7', Nz(Apuntes.CantidadD,0)-Nz(Apuntes.CantidadH,0), 0))) AS VG7, Sum(IIF(R.Orden=7 AND SubCuentas08.CodCuenta>='7', Nz(Apuntes.CantidadH,0)-Nz(Apuntes.CantidadD,0), 0)) AS SI7, Sum(IIF(R.Orden=7 AND SubCuentas08.CodCuenta<'7', Nz(Apuntes.CantidadD,0)-Nz(Apuntes.CantidadH,0), 0)) AS SG7, Sum(IIF(R.Orden=7, Nz(Apuntes.CantidadH,0)-Nz(Apuntes.CantidadD,0), 0)) AS SR7, IIF(Sum(IIF(R.Orden=8 AND SubCuentas08.CodCuenta>='7', Nz(Apuntes.CantidadH,0)-Nz(Apuntes.CantidadD,0), 0))=0, Null, Sum(IIF(R.Orden=8 AND SubCuentas08.CodCuenta>='7', Nz(Apuntes.CantidadH,0)-Nz(Apuntes.CantidadD,0), 0))) AS VI8, IIF(Sum(IIF(R.Orden=8 AND SubCuentas08.CodCuenta<'7', Nz(Apuntes.CantidadD,0)-Nz(Apuntes.CantidadH,0), 0))=0, Null, Sum(IIF(R.Orden=8 AND SubCuentas08.CodCuenta<'7', Nz(Apuntes.CantidadD,0)-Nz(Apuntes.CantidadH,0), 0))) AS VG8, Sum(IIF(R.Orden=8 AND SubCuentas08.CodCuenta>='7', Nz(Apuntes.CantidadH,0)-Nz(Apuntes.CantidadD,0), 0)) AS SI8, Sum(IIF(R.Orden=8 AND SubCuentas08.CodCuenta<'7', Nz(Apuntes.CantidadD,0)-Nz(Apuntes.CantidadH,0), 0)) AS SG8, Sum(IIF(R.Orden=8, Nz(Apuntes.CantidadH,0)-Nz(Apuntes.CantidadD,0), 0)) AS SR8, IIF(Sum(IIF(R.Orden=9 AND SubCuentas08.CodCuenta>='7', Nz(Apuntes.CantidadH,0)-Nz(Apuntes.CantidadD,0), 0))=0, Null, Sum(IIF(R.Orden=9 AND SubCuentas08.CodCuenta>='7', Nz(Apuntes.CantidadH,0)-Nz(Apuntes.CantidadD,0), 0))) AS VI9, IIF(Sum(IIF(R.Orden=9 AND SubCuentas08.CodCuenta<'7', Nz(Apuntes.CantidadD,0)-Nz(Apuntes.CantidadH,0), 0))=0, Null, Sum(IIF(R.Orden=9 AND SubCuentas08.CodCuenta<'7', Nz(Apuntes.CantidadD,0)-Nz(Apuntes.CantidadH,0), 0))) AS VG9, Sum(IIF(R.Orden=9 AND SubCuentas08.CodCuenta>='7', Nz(Apuntes.CantidadH,0)-Nz(Apuntes.CantidadD,0), 0)) AS SI9, Sum(IIF(R.Orden=9 AND SubCuentas08.CodCuenta<'7', Nz(Apuntes.CantidadD,0)-Nz(Apuntes.CantidadH,0), 0)) AS SG9, Sum(IIF(R.Orden=9, Nz(Apuntes.CantidadH,0)-Nz(Apuntes.CantidadD,0), 0)) AS SR9, IIF(Sum(IIF(R.Orden=10 AND SubCuentas08.CodCuenta>='7', Nz(Apuntes.CantidadH,0)-Nz(Apuntes.CantidadD,0), 0))=0, Null, Sum(IIF(R.Orden=10 AND SubCuentas08.CodCuenta>='7', Nz(Apuntes.CantidadH,0)-Nz(Apuntes.CantidadD,0), 0))) AS VI10, IIF(Sum(IIF(R.Orden=10 AND SubCuentas08.CodCuenta<'7', Nz(Apuntes.CantidadD,0)-Nz(Apuntes.CantidadH,0), 0))=0, Null, Sum(IIF(R.Orden=10 AND SubCuentas08.CodCuenta<'7', Nz(Apuntes.CantidadD,0)-Nz(Apuntes.CantidadH,0), 0))) AS VG10, Sum(IIF(R.Orden=10 AND SubCuentas08.CodCuenta>='7', Nz(Apuntes.CantidadH,0)-Nz(Apuntes.CantidadD,0), 0)) AS SI10, Sum(IIF(R.Orden=10 AND SubCuentas08.CodCuenta<'7', Nz(Apuntes.CantidadD,0)-Nz(Apuntes.CantidadH,0), 0)) AS SG10, Sum(IIF(R.Orden=10, Nz(Apuntes.CantidadH,0)-Nz(Apuntes.CantidadD,0), 0)) AS SR10, IIF(Sum(IIF(Nz(R.Orden,99)>10 AND SubCuentas08.CodCuenta>='7', Nz(Apuntes.CantidadH,0)-Nz(Apuntes.CantidadD,0), 0))=0, Null, Sum(IIF(Nz(R.Orden,99)>10 AND SubCuentas08.CodCuenta>='7', Nz(Apuntes.CantidadH,0)-Nz(Apuntes.CantidadD,0), 0))) AS VI11, IIF(Sum(IIF(Nz(R.Orden,99)>10 AND SubCuentas08.CodCuenta<'7', Nz(Apuntes.CantidadD,0)-Nz(Apuntes.CantidadH,0), 0))=0, Null, Sum(IIF(Nz(R.Orden,99)>10 AND SubCuentas08.CodCuenta<'7', Nz(Apuntes.CantidadD,0)-Nz(Apuntes.CantidadH,0), 0))) AS VG11, Sum(IIF(Nz(R.Orden,99)>10 AND SubCuentas08.CodCuenta>='7', Nz(Apuntes.CantidadH,0)-Nz(Apuntes.CantidadD,0), 0)) AS SI11, Sum(IIF(Nz(R.Orden,99)>10 AND SubCuentas08.CodCuenta<'7', Nz(Apuntes.CantidadD,0)-Nz(Apuntes.CantidadH,0), 0)) AS SG11, Sum(IIF(Nz(R.Orden,99)>10, Nz(Apuntes.CantidadH,0)-Nz(Apuntes.CantidadD,0), 0)) AS SR11, IIF(Sum(IIF(SubCuentas08.CodCuenta>='7', Nz(Apuntes.CantidadH,0)-Nz(Apuntes.CantidadD,0), 0))=0, Null, Sum(IIF(SubCuentas08.CodCuenta>='7', Nz(Apuntes.CantidadH,0)-Nz(Apuntes.CantidadD,0), 0))) AS VI12, IIF(Sum(IIF(SubCuentas08.CodCuenta<'7', Nz(Apuntes.CantidadD,0)-Nz(Apuntes.CantidadH,0), 0))=0, Null, Sum(IIF(SubCuentas08.CodCuenta<'7', Nz(Apuntes.CantidadD,0)-Nz(Apuntes.CantidadH,0), 0))) AS VG12, Sum(IIF(SubCuentas08.CodCuenta>='7', Nz(Apuntes.CantidadH,0)-Nz(Apuntes.CantidadD,0), 0)) AS SI12, Sum(IIF(SubCuentas08.CodCuenta<'7', Nz(Apuntes.CantidadD,0)-Nz(Apuntes.CantidadH,0), 0)) AS SG12, Sum(Nz(Apuntes.CantidadH,0)-Nz(Apuntes.CantidadD,0)) AS SR12"
"FROM (Apuntes INNER JOIN SubCuentas08 ON Apuntes.CodCuenta = SubCuentas08.CodCuenta) LEFT JOIN (SELECT C1.CodCentroCoste, Max(C1.Descripcion) AS NombreCentro, Count(*) AS Orden FROM CentrosCoste AS C1 INNER JOIN CentrosCoste AS C2 ON C2.CodCentroCoste <= C1.CodCentroCoste GROUP BY C1.CodCentroCoste) AS R ON Apuntes.CentroCoste = R.CodCentroCoste WHERE (SubCuentas08.CodCuenta>='6' AND SubCuentas08.CodCuenta<'8')"
"GROUP BY SubCuentas08.CodCuenta, SubCuentas08.Titulo, IIF(SubCuentas08.CodCuenta<'7', 1, 0)"
[CONDICIONS] 2
"Apuntes.FechaAsiento","Fecha del asiento",0,2
"Apuntes.CentroCoste","Centro de coste",0,1

[ORDENACIONS] 2
"IIF(SubCuentas08.CodCuenta<'7', 1, 0), SubCuentas08.CodCuenta","Ingresos primero",3
"SubCuentas08.CodCuenta","Por subcuenta (gastos primero)",3

[CAPSALERA]
0, 4.6, #TRUE#, 0, #TRUE#, #FALSE#, 0
; RAp(n), Alt(n), SMin(b), Salto(D), GA(b), All(b), Rel(D)
[CAMPS] 26
3,"COS","CodCuenta",0,0.6,"ARIAL",7,19,0,"0000","","",9
3,"COS","Titulo",20,0.6,"ARIAL",7,48,0,"0000","","",0
3,"COS","VI1",70.5,0.6,"ARIAL",7,16.5,1,"0000","","",3
3,"COS","VG1",70.5,0.6,"ARIAL",7,16.5,1,"0000","","",4
3,"COS","VI2",87.5,0.6,"ARIAL",7,16.5,1,"0000","","",3
3,"COS","VG2",87.5,0.6,"ARIAL",7,16.5,1,"0000","","",4
3,"COS","VI3",104.5,0.6,"ARIAL",7,16.5,1,"0000","","",3
3,"COS","VG3",104.5,0.6,"ARIAL",7,16.5,1,"0000","","",4
3,"COS","VI4",121.5,0.6,"ARIAL",7,16.5,1,"0000","","",3
3,"COS","VG4",121.5,0.6,"ARIAL",7,16.5,1,"0000","","",4
3,"COS","VI5",138.5,0.6,"ARIAL",7,16.5,1,"0000","","",3
3,"COS","VG5",138.5,0.6,"ARIAL",7,16.5,1,"0000","","",4
3,"COS","VI6",155.5,0.6,"ARIAL",7,16.5,1,"0000","","",3
3,"COS","VG6",155.5,0.6,"ARIAL",7,16.5,1,"0000","","",4
3,"COS","VI7",172.5,0.6,"ARIAL",7,16.5,1,"0000","","",3
3,"COS","VG7",172.5,0.6,"ARIAL",7,16.5,1,"0000","","",4
3,"COS","VI8",189.5,0.6,"ARIAL",7,16.5,1,"0000","","",3
3,"COS","VG8",189.5,0.6,"ARIAL",7,16.5,1,"0000","","",4
3,"COS","VI9",206.5,0.6,"ARIAL",7,16.5,1,"0000","","",3
3,"COS","VG9",206.5,0.6,"ARIAL",7,16.5,1,"0000","","",4
3,"COS","VI10",223.5,0.6,"ARIAL",7,16.5,1,"0000","","",3
3,"COS","VG10",223.5,0.6,"ARIAL",7,16.5,1,"0000","","",4
3,"COS","VI11",240.5,0.6,"ARIAL",7,16.5,1,"0000","","",3
3,"COS","VG11",240.5,0.6,"ARIAL",7,16.5,1,"0000","","",4
3,"COS","VI12",257.5,0.6,"ARIAL",7,19.5,1,"1000","","",3
3,"COS","VG12",257.5,0.6,"ARIAL",7,19.5,1,"1000","","",4
[FICAP]
[FIGRUP]

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

[CALCULS] 36
"TI1","COS","SI1","CABECERA"
"TG1","COS","SG1","CABECERA"
"TR1","COS","SR1","CABECERA"
"TI2","COS","SI2","CABECERA"
"TG2","COS","SG2","CABECERA"
"TR2","COS","SR2","CABECERA"
"TI3","COS","SI3","CABECERA"
"TG3","COS","SG3","CABECERA"
"TR3","COS","SR3","CABECERA"
"TI4","COS","SI4","CABECERA"
"TG4","COS","SG4","CABECERA"
"TR4","COS","SR4","CABECERA"
"TI5","COS","SI5","CABECERA"
"TG5","COS","SG5","CABECERA"
"TR5","COS","SR5","CABECERA"
"TI6","COS","SI6","CABECERA"
"TG6","COS","SG6","CABECERA"
"TR6","COS","SR6","CABECERA"
"TI7","COS","SI7","CABECERA"
"TG7","COS","SG7","CABECERA"
"TR7","COS","SR7","CABECERA"
"TI8","COS","SI8","CABECERA"
"TG8","COS","SG8","CABECERA"
"TR8","COS","SR8","CABECERA"
"TI9","COS","SI9","CABECERA"
"TG9","COS","SG9","CABECERA"
"TR9","COS","SR9","CABECERA"
"TI10","COS","SI10","CABECERA"
"TG10","COS","SG10","CABECERA"
"TR10","COS","SR10","CABECERA"
"TI11","COS","SI11","CABECERA"
"TG11","COS","SG11","CABECERA"
"TR11","COS","SR11","CABECERA"
"TI12","COS","SI12","CABECERA"
"TG12","COS","SG12","CABECERA"
"TR12","COS","SR12","CABECERA"

[FIDOCUM]
