compte bancaire du module : #1 SQL: Unknown column 'solde' in 'field list' tous les comptes de l'entite : #1 Tekni-pli Compte Courant courant=1 clos=0 rappro=1 #2 HIST25 Historique 2025 (exercice cl courant=0 clos=1 rappro=1 === 1. PAIEMENTS FOURNISSEUR === statut=1 : 159 paiements 205103.76 EUR dont 0 SANS ligne de banque === 2. LIGNES DE BANQUE (llx_bank) === total : 350 lignes 29195.51 EUR du 2025-12-31 au 2026-08-07 exercice 2026 : 349 lignes -7805.74 EUR dont debits : 258 lignes -236876.72 EUR (le releve CA en a 258 pour -237 245,72) dont credits : 91 lignes 229070.98 EUR (le releve CA en a 96 pour 229 765,87) === 2b. RAPPROCHEMENT BANCAIRE DOLIBARR (colonne rappro / num_releve) === rappro=1 : 343 lignes -10805.47 EUR rappro=0 : 6 lignes 2999.73 EUR sans numero de releve : 6 === 3. LIENS bank_url (ce qui rend le paiement cliquable depuis la banque) === payment 79 company 246 payment_supplier 159 loan 8 payment_loan 8 payment_various 103 paiements fourn. SANS lien bank_url : 0 paiements fourn. SANS lien tiers : 0 (le nom du fournisseur n'apparait pas en banque) === 4. DRAPEAU 'paye' DES FACTURES FOURNISSEUR === fk_statut=1 paye=0 : 17 factures 30309.53 EUR fk_statut=2 paye=1 : 178 factures 205103.78 EUR incoherences : reglee a 100%% mais paye=0, ou paye=1 mais reste du SI2606-0143 06/13 ttc -13.20 regle 0.00 paye=0 statut=1 -> 1 facture(s) incoherente(s) === 5. TABLE DU MODULE (agentcompta_match) CONTRE LA BANQUE DOLIBARR === lignes du module (hors rejetees) : 351 -9015.85 EUR ABSENTES de llx_bank (jour + montant) : 40 lignes de banque HORS module : 37 === 6. LES 18 DERNIERS PAIEMENTS, BOUT PAR BOUT === #98 2026-08-03 00:00:00 3240.00 st=1 | bank#212 -3240.00 cpt=1 rappro=1 rel=202608 liens=2 | SI2608-0088 #99 2026-07-20 00:00:00 330.00 st=1 | bank#213 -330.00 cpt=1 rappro=1 rel=202607 liens=2 | SI2607-0080 #101 2026-07-03 00:00:00 4800.00 st=1 | bank#215 -4800.00 cpt=1 rappro=1 rel=202607 liens=2 | SI2607-0102 #102 2026-07-01 00:00:00 2565.00 st=1 | bank#216 -2565.00 cpt=1 rappro=1 rel=202607 liens=2 | SI2606-0087 #103 2026-06-26 00:00:00 6000.00 st=1 | bank#217 -6000.00 cpt=1 rappro=1 rel=202606 liens=2 | SI2606-0077 #104 2026-06-22 00:00:00 3807.98 st=1 | bank#218 -3807.98 cpt=1 rappro=1 rel=202606 liens=2 | SI2604-0193 #105 2026-06-17 00:00:00 198.00 st=1 | bank#219 -198.00 cpt=1 rappro=1 rel=202606 liens=2 | SI2606-0075 #106 2026-06-17 00:00:00 1558.49 st=1 | bank#220 -1558.49 cpt=1 rappro=1 rel=202606 liens=2 | SI2605-0070 #107 2026-06-04 00:00:00 4800.00 st=1 | bank#221 -4800.00 cpt=1 rappro=1 rel=202606 liens=2 | SI2605-0100 #108 2026-05-12 00:00:00 2295.00 st=1 | bank#222 -2295.00 cpt=1 rappro=1 rel=202605 liens=2 | SI2605-0084 #109 2026-04-09 00:00:00 1308.00 st=1 | bank#223 -1308.00 cpt=1 rappro=1 rel=202604 liens=2 | SI2603-0096 #110 2026-03-05 00:00:00 1500.00 st=1 | bank#224 -1500.00 cpt=1 rappro=1 rel=202603 liens=2 | SI2603-0057 #111 2026-03-03 00:00:00 1308.00 st=1 | bank#225 -1308.00 cpt=1 rappro=1 rel=202603 liens=2 | SI2602-0095 #112 2026-03-03 00:00:00 120.60 st=1 | bank#226 -120.60 cpt=1 rappro=1 rel=202603 liens=2 | SI2602-0093 #113 2026-02-10 00:00:00 114.00 st=1 | bank#227 -114.00 cpt=1 rappro=1 rel=202602 liens=2 | SI2601-0092 #114 2026-01-09 00:00:00 1308.00 st=1 | bank#228 -1308.00 cpt=1 rappro=1 rel=202601 liens=2 | SI2601-0094 #115 2026-06-15 00:00:00 3620.16 st=1 | bank#229 -3620.16 cpt=1 rappro=1 rel=202606 liens=2 | SI2604-0028 #116 2026-01-05 00:00:00 369.00 st=1 | bank#230 -369.00 cpt=1 rappro=1 rel=202601 liens=2 | SI2601-0108 #117 2026-01-06 00:00:00 90.00 st=1 | bank#231 -90.00 cpt=1 rappro=1 rel=202601 liens=2 | SI2601-0115 #118 2026-01-14 00:00:00 16.75 st=1 | bank#232 -16.75 cpt=1 rappro=1 rel=202601 liens=2 | SI2601-0056 #119 2026-02-05 00:00:00 369.00 st=1 | bank#233 -369.00 cpt=1 rappro=1 rel=202602 liens=2 | SI2602-0109 #120 2026-02-16 00:00:00 1799.66 st=1 | bank#234 -1799.66 cpt=1 rappro=1 rel=202602 liens=2 | SI2602-0139 #121 2026-03-05 00:00:00 287.76 st=1 | bank#235 -287.76 cpt=1 rappro=1 rel=202603 liens=2 | SI2603-0131 #122 2026-03-05 00:00:00 369.00 st=1 | bank#236 -369.00 cpt=1 rappro=1 rel=202603 liens=2 | SI2603-0110 #123 2026-03-09 00:00:00 1806.72 st=1 | bank#237 -1806.72 cpt=1 rappro=1 rel=202603 liens=2 | SI2603-0059 #124 2026-03-09 00:00:00 7.17 st=1 | bank#238 -7.17 cpt=1 rappro=1 rel=202603 liens=2 | SI2603-0058 #125 2026-03-16 00:00:00 1081.20 st=1 | bank#239 -1081.20 cpt=1 rappro=1 rel=202603 liens=2 | SI2603-0140 #126 2026-03-16 00:00:00 299.00 st=1 | bank#240 -299.00 cpt=1 rappro=1 rel=202603 liens=2 | SI2603-0189 #127 2026-03-19 00:00:00 920.70 st=1 | bank#241 -920.70 cpt=1 rappro=1 rel=202603 liens=2 | SI2603-0061 #128 2026-03-19 00:00:00 22.39 st=1 | bank#242 -22.39 cpt=1 rappro=1 rel=202603 liens=2 | SI2603-0144 #129 2026-03-20 00:00:00 90.00 st=1 | bank#243 -90.00 cpt=1 rappro=1 rel=202603 liens=2 | SI2603-0116 #130 2026-03-20 00:00:00 425.70 st=1 | bank#244 -425.70 cpt=1 rappro=1 rel=202603 liens=2 | SI2603-0192 #131 2026-03-25 00:00:00 404.79 st=1 | bank#245 -404.79 cpt=1 rappro=1 rel=202603 liens=2 | SI2603-0062 #132 2026-03-31 00:00:00 3343.00 st=1 | bank#246 -3343.00 cpt=1 rappro=1 rel=202603 liens=2 | SI2603-0060 #133 2026-04-02 00:00:00 149.86 st=1 | bank#247 -149.86 cpt=1 rappro=1 rel=202604 liens=2 | SI2604-0157 #134 2026-04-07 00:00:00 369.00 st=1 | bank#248 -369.00 cpt=1 rappro=1 rel=202604 liens=2 | SI2604-0111 #135 2026-04-09 00:00:00 36.19 st=1 | bank#249 -36.19 cpt=1 rappro=1 rel=202604 liens=2 | SI2604-0145 #136 2026-04-14 00:00:00 246.19 st=1 | bank#250 -246.19 cpt=1 rappro=1 rel=202604 liens=2 | SI2604-0063 #137 2026-04-27 00:00:00 53.41 st=1 | bank#251 -53.41 cpt=1 rappro=1 rel=202604 liens=2 | SI2604-0064 #138 2026-05-04 00:00:00 78.56 st=1 | bank#252 -78.56 cpt=1 rappro=1 rel=202605 liens=2 | SI2605-0068 #139 2026-05-04 00:00:00 1270.75 st=1 | bank#253 -1270.75 cpt=1 rappro=1 rel=202605 liens=2 | SI2605-0067 #140 2026-05-04 00:00:00 15.82 st=1 | bank#254 -15.82 cpt=1 rappro=1 rel=202605 liens=2 | SI2605-0045 #141 2026-05-05 00:00:00 369.00 st=1 | bank#255 -369.00 cpt=1 rappro=1 rel=202605 liens=2 | SI2605-0112 #142 2026-05-11 00:00:00 12.98 st=1 | bank#256 -12.98 cpt=1 rappro=1 rel=202605 liens=2 | SI2604-0133 #143 2026-05-11 00:00:00 21.06 st=1 | bank#257 -21.06 cpt=1 rappro=1 rel=202605 liens=2 | SI2605-0069 #144 2026-05-13 00:00:00 980.10 st=1 | bank#258 -980.10 cpt=1 rappro=1 rel=202605 liens=2 | SI2605-0141 #145 2026-05-22 00:00:00 295.97 st=1 | bank#259 -295.97 cpt=1 rappro=1 rel=202605 liens=2 | SI2605-0073 #146 2026-05-26 00:00:00 33.29 st=1 | bank#260 -33.29 cpt=1 rappro=1 rel=202605 liens=2 | SI2605-0071 #147 2026-06-05 00:00:00 369.00 st=1 | bank#261 -369.00 cpt=1 rappro=1 rel=202606 liens=2 | SI2606-0113 #148 2026-06-08 00:00:00 109.44 st=1 | bank#262 -109.44 cpt=1 rappro=1 rel=202606 liens=2 | SI2605-0134 #149 2026-06-08 00:00:00 99.90 st=1 | bank#263 -99.90 cpt=1 rappro=1 rel=202606 liens=2 | SI2606-0074 #150 2026-06-08 00:00:00 31.19 st=1 | bank#264 -31.19 cpt=1 rappro=1 rel=202606 liens=2 | SI2606-0146 #151 2026-06-11 00:00:00 36.19 st=1 | bank#265 -36.19 cpt=1 rappro=1 rel=202606 liens=2 | SI2606-0147 #152 2026-06-17 00:00:00 313.51 st=1 | bank#266 -313.51 cpt=1 rappro=1 rel=202606 liens=2 | SI2606-0081 #153 2026-06-17 00:00:00 3210.12 st=1 | bank#267 -3210.12 cpt=1 rappro=1 rel=202606 liens=2 | SI2606-0076 #154 2026-06-30 00:00:00 339.23 st=1 | bank#268 -339.23 cpt=1 rappro=1 rel=202606 liens=2 | SI2606-0123 #155 2026-06-30 00:00:00 15.00 st=1 | bank#269 -15.00 cpt=1 rappro=1 rel=202606 liens=2 | SI2606-0122 #156 2026-07-08 00:00:00 127.99 st=1 | bank#270 -127.99 cpt=1 rappro=1 rel=202607 liens=2 | SI2606-0135 #157 2026-07-10 00:00:00 41.26 st=1 | bank#271 -41.26 cpt=1 rappro=1 rel=202607 liens=2 | SI2607-0078 #158 2026-07-15 00:00:00 112.32 st=1 | bank#272 -112.32 cpt=1 rappro=1 rel=202607 liens=2 | SI2607-0158 #159 2026-07-23 00:00:00 15.82 st=1 | bank#273 -15.82 cpt=1 rappro=1 rel=202607 liens=2 | SI2607-0047 #160 2026-07-27 00:00:00 21.49 st=1 | bank#274 -21.49 cpt=1 rappro=1 rel=202607 liens=2 | SI2607-0003 #161 2026-07-30 00:00:00 130.80 st=1 | bank#275 -130.80 cpt=1 rappro=1 rel=202607 liens=2 | SI2607-0082 #163 2026-08-07 00:00:00 140.33 st=1 | bank#277 -140.33 cpt=1 rappro=1 rel=202608 liens=2 | SI2607-0160 #164 2026-01-19 00:00:00 1768.14 st=1 | bank#302 -1768.14 cpt=1 rappro=1 rel=202601 liens=2 | SI2601-0200 #165 2026-02-19 00:00:00 1768.14 st=1 | bank#303 -1768.14 cpt=1 rappro=1 rel=202602 liens=2 | SI2602-0201 #166 2026-03-19 00:00:00 1768.14 st=1 | bank#304 -1768.14 cpt=1 rappro=1 rel=202603 liens=2 | SI2603-0202 #167 2026-04-20 00:00:00 1768.14 st=1 | bank#305 -1768.14 cpt=1 rappro=1 rel=202604 liens=2 | SI2604-0203 #168 2026-05-19 00:00:00 1768.14 st=1 | bank#306 -1768.14 cpt=1 rappro=1 rel=202605 liens=2 | SI2605-0204 #169 2026-06-19 00:00:00 1768.14 st=1 | bank#307 -1768.14 cpt=1 rappro=1 rel=202606 liens=2 | SI2606-0205 #170 2026-07-20 00:00:00 1768.14 st=1 | bank#308 -1768.14 cpt=1 rappro=1 rel=202607 liens=2 | SI2607-0206 #171 2026-05-19 00:00:00 17812.90 st=1 | bank#318 -17812.90 cpt=1 rappro=1 rel=202605 liens=4 | SI2605-0098,SI2605-0099,SI2605-0207,SI2605-0208 #172 2026-02-10 00:00:00 96.00 st=1 | bank#365 -96.00 cpt=1 rappro=1 rel=202602 liens=2 | SI2601-0163 #173 2026-07-06 00:00:00 839.86 st=1 | bank#366 -839.86 cpt=1 rappro=1 rel=202607 liens=2 | SI2606-0114,SI2607-0127 #174 2026-04-29 00:00:00 293.31 st=1 | bank#367 -293.31 cpt=1 rappro=1 rel=202604 liens=2 | SI2604-0066 #175 2026-05-22 00:00:00 231.52 st=1 | bank#368 -231.52 cpt=1 rappro=1 rel=202605 liens=2 | SI2605-0072 #176 2026-04-08 00:00:00 35.00 st=1 | bank#369 -35.00 cpt=1 rappro=1 rel=202604 liens=2 | SI2604-0209 #177 2026-02-06 00:00:00 31.00 st=1 | bank#371 -31.00 cpt=1 rappro=1 rel=202602 liens=2 | SI2602-0211 #178 2026-02-11 00:00:00 56.05 st=1 | bank#372 -56.05 cpt=1 rappro=1 rel=202602 liens=2 | SI2602-0212 #179 2026-02-12 00:00:00 48.88 st=1 | bank#373 -48.88 cpt=1 rappro=1 rel=202602 liens=2 | SI2602-0213 #180 2026-02-23 00:00:00 100.00 st=1 | bank#374 -100.00 cpt=1 rappro=1 rel=202602 liens=2 | SI2602-0214 #181 2026-02-25 00:00:00 46.50 st=1 | bank#375 -46.50 cpt=1 rappro=1 rel=202602 liens=2 | SI2602-0215 #182 2026-03-16 00:00:00 37.60 st=1 | bank#376 -37.60 cpt=1 rappro=1 rel=202603 liens=2 | SI2603-0216 #183 2026-04-13 00:00:00 41.20 st=1 | bank#377 -41.20 cpt=1 rappro=1 rel=202604 liens=2 | SI2604-0217 #184 2026-04-27 00:00:00 47.80 st=1 | bank#378 -47.80 cpt=1 rappro=1 rel=202604 liens=2 | SI2604-0218 #185 2026-04-28 00:00:00 173.70 st=1 | bank#379 -173.70 cpt=1 rappro=1 rel=202604 liens=2 | SI2604-0219 #186 2026-04-29 00:00:00 38.47 st=1 | bank#380 -38.47 cpt=1 rappro=1 rel=202604 liens=2 | SI2604-0220 #187 2026-05-04 00:00:00 30.58 st=1 | bank#381 -30.58 cpt=1 rappro=1 rel=202605 liens=2 | SI2605-0221 #188 2026-05-05 00:00:00 114.70 st=1 | bank#382 -114.70 cpt=1 rappro=1 rel=202605 liens=2 | SI2605-0222 #189 2026-05-07 00:00:00 53.78 st=1 | bank#383 -53.78 cpt=1 rappro=1 rel=202605 liens=2 | SI2605-0223 #190 2026-06-08 00:00:00 39.70 st=1 | bank#384 -39.70 cpt=1 rappro=1 rel=202606 liens=2 | SI2606-0224 #191 2026-06-11 00:00:00 70.00 st=1 | bank#385 -70.00 cpt=1 rappro=1 rel=202606 liens=2 | SI2606-0225 #192 2026-07-22 00:00:00 116.80 st=1 | bank#386 -116.80 cpt=1 rappro=1 rel=202607 liens=2 | SI2607-0226 #193 2026-08-07 00:00:00 66.60 st=1 | bank#387 -66.60 cpt=1 rappro=1 rel=202608 liens=2 | SI2608-0227 #194 2026-05-04 00:00:00 38.46 st=1 | bank#388 -38.46 cpt=1 rappro=1 rel=202605 liens=2 | SI2605-0228 #195 2026-03-16 00:00:00 100.13 st=1 | bank#389 -100.13 cpt=1 rappro=1 rel=202603 liens=2 | SI2603-0229 #196 2026-03-24 00:00:00 100.01 st=1 | bank#390 -100.01 cpt=1 rappro=1 rel=202603 liens=2 | SI2603-0230 #197 2026-03-30 00:00:00 100.05 st=1 | bank#391 -100.05 cpt=1 rappro=1 rel=202603 liens=2 | SI2603-0231 #198 2026-04-07 00:00:00 100.01 st=1 | bank#392 -100.01 cpt=1 rappro=1 rel=202604 liens=2 | SI2604-0232 #199 2026-04-20 00:00:00 100.19 st=1 | bank#393 -100.19 cpt=1 rappro=1 rel=202604 liens=2 | SI2604-0233 #200 2026-04-20 00:00:00 56.11 st=1 | bank#394 -56.11 cpt=1 rappro=1 rel=202604 liens=2 | SI2604-0234 #201 2026-04-27 00:00:00 100.01 st=1 | bank#395 -100.01 cpt=1 rappro=1 rel=202604 liens=2 | SI2604-0235 #202 2026-04-28 00:00:00 15.05 st=1 | bank#396 -15.05 cpt=1 rappro=1 rel=202604 liens=2 | SI2604-0236 #203 2026-05-13 00:00:00 100.38 st=1 | bank#397 -100.38 cpt=1 rappro=1 rel=202605 liens=2 | SI2605-0237 #204 2026-05-26 00:00:00 89.93 st=1 | bank#398 -89.93 cpt=1 rappro=1 rel=202605 liens=2 | SI2605-0238 #205 2026-07-28 00:00:00 200.00 st=1 | bank#399 -200.00 cpt=1 rappro=1 rel=202607 liens=2 | SI2607-0239 #206 2026-08-06 00:00:00 24.85 st=1 | bank#400 -24.85 cpt=1 rappro=1 rel=202608 liens=2 | SI2608-0240