Diagnóstico contabilidad ICG (5) — leer la conta local 2026

1) Apuntes por año (2024-2026) en las bases en curso

SELECT db, anio, COUNT(*) AS n FROM (
   SELECT 'C2023001' AS db, YEAR(FECHA) AS anio FROM C2023001.dbo.DIARIOAPUNTES WHERE FECHA>='2024-01-01' AND FECHA<'2027-01-01'
   UNION ALL
   SELECT 'C2023041', YEAR(FECHA) FROM C2023041.dbo.DIARIOAPUNTES WHERE FECHA>='2024-01-01' AND FECHA<'2027-01-01'
   UNION ALL
   SELECT 'C2023047', YEAR(FECHA) FROM C2023047.dbo.DIARIOAPUNTES WHERE FECHA>='2024-01-01' AND FECHA<'2027-01-01'
 ) t
 GROUP BY db, anio
 ORDER BY db, anio
dbanion
C2023001202496367
C2023001202583315
C2023001202669952
C20230412024161528
C20230412025124256
C20230412026103143
C202304720249394
C202304720254775

8 filas


2) P&L 2026 — centros KCH por grupo de cuenta (grupos 6 y 7)

SELECT db, CENTROCOSTE, grupo,
        SUM(debe) AS debe, SUM(haber) AS haber, SUM(saldo) AS saldo, COUNT(*) AS n
 FROM (
   SELECT 'C2023001' AS db, CENTROCOSTE, LEFT(CUENTA,2) AS grupo, DEBE AS debe, HABER AS haber, (DEBE-HABER) AS saldo
     FROM C2023001.dbo.DIARIOAPUNTES
     WHERE YEAR(FECHA)=2026 AND LEFT(CUENTA,1) IN ('6','7') AND CENTROCOSTE LIKE 'KCH%'
   UNION ALL
   SELECT 'C2023041', CENTROCOSTE, LEFT(CUENTA,2), DEBE, HABER, (DEBE-HABER)
     FROM C2023041.dbo.DIARIOAPUNTES
     WHERE YEAR(FECHA)=2026 AND LEFT(CUENTA,1) IN ('6','7') AND CENTROCOSTE LIKE 'KCH%'
   UNION ALL
   SELECT 'C2023047', CENTROCOSTE, LEFT(CUENTA,2), DEBE, HABER, (DEBE-HABER)
     FROM C2023047.dbo.DIARIOAPUNTES
     WHERE YEAR(FECHA)=2026 AND LEFT(CUENTA,1) IN ('6','7') AND CENTROCOSTE LIKE 'KCH%'
 ) t
 GROUP BY db, CENTROCOSTE, grupo
 ORDER BY db, CENTROCOSTE, grupo
dbCENTROCOSTEgrupodebehabersaldon
C2023001KCH160376,37376,370,002
C2023001KCH360376,37376,370,002
C2023001KCH560417,17417,170,002
C2023001KCH660417,17417,170,002
C2023001KCH760396,17396,170,002
C2023001KCH860396,17396,170,002
C2023001KCH960417,17417,170,002
C2023001KCH996057,210,0057,212
C2023001KCHA60417,17417,170,002
C2023041KCH160219.262,721.146,26218.116,46657
C2023041KCH16210.640,47103,4110.537,06519
C2023041KCH16398,250,0098,254
C2023041KCH16446.633,760,0046.633,7620
C2023041KCH1701.228,83245.619,67-244.390,843622
C2023041KCH360246.004,05363,92245.640,13607
C2023041KCH36248.661,53114,9148.546,62531
C2023041KCH36398,250,0098,254
C2023041KCH36452.763,050,0052.763,0520
C2023041KCH3701.643,91286.457,34-284.813,433735
C2023041KCH560259.347,009.107,91250.239,09752
C2023041KCH56235.256,65109,4135.147,24513
C2023041KCH56398,250,0098,254
C2023041KCH56441.455,520,0041.455,5220
C2023041KCH570990,41279.397,33-278.406,923490
C2023041KCH660361.144,571.024,16360.120,41671
C2023041KCH66243.220,04104,4043.115,64528
C2023041KCH66398,250,0098,254
C2023041KCH66445.295,980,0045.295,9820
C2023041KCH67013.497,57425.221,22-411.723,655524
C2023041KCH760181.716,57660,30181.056,27555
C2023041KCH76260.915,85273,6360.642,22521
C2023041KCH76398,250,0098,254
C2023041KCH76448.426,770,0048.426,7720
C2023041KCH770754,89187.743,45-186.988,563433
C2023041KCH860241.609,58616,93240.992,65603
C2023041KCH86248.008,52202,4147.806,11510
C2023041KCH86398,250,0098,254
C2023041KCH86452.930,950,0052.930,9520
C2023041KCH8704.304,70275.838,36-271.533,663739
C2023041KCH960225.454,27738,04224.716,23648
C2023041KCH96253.225,8358,6053.167,23503
C2023041KCH96398,250,0098,254
C2023041KCH96442.685,140,0042.685,1420
C2023041KCH9702.938,98263.456,03-260.517,053749
C2023041KCH99608.414,32638,067.776,2612
C2023041KCH996299,600,0099,602
C2023041KCH99700,00232,09-232,095
C2023041KCHA60250.425,231.744,63248.680,60673
C2023041KCHA6211.524,6966,1311.458,56454
C2023041KCHA6398,250,0098,254
C2023041KCHA6444.710,950,0044.710,9520
C2023041KCHA702.892,01278.816,87-275.924,864471
C2023041KCHD6034,620,0034,621
C2023041KCHF623.369,660,003.369,6622
C2023041KCHF756.003,9771.652,80-65.648,8314
C2023041KCHG6222.345,09309,3922.035,7044
C2023041KCHH620,004.208,03-4.208,034
C2023041KCHH750,0027.815,26-27.815,2613

58 filas


Fin. Recuerda borrar diag_contab5.php al terminar.