================================================================= SECTION H - SOLDE LIVE BANQUE (llx_agentcompta_gcaccount) ================================================================= col rowid int col entity int col provider varchar(20) col gc_account_id varchar(255) col ext_hash varchar(128) col iban varchar(34) col institution_id varchar(100) col institution_name varchar(255) col requisition_id varchar(255) col reference varchar(255) col fk_bank_account int col consent_expiration date col balance decimal(15,2) col balance_date datetime col pending_json text col last_sync datetime col last_attempt datetime col last_status varchar(30) col last_error varchar(500) col status varchar(20) col date_creation datetime col tms timestamp --- gcaccount --- rowid = 1 entity = 1 provider = enablebanking gc_account_id = ecadca7b-8dd0-4a76-861f-bf95b4d88088 ext_hash = WwpbCiJhY2NvdW50IiwKImFjY291bnRfaWQiLAoiaWJhbiIKXQpd.sKauHfZ+/IjmI3KIiKjzaLEWfO+8y0Hn6w3hCPUHLYk= iban = FR7616606000242422500600113 institution_id = Crédit Agricole de Normandie institution_name = Crédit Agricole de Normandie requisition_id = 380733d8-3fe6-4cb7-a3ac-b5f407c31656 reference = eb fk_bank_account = consent_expiration = 2026-11-20 balance = 2879.64 balance_date = 2026-08-08 18:15:09 pending_json = [] last_sync = 2026-08-08 18:15:09 last_attempt = 2026-10-21 13:45:30 last_status = unmapped last_error = Aucun compte Dolibarr associé — association requise avant synchro. status = active date_creation = 2026-08-08 11:55:09 tms = 2026-10-21 13:45:28 --- gcaccount --- rowid = 2 entity = 1 provider = enablebanking gc_account_id = ff5c5bb9-f32d-4504-9e84-44af5159d4a2 ext_hash = WwpbCiJhY2NvdW50IiwKImFjY291bnRfaWQiLAoiaWJhbiIKXQpd.r3jsYzShRPex8JsAo26YeYGIH6DmjERh2mTh8wrLySw= iban = FR7616606052138488109336679 institution_id = Crédit Agricole de Normandie institution_name = Crédit Agricole de Normandie requisition_id = 380733d8-3fe6-4cb7-a3ac-b5f407c31656 reference = eb fk_bank_account = consent_expiration = 2026-11-20 balance = 13290.31 balance_date = 2026-08-08 18:15:10 pending_json = [] last_sync = 2026-08-08 18:15:10 last_attempt = 2026-10-21 13:45:30 last_status = unmapped last_error = Aucun compte Dolibarr associé — association requise avant synchro. status = active date_creation = 2026-08-08 11:55:09 tms = 2026-10-21 13:45:28 --- gcaccount --- rowid = 3 entity = 1 provider = enablebanking gc_account_id = c4eccb6d-f1cd-4cee-ad8f-20cbae2905f1 ext_hash = WwpbCiJhY2NvdW50IiwKImFjY291bnRfaWQiLAoiaWJhbiIKXQpd.8f5lBEVa0f+M/S9ZxBbDCiG2ALtB9yjEt3Nr4DJN6HY= iban = FR7616606450110016774587631 institution_id = Crédit Agricole de Normandie institution_name = Crédit Agricole de Normandie requisition_id = 380733d8-3fe6-4cb7-a3ac-b5f407c31656 reference = eb fk_bank_account = consent_expiration = 2026-11-20 balance = 84848.40 balance_date = 2026-08-08 18:15:12 pending_json = [] last_sync = 2026-08-08 18:17:13 last_attempt = 2026-10-21 13:45:30 last_status = unmapped last_error = Aucun compte Dolibarr associé — association requise avant synchro. status = active date_creation = 2026-08-08 11:55:09 tms = 2026-10-21 13:45:28 --- gcaccount --- rowid = 4 entity = 1 provider = enablebanking gc_account_id = 698c4bd7-4996-4893-b220-ac9557bcd20d ext_hash = WwpbCiJhY2NvdW50IiwKImFjY291bnRfaWQiLAoiaWJhbiIKXQpd.rui56mHCReFnyDQz8GgHIh18cclpuAxcoUol05iwAxQ= iban = FR7616606050118489487333640 institution_id = Crédit Agricole de Normandie institution_name = Crédit Agricole de Normandie requisition_id = a8008cda-fea9-4ffe-8b6d-8d08c6cb830b reference = eb fk_bank_account = 1 consent_expiration = 2026-11-22 balance = 12723.73 balance_date = 2026-10-21 13:45:38 pending_json = [{"_solde":{"nature":"CLBD","comptabilise":12723.73,"disponible":12723.73,"releve_le":"2026-10-21 13:45:38"}}] last_sync = 2026-10-21 13:45:41 last_attempt = 2026-10-21 13:45:41 last_status = ok last_error = status = active date_creation = 2026-08-08 11:55:09 tms = 2026-10-21 13:45:40 --- gcaccount --- rowid = 5 entity = 1 provider = enablebanking gc_account_id = 105743bc-aba7-477a-8794-d08f3ad9b912 ext_hash = WwpbCiJhY2NvdW50IiwKImFjY291bnRfaWQiLAoiaWJhbiIKXQpd.wQhNFJVR3nCtGPZOVCu7TvTikFyOaseILRp5CIh5cnY= iban = FR7616606050118490472149129 institution_id = Crédit Agricole de Normandie institution_name = Crédit Agricole de Normandie requisition_id = 380733d8-3fe6-4cb7-a3ac-b5f407c31656 reference = eb fk_bank_account = consent_expiration = 2026-11-20 balance = 149.76 balance_date = 2026-08-08 18:17:15 pending_json = [] last_sync = 2026-08-08 18:17:15 last_attempt = 2026-10-21 13:45:41 last_status = unmapped last_error = Aucun compte Dolibarr associé — association requise avant synchro. status = active date_creation = 2026-08-08 11:55:09 tms = 2026-10-21 13:45:40 ================================================================= SECTION I - PROGRESSION MENSUELLE ET SOLDE CUMULE (compte 1) ================================================================= 2025-12 1 lg debits 0,00 credits 37 001,25 net 37 001,25 cumul 37 001,25 2026-01 36 lg debits -39 118,45 credits 7 831,35 net -31 287,10 cumul 5 714,15 2026-02 30 lg debits -5 216,81 credits 27 044,69 net 21 827,88 cumul 27 542,03 2026-03 38 lg debits -21 139,21 credits 7 852,36 net -13 286,85 cumul 14 255,18 2026-04 52 lg debits -23 163,32 credits 25 831,84 net 2 668,52 cumul 16 923,70 2026-05 54 lg debits -57 146,69 credits 41 157,99 net -15 988,70 cumul 935,00 2026-06 51 lg debits -33 364,88 credits 41 639,37 net 8 274,49 cumul 9 209,49 2026-07 63 lg debits -51 784,73 credits 52 779,37 net 994,64 cumul 10 204,13 2026-08 47 lg debits -44 059,13 credits 31 215,25 net -12 843,88 cumul -2 639,75 2026-09 36 lg debits -23 082,46 credits 36 660,11 net 13 577,65 cumul 10 937,90 2026-10 21 lg debits -10 429,79 credits 15 525,79 net 5 096,00 cumul 16 033,90 SOLDE FINAL llx_bank compte 1 = 16 033,90 EUR ================================================================= SECTION J - FILE D'ATTENTE agentcompta_match (non traitee) ================================================================= col rowid col entity col fk_intake col fk_bank_account col bank_line_date col bank_line_label col bank_line_amount col bank_line_ref col fk_bank_line col target_type col fk_target col target_label col grouped_targets col match_score col match_reason col is_partial col suggested_amount col status col fk_user_decided col date_decided col date_creation col tms col fk_payment SQL ERR: Unknown column 'amount' in 'field list' [SELECT status, COUNT(*) c, ROUND(SUM(amount),2) s, MIN(op_date) mn, MAX(op_date) mx FROM llx_agentcompta_match GROUP BY status ORDER BY c DESC] -- detail des lignes en attente -- SQL ERR: Unknown column 'op_date' in 'field list' [SELECT rowid, op_date, ROUND(amount,2) amount, label, status, match_type, match_reason FROM llx_agentcompta_match WHERE status NOT IN ('done','archived','rejected','validated') ORDER BY op_date] ================================================================= SECTION K - LES 4 LIGNES rappro=0 : A QUOI SONT-ELLES LIEES ? ================================================================= bank#49 2026-01-16 973,68 type=VIR cree_le=2026-02-10 16:59:00 auteur=87 lien type=payment url_id=48 label=(paiement) paiement#48 datep=2026-01-16 12:00:00 montant=973,68 num= -> facture FA2512-0093 du 2025-12-22 TTC 212,46 | impute 212,46 | statut=2 paye=1 -> facture FA2512-0094 du 2025-12-22 TTC 296,29 | impute 296,29 | statut=2 paye=1 -> facture FA2512-0095 du 2025-12-22 TTC 290,06 | impute 290,06 | statut=2 paye=1 -> facture FA2512-0096 du 2025-12-22 TTC 174,87 | impute 174,87 | statut=2 paye=1 lien type=company url_id=221 label=Maisons naturea bank#52 2026-01-22 432,00 type=VIR cree_le=2026-02-12 10:02:01 auteur=87 lien type=payment url_id=51 label=(paiement) paiement#51 datep=2026-01-22 12:00:00 montant=432,00 num= -> facture FA2512-0087 du 2025-12-22 TTC 432,00 | impute 432,00 | statut=2 paye=1 lien type=company url_id=225 label=Renault Trucks bank#54 2026-02-05 499,11 type=VIR cree_le=2026-02-13 09:43:53 auteur=87 lien type=payment url_id=53 label=(paiement) paiement#53 datep=2026-02-05 12:00:00 montant=499,11 num= -> facture FA2602-0128 du 2026-02-05 TTC 333,45 | impute 333,45 | statut=2 paye=1 -> facture FA2602-0129 du 2026-02-05 TTC 165,66 | impute 165,66 | statut=2 paye=1 lien type=company url_id=284 label=LEFEVRE R bank#100 2026-06-26 832,23 type=VIR cree_le=2026-07-20 10:18:38 auteur=87 lien type=payment url_id=99 label=(paiement) paiement#99 datep=2026-06-26 12:00:00 montant=832,23 num= -> facture FA2604-0205 du 2026-04-18 TTC 832,23 | impute 832,23 | statut=2 paye=1 lien type=company url_id=292 label=Sabran Anthony ================================================================= SECTION L - GROUPE HTC 16,75 DU 14/01 ================================================================= bank#232 2026-01-14 -16,75 rap=1 rel=202601 cree=2026-08-09 21:24:09 auteur=1 (AgentCompta relevé) Virement émis WEB HTC SAS BC055158 TEKNIPLI - ACOMPTE HTC PROFORMA BC055158 TEKNIPLI lien payment_supplier #118 (paiement) lien company #288 Divers au comptant bank#407 2026-01-14 -16,75 rap=1 rel=202601 cree=2026-08-10 13:50:03 auteur=1 Acompte HTC — annulé le jour même (1/2) lien payment_various #72 (VariousPayment) bank#408 2026-01-14 16,75 rap=1 rel=202601 cree=2026-08-10 13:50:03 auteur=1 Annulation acompte HTC (1/2) lien payment_various #73 (VariousPayment) bank#409 2026-01-14 16,75 rap=1 rel=202601 cree=2026-08-10 13:50:03 auteur=1 Annulation acompte HTC (2/2) lien payment_various #74 (VariousPayment) bank#440 2026-01-14 -16,75 rap=1 rel=202601 cree=2026-08-10 13:51:40 auteur=1 Acompte HTC - tentative annulee (3e debit du releve) lien payment_various #104 (VariousPayment)