=== A. Debits -2688 sur compte 1 === SELECT b.rowid, b.dateo, b.datev, b.amount, b.label, b.num_releve, b.rappro, b.fk_type, (SELECT GROUP_CONCAT(CONCAT(bu.type,':',bu.url_id)) FROM llx_bank_url bu WHERE bu.fk_bank=b.rowid) liens FROM llx_bank b WHERE b.fk_account=1 AND ROUND(b.amount,2)=-2688.00 ORDER BY b.dateo rowid=406 | dateo=2026-01-12 | datev=2026-01-12 | amount=-2688.00000000 | label=Règlement dette d'ouverture — Sellerie Thomas, pièce FA11/10 | num_releve=202601 | rappro=1 | fk_type=VIR | liens=payment_various:71 | rowid=200 | dateo=2026-04-10 | datev=2026-04-10 | amount=-2688.00000000 | label=(AgentCompta) VIREMENT EMIS VIR INST vers SARL THOMAS FA11/10 SELLERIE THOMAS F256444 TEKNIPLI | num_releve=202604 | rappro=1 | fk_type=VIR | liens=payment_supplier:86,company:235 | -> 2 ligne(s) === B. Tous mouvements |2688| === SELECT b.rowid,b.dateo,b.amount,b.label,b.num_releve,b.rappro FROM llx_bank b WHERE b.fk_account=1 AND ROUND(ABS(b.amount),2)=2688.00 ORDER BY b.dateo rowid=406 | dateo=2026-01-12 | amount=-2688.00000000 | label=Règlement dette d'ouverture — Sellerie Thomas, pièce FA11/10 | num_releve=202601 | rappro=1 | rowid=200 | dateo=2026-04-10 | amount=-2688.00000000 | label=(AgentCompta) VIREMENT EMIS VIR INST vers SARL THOMAS FA11/10 SELLERIE THOMAS F256444 TEKNIPLI | num_releve=202604 | rappro=1 | -> 2 ligne(s) === C. payment_various 71 === SELECT rowid,datep,datev,amount,sens,accountancy_code,subledger_account,label,fk_bank,fk_projet,entity FROM llx_payment_various WHERE rowid=71 rowid=71 | datep=2026-01-12 | datev=2026-01-12 | amount=2688.00000000 | sens=0 | accountancy_code=401 | subledger_account= | label=Règlement dette d'ouverture — Sellerie Thomas, pièce FA11/10 | fk_bank=406 | fk_projet=0 | entity=1 | -> 1 ligne(s) === D. payment_various label Sellerie/FA11 === SELECT rowid,datep,amount,sens,accountancy_code,subledger_account,label,fk_bank FROM llx_payment_various WHERE label LIKE '%ellerie%' OR label LIKE '%11/10%' OR label LIKE '%THOMAS%' rowid=71 | datep=2026-01-12 | amount=2688.00000000 | sens=0 | accountancy_code=401 | subledger_account= | label=Règlement dette d'ouverture — Sellerie Thomas, pièce FA11/10 | fk_bank=406 | -> 1 ligne(s) === E. paiementfourn 86 === SELECT p.rowid,p.ref,p.datep,p.amount,p.fk_bank,p.fk_paiement,p.num_paiement,p.note FROM llx_paiementfourn p WHERE p.rowid=86 rowid=86 | ref=SPAY2601-0041 | datep=2026-04-10 00:00:00 | amount=2688.00000000 | fk_bank=200 | fk_paiement=2 | num_paiement=8059912740176 | note=AgentCompta — rapprochement fournisseurs du 2026-08-09 — match #712 Libelle : VIREMENT EMIS VIR INST vers SARL THOMAS FA11/10 SELLERIE THOMAS F256444 TEKNIPLI | -> 1 ligne(s) === E2. ventilation paiement 86 === SELECT p.rowid,p.ref,p.datep,p.amount tot,ff.rowid f_id,ff.ref,ff.ref_supplier,ff.datef,ff.total_ttc,ff.paye,ff.fk_statut,ff.fk_soc,pf.amount imput FROM llx_paiementfourn p JOIN llx_paiementfourn_facturefourn pf ON pf.fk_paiementfourn=p.rowid JOIN llx_facture_fourn ff ON ff.rowid=pf.fk_facturefourn WHERE p.rowid=86 rowid=86 | ref=SI2603-0104 | datep=2026-04-10 00:00:00 | tot=2688.00000000 | f_id=244 | ref_supplier=03/17 | datef=2026-03-01 | total_ttc=1344.00000000 | paye=1 | fk_statut=2 | fk_soc=235 | imput=1344.00000000 | rowid=86 | ref=SI2603-0105 | datep=2026-04-10 00:00:00 | tot=2688.00000000 | f_id=245 | ref_supplier=03/18 | datef=2026-03-10 | total_ttc=1344.00000000 | paye=1 | fk_statut=2 | fk_soc=235 | imput=1344.00000000 | -> 2 ligne(s) === F. ref_supplier 11/10 12/06 11/13 === SELECT rowid,ref,ref_supplier,datef,total_ttc,fk_soc FROM llx_facture_fourn WHERE ref_supplier IN ('11/10','12/06','11/13') (0 ligne) -> 0 ligne(s) === F2. ref_supplier LIKE 11/10 === SELECT rowid,ref,ref_supplier,datef,total_ttc,fk_soc FROM llx_facture_fourn WHERE ref_supplier LIKE '%11/10%' OR ref_supplier LIKE '%11%10%' (0 ligne) -> 0 ligne(s) === G. societe 235 === SELECT rowid,nom,code_fournisseur,code_client,status FROM llx_societe WHERE rowid=235 rowid=235 | nom=Sellerie Thomas | code_fournisseur=SU2507-00003 | code_client=CU2609-00103 | status=1 | -> 1 ligne(s) === H. factures fourn soc 235 === SELECT rowid,ref,ref_supplier,datef,date_lim_reglement,total_ht,total_ttc,paye,fk_statut FROM llx_facture_fourn WHERE fk_soc=235 ORDER BY datef rowid=243 | ref=SI2602-0103 | ref_supplier=02/13 | datef=2026-02-09 | date_lim_reglement=2026-03-09 | total_ht=1210.00000000 | total_ttc=1452.00000000 | paye=1 | fk_statut=2 | rowid=244 | ref=SI2603-0104 | ref_supplier=03/17 | datef=2026-03-01 | date_lim_reglement=2026-03-25 | total_ht=1120.00000000 | total_ttc=1344.00000000 | paye=1 | fk_statut=2 | rowid=245 | ref=SI2603-0105 | ref_supplier=03/18 | datef=2026-03-10 | date_lim_reglement=2026-03-25 | total_ht=1120.00000000 | total_ttc=1344.00000000 | paye=1 | fk_statut=2 | rowid=246 | ref=SI2606-0106 | ref_supplier=06/28 | datef=2026-06-16 | date_lim_reglement=2026-07-17 | total_ht=960.00000000 | total_ttc=1152.00000000 | paye=1 | fk_statut=2 | rowid=247 | ref=SI2606-0107 | ref_supplier=06/27 | datef=2026-06-30 | date_lim_reglement=2026-07-30 | total_ht=1075.00000000 | total_ttc=1290.00000000 | paye=1 | fk_statut=2 | rowid=509 | ref=SI2609-0272 | ref_supplier=F267303 | datef=2026-09-09 | date_lim_reglement=2026-10-09 | total_ht=279.00000000 | total_ttc=334.80000000 | paye=0 | fk_statut=1 | rowid=538 | ref=SI2610-0301 | ref_supplier=F267440 | datef=2026-10-20 | date_lim_reglement=2026-11-20 | total_ht=1782.00000000 | total_ttc=2138.40000000 | paye=0 | fk_statut=1 | -> 7 ligne(s) === I. lignes bank liees soc 235 === SELECT b.rowid,b.dateo,b.amount,b.label,b.num_releve,bu.type,bu.url_id,bu.label lbl FROM llx_bank b JOIN llx_bank_url bu ON bu.fk_bank=b.rowid WHERE bu.type='company' AND bu.url_id=235 ORDER BY b.dateo rowid=183 | dateo=2026-03-17 | amount=-1452.00000000 | label=(AgentCompta) VIREMENT EMIS VIR INST vers SARL THOMAS FA02/13 SELLERIE THOMAS F266642 TEKNIPLI | num_releve=202603 | type=company | url_id=235 | lbl=Sellerie Thomas | rowid=200 | dateo=2026-04-10 | amount=-2688.00000000 | label=(AgentCompta) VIREMENT EMIS VIR INST vers SARL THOMAS FA11/10 SELLERIE THOMAS F256444 TEKNIPLI | num_releve=202604 | type=company | url_id=235 | lbl=Sellerie Thomas | rowid=199 | dateo=2026-07-20 | amount=-1152.00000000 | label=(AgentCompta) VIREMENT EMIS VIR INST vers SARL THOMAS FA06/28 SELLERIE THOMAS F267047 TEKNIPLI | num_releve=202607 | type=company | url_id=235 | lbl=Sellerie Thomas | rowid=160 | dateo=2026-08-03 | amount=-1290.00000000 | label=(AgentCompta) VIREMENT EMIS VIR INST vers SARL THOMAS FA06/27 SELLERIE THOMAS F267110 TEKNIPLI | num_releve=202608 | type=company | url_id=235 | lbl=Sellerie Thomas | -> 4 ligne(s) === J. bank label THOMAS/Sellerie === SELECT b.rowid,b.dateo,b.amount,b.label,b.num_releve,b.rappro FROM llx_bank b WHERE b.fk_account=1 AND (b.label LIKE '%THOMAS%' OR b.label LIKE '%ellerie%') ORDER BY b.dateo rowid=406 | dateo=2026-01-12 | amount=-2688.00000000 | label=Règlement dette d'ouverture — Sellerie Thomas, pièce FA11/10 | num_releve=202601 | rappro=1 | rowid=183 | dateo=2026-03-17 | amount=-1452.00000000 | label=(AgentCompta) VIREMENT EMIS VIR INST vers SARL THOMAS FA02/13 SELLERIE THOMAS F266642 TEKNIPLI | num_releve=202603 | rappro=1 | rowid=200 | dateo=2026-04-10 | amount=-2688.00000000 | label=(AgentCompta) VIREMENT EMIS VIR INST vers SARL THOMAS FA11/10 SELLERIE THOMAS F256444 TEKNIPLI | num_releve=202604 | rappro=1 | rowid=199 | dateo=2026-07-20 | amount=-1152.00000000 | label=(AgentCompta) VIREMENT EMIS VIR INST vers SARL THOMAS FA06/28 SELLERIE THOMAS F267047 TEKNIPLI | num_releve=202607 | rappro=1 | rowid=160 | dateo=2026-08-03 | amount=-1290.00000000 | label=(AgentCompta) VIREMENT EMIS VIR INST vers SARL THOMAS FA06/27 SELLERIE THOMAS F267110 TEKNIPLI | num_releve=202608 | rappro=1 | -> 5 ligne(s)