=== 1. Requete auditeur : fk_account=2 par rappro === SELECT fk_account, rappro, COUNT(*) AS n, ROUND(SUM(amount),2) AS solde, MIN(dateo) AS mind, MAX(dateo) AS maxd FROM llx_bank WHERE fk_account=2 GROUP BY fk_account, rappro fk_account=2 | rappro=0 | n=44 | solde=119828.66 | mind=2025-01-01 | maxd=2025-12-31 === 2. Tous comptes x rappro === SELECT b.fk_account, ba.ref, ba.label, ba.clos, b.rappro, COUNT(*) AS n, ROUND(SUM(b.amount),2) AS somme, MIN(b.dateo) AS mind, MAX(b.dateo) AS maxd FROM llx_bank b LEFT JOIN llx_bank_account ba ON ba.rowid=b.fk_account GROUP BY b.fk_account, ba.ref, ba.label, ba.clos, b.rappro ORDER BY b.fk_account, b.rappro fk_account=1 | ref=Tekni-pli | label=Compte Courant | clos=0 | rappro=0 | n=4 | somme=2737.02 | mind=2026-01-16 | maxd=2026-06-26 fk_account=1 | ref=Tekni-pli | label=Compte Courant | clos=0 | rappro=1 | n=425 | somme=13296.88 | mind=2025-12-31 | maxd=2026-10-17 fk_account=2 | ref=HIST25 | label=Historique 2025 (exercice clos) — ne pas utiliser | clos=1 | rappro=0 | n=44 | somme=119828.66 | mind=2025-01-01 | maxd=2025-12-31 === 3. Comptes bancaires === SELECT rowid, ref, label, bank, clos, courant, entity, date_creation FROM llx_bank_account ORDER BY rowid ERREUR SQL: Unknown column 'date_creation' in 'field list' === 4. num_releve / rappro sur compte 2 === SELECT COUNT(*) AS n_total, SUM(CASE WHEN num_releve IS NULL OR num_releve='' THEN 1 ELSE 0 END) AS n_sans_releve, SUM(CASE WHEN num_releve IS NOT NULL AND num_releve<>'' THEN 1 ELSE 0 END) AS n_avec_releve, SUM(CASE WHEN rappro=1 THEN 1 ELSE 0 END) AS n_rappro1 FROM llx_bank WHERE fk_account=2 n_total=44 | n_sans_releve=44 | n_avec_releve=0 | n_rappro1=0 === 5. Lignes compte 2 en 2026 (dateo) === SELECT COUNT(*) AS n FROM llx_bank WHERE fk_account=2 AND dateo>='2026-01-01' n=0 === 5b. Lignes compte 2 en 2026 (datev) === SELECT COUNT(*) AS n FROM llx_bank WHERE fk_account=2 AND datev>='2026-01-01' n=0 === 6. Total tous comptes === SELECT ROUND(SUM(amount),2) AS total_tous_comptes FROM llx_bank total_tous_comptes=135862.56 === 6b. Solde par compte === SELECT b.fk_account, ROUND(SUM(b.amount),2) AS solde, COUNT(*) AS n FROM llx_bank b GROUP BY b.fk_account fk_account=1 | solde=16033.9 | n=429 fk_account=2 | solde=119828.66 | n=44 === 7. Paiements clients sur compte 2 === SELECT COUNT(DISTINCT p.rowid) AS n_paiements, MIN(p.rowid) AS min_rowid, MAX(p.rowid) AS max_rowid, ROUND(SUM(p.amount),2) AS montant, MIN(p.datep) AS mind, MAX(p.datep) AS maxd FROM llx_paiement p INNER JOIN llx_bank b ON b.rowid=p.fk_bank WHERE b.fk_account=2 n_paiements=42 | min_rowid=1 | max_rowid=43 | montant=116037.83 | mind=2025-05-17 12:00:00 | maxd=2025-12-31 12:00:00 === 8. Detail des lignes compte 2 === SELECT rowid, dateo, datev, ROUND(amount,2) AS montant, label, num_releve, rappro, fk_type FROM llx_bank WHERE fk_account=2 ORDER BY dateo, rowid rowid=401 | dateo=2025-01-01 | datev=2025-01-01 | montant=0 | label=(InitialBankBalance) | num_releve=NULL | rappro=0 | fk_type=SOLD rowid=15 | dateo=2025-05-17 | datev=2025-05-17 | montant=59.04 | label=(CustomerInvoicePayment) | num_releve=NULL | rappro=0 | fk_type=CHQ rowid=16 | dateo=2025-07-08 | datev=2025-07-08 | montant=438 | label=(CustomerInvoicePayment) | num_releve=NULL | rappro=0 | fk_type=VIR rowid=3 | dateo=2025-07-22 | datev=2025-07-22 | montant=5344.17 | label=(CustomerInvoicePayment) | num_releve=NULL | rappro=0 | fk_type=VIR rowid=5 | dateo=2025-07-25 | datev=2025-07-25 | montant=10333.87 | label=(CustomerInvoicePayment) | num_releve=NULL | rappro=0 | fk_type=VIR rowid=4 | dateo=2025-08-21 | datev=2025-08-21 | montant=478.8 | label=(CustomerInvoicePayment) | num_releve=NULL | rappro=0 | fk_type=VIR rowid=1 | dateo=2025-09-06 | datev=2025-09-06 | montant=3790.83 | label=(Solde initial) | num_releve=NULL | rappro=0 | fk_type=SOLD rowid=2 | dateo=2025-09-09 | datev=2025-09-09 | montant=4085.45 | label=(CustomerInvoicePayment) | num_releve=NULL | rappro=0 | fk_type=VIR rowid=6 | dateo=2025-09-17 | datev=2025-09-17 | montant=2740.47 | label=(CustomerInvoicePayment) | num_releve=NULL | rappro=0 | fk_type=VIR rowid=7 | dateo=2025-09-17 | datev=2025-09-17 | montant=4899.73 | label=(CustomerInvoicePayment) | num_releve=NULL | rappro=0 | fk_type=VIR rowid=8 | dateo=2025-09-19 | datev=2025-09-19 | montant=5476.03 | label=(CustomerInvoicePayment) | num_releve=NULL | rappro=0 | fk_type=VIR rowid=11 | dateo=2025-09-22 | datev=2025-09-22 | montant=77.23 | label=(CustomerInvoicePayment) | num_releve=NULL | rappro=0 | fk_type=VIR rowid=9 | dateo=2025-09-23 | datev=2025-09-23 | montant=452.74 | label=(CustomerInvoicePayment) | num_releve=NULL | rappro=0 | fk_type=VIR rowid=12 | dateo=2025-09-24 | datev=2025-09-24 | montant=2954.39 | label=(CustomerInvoicePayment) | num_releve=NULL | rappro=0 | fk_type=VIR rowid=10 | dateo=2025-09-28 | datev=2025-09-28 | montant=360 | label=(CustomerInvoicePayment) | num_releve=NULL | rappro=0 | fk_type=VIR rowid=13 | dateo=2025-10-04 | datev=2025-10-04 | montant=5958.77 | label=(CustomerInvoicePayment) | num_releve=NULL | rappro=0 | fk_type=VIR rowid=14 | dateo=2025-10-07 | datev=2025-10-07 | montant=1761.17 | label=(CustomerInvoicePayment) | num_releve=NULL | rappro=0 | fk_type=VIR rowid=17 | dateo=2025-10-09 | datev=2025-10-09 | montant=3702.96 | label=(CustomerInvoicePayment) | num_releve=NULL | rappro=0 | fk_type=VIR rowid=18 | dateo=2025-10-14 | datev=2025-10-14 | montant=684.35 | label=(CustomerInvoicePayment) | num_releve=NULL | rappro=0 | fk_type=VIR rowid=19 | dateo=2025-10-14 | datev=2025-10-14 | montant=21.91 | label=(CustomerInvoicePayment) | num_releve=NULL | rappro=0 | fk_type=VIR rowid=20 | dateo=2025-10-14 | datev=2025-10-14 | montant=456.42 | label=(CustomerInvoicePayment) | num_releve=NULL | rappro=0 | fk_type=VIR rowid=21 | dateo=2025-10-21 | datev=2025-10-21 | montant=2223.85 | label=(CustomerInvoicePayment) | num_releve=NULL | rappro=0 | fk_type=VIR rowid=22 | dateo=2025-10-23 | datev=2025-10-23 | montant=960 | label=(CustomerInvoicePayment) | num_releve=NULL | rappro=0 | fk_type=VIR rowid=23 | dateo=2025-10-23 | datev=2025-10-23 | montant=2775.5 | label=(CustomerInvoicePayment) | num_releve=NULL | rappro=0 | fk_type=VIR rowid=24 | dateo=2025-10-23 | datev=2025-10-23 | montant=8884.06 | label=(CustomerInvoicePayment) | num_releve=NULL | rappro=0 | fk_type=VIR rowid=25 | dateo=2025-11-04 | datev=2025-11-04 | montant=3600 | label=(CustomerInvoicePayment) | num_releve=NULL | rappro=0 | fk_type=VIR rowid=32 | dateo=2025-11-06 | datev=2025-11-06 | montant=24 | label=(CustomerInvoicePayment) | num_releve=NULL | rappro=0 | fk_type=VIR rowid=29 | dateo=2025-11-13 | datev=2025-11-13 | montant=391.2 | label=(CustomerInvoicePayment) | num_releve=NULL | rappro=0 | fk_type=VIR rowid=31 | dateo=2025-11-20 | datev=2025-11-20 | montant=432 | label=(CustomerInvoicePayment) | num_releve=NULL | rappro=0 | fk_type=VIR rowid=28 | dateo=2025-11-24 | datev=2025-11-24 | montant=149.34 | label=(CustomerInvoicePayment) | num_releve=NULL | rappro=0 | fk_type=VIR rowid=27 | dateo=2025-11-27 | datev=2025-11-27 | montant=710.64 | label=(CustomerInvoicePayment) | num_releve=NULL | rappro=0 | fk_type=VIR rowid=26 | dateo=2025-12-05 | datev=2025-12-05 | montant=10082.97 | label=(CustomerInvoicePayment) | num_releve=NULL | rappro=0 | fk_type=VIR rowid=33 | dateo=2025-12-05 | datev=2025-12-05 | montant=2725.9 | label=(CustomerInvoicePayment) | num_releve=NULL | rappro=0 | fk_type=VIR rowid=40 | dateo=2025-12-11 | datev=2025-12-11 | montant=4934.76 | label=(CustomerInvoicePayment) | num_releve=NULL | rappro=0 | fk_type=VIR rowid=34 | dateo=2025-12-23 | datev=2025-12-23 | montant=208.51 | label=(CustomerInvoicePayment) | num_releve=NULL | rappro=0 | fk_type=VIR rowid=36 | dateo=2025-12-23 | datev=2025-12-23 | montant=720 | label=(CustomerInvoicePayment) | num_releve=NULL | rappro=0 | fk_type=VIR rowid=37 | dateo=2025-12-23 | datev=2025-12-23 | montant=7282.93 | label=(CustomerInvoicePayment) | num_releve=NULL | rappro=0 | fk_type=VIR rowid=35 | dateo=2025-12-29 | datev=2025-12-29 | montant=204.1 | label=(CustomerInvoicePayment) | num_releve=NULL | rappro=0 | fk_type=VIR rowid=38 | dateo=2025-12-29 | datev=2025-12-29 | montant=1288.09 | label=(CustomerInvoicePayment) | num_releve=NULL | rappro=0 | fk_type=VIR rowid=39 | dateo=2025-12-29 | datev=2025-12-29 | montant=1369.58 | label=(CustomerInvoicePayment) | num_releve=NULL | rappro=0 | fk_type=VIR rowid=41 | dateo=2025-12-30 | datev=2025-12-30 | montant=5272.56 | label=(CustomerInvoicePayment) | num_releve=NULL | rappro=0 | fk_type=VIR rowid=44 | dateo=2025-12-30 | datev=2025-12-30 | montant=92.22 | label=(CustomerInvoicePayment) | num_releve=NULL | rappro=0 | fk_type=VIR rowid=42 | dateo=2025-12-31 | datev=2025-12-31 | montant=137.6 | label=(CustomerInvoicePayment) | num_releve=NULL | rappro=0 | fk_type=CB rowid=43 | dateo=2025-12-31 | datev=2025-12-31 | montant=11282.52 | label=(CustomerInvoicePayment) | num_releve=NULL | rappro=0 | fk_type=VIR