=== 1. Lignes 6222 ===
SELECT f.ref,f.datef,f.type,f.fk_statut,s.nom,d.rowid,d.total_ht,d.tva_tx,d.total_tva,d.total_ttc,d.fk_code_ventilation,a.rowid AS acc_rowid,a.account_number,a.label,a.fk_pcg_version FROM llx_facture_fourn_det d JOIN llx_facture_fourn f ON f.rowid=d.fk_facture_fourn JOIN llx_societe s ON s.rowid=f.fk_soc JOIN llx_accounting_account a ON a.rowid=d.fk_code_ventilation WHERE a.account_number='6222' AND f.entity=1
ERREUR: Unknown column 'd.total_tva' in 'field list'

=== 2. Compte rowid 100107488 ===
SELECT rowid,fk_pcg_version,account_number,label,active,entity FROM llx_accounting_account WHERE rowid=100107488
  rowid=100107488 | fk_pcg_version=PCG18-ASSOC | account_number=6222 | label=Commissions et courtages sur ventes | active=1 | entity=1 | 
  (1 ligne(s))

=== 3. Lignes de SI2605-0208 ===
SELECT d.rowid,d.description,d.total_ht,d.total_ttc,d.tva_tx,d.fk_code_ventilation,a.account_number,a.label FROM llx_facture_fourn_det d JOIN llx_facture_fourn f ON f.rowid=d.fk_facture_fourn LEFT JOIN llx_accounting_account a ON a.rowid=d.fk_code_ventilation WHERE f.ref='SI2605-0208' AND f.entity=1
  rowid=787 | description=Honoraires de négociation sur location
Location SCI MARLEG / SAS TEKNI-PLI — Saint-André-sur-Orne (14320), Delle du Poirier
Facture DEVELOP'IMMO F-2026-215 du 11/05/2026, échéance 22/05/2026. | total_ht=5000.00000000 | total_ttc=6000.00000000 | tva_tx=20.0000 | fk_code_ventilation=100107488 | account_number=6222 | label=Commissions et courtages sur ventes | 
  (1 ligne(s))

=== 4. Entete SI2605-0208 ===
SELECT f.rowid,f.ref,f.ref_supplier,f.datef,f.date_lim_reglement,f.total_ht,f.total_tva,f.total_ttc,f.paye,f.fk_statut,f.type,f.note_public,s.nom,s.rowid AS socid FROM llx_facture_fourn f JOIN llx_societe s ON s.rowid=f.fk_soc WHERE f.ref='SI2605-0208' AND f.entity=1
  rowid=444 | ref=SI2605-0208 | ref_supplier=DEVELOPIMMO-BAIL-2026 | datef=2026-05-19 | date_lim_reglement=2026-05-19 | total_ht=5000.00000000 | total_tva=1000.00000000 | total_ttc=6000.00000000 | paye=1 | fk_statut=2 | type=0 | note_public= | nom=DEVELOPIMMO | socid=355 | 
  (1 ligne(s))

=== 5. Lignes client 7088 ===
SELECT f.ref,f.datef,s.nom,d.rowid,d.total_ht,d.description,a.account_number,a.label FROM llx_facturedet d JOIN llx_facture f ON f.rowid=d.fk_facture JOIN llx_societe s ON s.rowid=f.fk_soc LEFT JOIN llx_accounting_account a ON a.rowid=d.fk_code_ventilation WHERE f.ref IN ('FA2605-0335','FA2605-0341') AND f.entity=1
  ref=FA2605-0335 | datef=2026-05-27 | nom=Normandie Bois Koncept | rowid=1716 | total_ht=1540.00000000 | description=Quote-part honoraires de négociation — Agence DEVELOP'IMMO
Refacturation 30,80 %. | account_number=7088 | label=Autres produits d'activités annexes | 
  ref=FA2605-0341 | datef=2026-05-27 | nom=ARBRE DE FER | rowid=1723 | total_ht=615.00000000 | description=Quote-part honoraires de négociation — Agence DEVELOP'IMMO
Refacturation 12,30 %. | account_number=7088 | label=Autres produits d'activités annexes | 
  (2 ligne(s))

=== 6. Toutes lignes 7088 ===
SELECT f.ref,f.datef,s.nom,d.rowid,d.total_ht,LEFT(d.description,90) AS descr FROM llx_facturedet d JOIN llx_facture f ON f.rowid=d.fk_facture JOIN llx_societe s ON s.rowid=f.fk_soc JOIN llx_accounting_account a ON a.rowid=d.fk_code_ventilation WHERE a.account_number='7088' AND f.entity=1
  ref=FA2605-0334 | datef=2026-05-27 | nom=Normandie Bois Koncept | rowid=1715 | total_ht=462.00000000 | descr=Quote-part honoraires de rédaction d'acte de bail commercial (Me BUREL + Me GAUDRON)
Refac | 
  ref=FA2605-0335 | datef=2026-05-27 | nom=Normandie Bois Koncept | rowid=1716 | total_ht=1540.00000000 | descr=Quote-part honoraires de négociation — Agence DEVELOP'IMMO
Refacturation 30,80 %. | 
  ref=FA2605-0340 | datef=2026-05-27 | nom=ARBRE DE FER | rowid=1722 | total_ht=184.50000000 | descr=Quote-part honoraires de rédaction d'acte de bail commercial (Me BUREL + Me GAUDRON)
Refac | 
  ref=FA2605-0341 | datef=2026-05-27 | nom=ARBRE DE FER | rowid=1723 | total_ht=615.00000000 | descr=Quote-part honoraires de négociation — Agence DEVELOP'IMMO
Refacturation 12,30 %. | 
  (4 ligne(s))

=== 7. Bookkeeping 6222 ===
SELECT rowid,doc_ref,doc_date,numero_compte,label_compte,label_operation,debit,credit FROM llx_accounting_bookkeeping WHERE numero_compte LIKE '6222%' AND entity=1
  (0 ligne(s))

=== 8. Bookkeeping total ===
SELECT COUNT(*) AS nb, MIN(doc_date) AS mind, MAX(doc_date) AS maxd FROM llx_accounting_bookkeeping WHERE entity=1
  nb=0 | mind= | maxd= | 
  (1 ligne(s))

=== 9. Toutes factures DEVELOPIMMO ===
SELECT f.ref,f.ref_supplier,f.datef,f.total_ht,d.rowid,d.total_ht AS lht,LEFT(d.description,90) AS descr,a.account_number,a.label FROM llx_facture_fourn f JOIN llx_societe s ON s.rowid=f.fk_soc JOIN llx_facture_fourn_det d ON d.fk_facture_fourn=f.rowid LEFT JOIN llx_accounting_account a ON a.rowid=d.fk_code_ventilation WHERE s.nom LIKE '%DEVELOP%' AND f.entity=1
  ref=SI2605-0208 | ref_supplier=DEVELOPIMMO-BAIL-2026 | datef=2026-05-19 | total_ht=5000.00000000 | rowid=787 | lht=5000.00000000 | descr=Honoraires de négociation sur location
Location SCI MARLEG / SAS TEKNI-PLI — Saint-André-s | account_number=6222 | label=Commissions et courtages sur ventes | 
  (1 ligne(s))

=== 10. Comptes candidats ===
SELECT rowid,account_number,label,active FROM llx_accounting_account WHERE account_number IN ('6226','6132','613','6135','6222','6221','622') AND entity=1
  rowid=100107462 | account_number=613 | label=Locations | active=1 | 
  rowid=100105625 | account_number=613 | label=Locations | active=1 | 
  rowid=100108740 | account_number=613 | label=Locations | active=1 | 
  rowid=100107463 | account_number=6132 | label=Locations immobilières | active=1 | 
  rowid=100105626 | account_number=6132 | label=Locations immobilières | active=1 | 
  rowid=100108742 | account_number=6132 | label=Locations de matériel | active=1 | 
  rowid=100107464 | account_number=6135 | label=Locations mobilières | active=1 | 
  rowid=100105627 | account_number=6135 | label=Locations mobilières | active=1 | 
  rowid=100107486 | account_number=622 | label=Rémunérations d'intermédiaires et honoraires | active=1 | 
  rowid=100105653 | account_number=622 | label=Rémunérations d'intermédiaires et honoraires | active=1 | 
  rowid=100108781 | account_number=622 | label=Rémunérations d'intermédiaires et honoraires | active=1 | 
  rowid=100107487 | account_number=6221 | label=Commissions et courtages sur achats | active=1 | 
  rowid=100105654 | account_number=6221 | label=Commissions et courtages sur achats | active=1 | 
  rowid=100108782 | account_number=6221 | label=Commissions et courtages sur achats | active=1 | 
  rowid=100107488 | account_number=6222 | label=Commissions et courtages sur ventes | active=1 | 
  rowid=100105655 | account_number=6222 | label=Commissions et courtages sur ventes | active=1 | 
  rowid=100108783 | account_number=6222 | label=Commissions et courtages sur ventes | active=1 | 
  rowid=100107491 | account_number=6226 | label=Honoraires | active=1 | 
  rowid=100105658 | account_number=6226 | label=Honoraires | active=1 | 
  rowid=100108787 | account_number=6226 | label=Autres honoraires | active=1 | 
  (20 ligne(s))

=== 11. Comptes 62x utilises ===
SELECT a.account_number,a.label,COUNT(*) AS nb,SUM(d.total_ht) AS tot FROM llx_facture_fourn_det d JOIN llx_facture_fourn f ON f.rowid=d.fk_facture_fourn JOIN llx_accounting_account a ON a.rowid=d.fk_code_ventilation WHERE f.entity=1 AND a.account_number LIKE '62%' GROUP BY a.account_number,a.label ORDER BY a.account_number
  account_number=6222 | label=Commissions et courtages sur ventes | nb=1 | tot=5000.00000000 | 
  account_number=6226 | label=Honoraires | nb=10 | tot=4469.88000000 | 
  account_number=6227 | label=Frais d'actes et de contentieux | nb=1 | tot=1.24000000 | 
  account_number=6231 | label=Annonces et insertions | nb=1 | tot=109.00000000 | 
  account_number=624 | label=Transports de biens, d'usagers et transports collectifs du personnel | nb=4 | tot=31.67000000 | 
  account_number=6241 | label=Transport aux achats | nb=6 | tot=197.88000000 | 
  account_number=6251 | label=Voyages et déplacements | nb=1 | tot=49.31000000 | 
  account_number=6256 | label=Missions | nb=18 | tot=1047.09000000 | 
  account_number=626 | label=Frais postaux et frais de télécommunications | nb=2 | tot=17.91000000 | 
  (9 ligne(s))