=== 1a nb ecritures bookkeeping ===
{"nb":"0"}
-- 1 lignes

=== 1b ecritures 445x ===
-- 0 lignes

=== 1c constantes TVA ===
{"name":"MAIN_DELAY_NOT_ACTIVATED_SERVICES","value":"0"}
{"name":"FACTURE_TVAOPTION","value":"1"}
{"name":"MAIN_INFO_TVAINTRA","value":"FR15929591741"}
{"name":"MAIN_INFO_VAT_RETURN","value":"1"}
{"name":"MAIN_INFO_TVA_DAY_DEADLINE_SUBMISSION","value":"0"}
{"name":"AGENTCOMPTA_EB_PRIVATE_KEY","value":"dolcrypt:AES-256-CTR:4a126f1eb096668a:Kt8Ojau3CffklIbTyyR9P4B3CULVBGeStcrcldOKOguqh\/kjWYOMSc6DIl2iIKxPQ4T3dqyYMyqyjrC7Z\/RolC9hPQcVyU+vmBZ7o3WdlGn\/GluULUVsBYWZWBnhteo9PloQo8L2CbkpQeo7F3pNkaacJv8rymZ3Qnd4h8NpO81gDKRp8Dz2MEFjwwmiGCRKKtel9bwrHcQ88GktDTduMVkQTB8dFs\/mDGgcW4V\/WKaovYfm+dQN9aHLPTA5CNKB5bUCbbEn+Jgo0G+EW0GGxGwQeZK+ebOL1dvgr9hCmr4IV4r1+9zjpp4I7doc81Zo\/UPczNgUbUuTv568DBZJ56Q1rG32CjKc9imAppoptATRP4SSXobdM710rjvYLCf103J\/gtDhcJJBgWDgfEdsAK+SiJzmvGTrWIN7LKEESmEiAcZeVP9tT2pADz3UzI48Fr3+nv\/Bm6AOXEj9UFbDIZtKWd3SCtyWqyGQM\/GOF2t9\/l\/ue2PTQTBP3YxLJ2IJGNe6XbTtt4jpge+rX9YIH7kM8k+VveVnYGZ1xsMpWT9Y0qw\/NGo9jg1\/yitmVjCFmt\/Bzw1b\/O4Epa96ZS53jxkhvTBjVPfVieM7rqnqwWUDF0I98WlNXqJRvA2UGwMrlW7PR4rvdPwwx18n7owye1zHW0qiruhzzboMpNk0UAORXMjRYBR0LL8R+vR+ej15JrdMetkOLFLzw8QRpwsh57QkY\/C2NKSzFDRXj4iJi4MchuVUzyTB8iBhg3LF8w1lhqxl6XIG\/mV9PGcjgyJe5Z2AyYFa4\/hTwXec0ikFH+q6y8RJME+7Zf\/niHSAZAnZse2upaDQbgJOPraN74YWBLJfKX82OLSF5iHWho8lu3RVG82Phtg\/4JBHdpQdrKzLUHPwvkUxzty28BYxJFuLQ7KDWBEf2nxci1NWjREgd+YE9UphUOKCevkXogUMiIFiUtdC4xSmFqnllK+SZ6MlwEOryRSUV8ZPKXWi8EPftQ8JIwy\/eCspnsLFLys4+\/YIQMFosEt0jUSBt4+waoagvko3vFqEKU5dUrtnc95FCo0jfH4v0k0YJBpSrHtnJTJ4wgYpUlWlTXNQcWRPvr9zqB83ACbpwy5TV0L4\/zMmkVqUES+Jq3ULzQBRc11Slnx6IleU2f0RNmfCRO44JJQGG\/uECApgVSMCbJ9C\/YNSqQEVX+9f5YNNMB5OFgvX4XLIJfjpzfskR5VDFM7YLLAOyFarUGtst\/ksJcZnkYcGQxPp+YXmgvDRPtWgfVMwzW\/JsmSFbWEEJZA+jassSO6R\/pCA77r95wCHtitmpf+6a9VAriLyBYWdW3T6+YaaXcANUMu3bRqbhCmlmWZ79krz3DZl5If\/lRKS+upoy3xeOt0gZp+pusxRNn4KxPBX4JGCMpMtP0y2A6auWUAK347v\/+NDlSjqbVyTy\/vo+r8a4+Taq641TR9XHVrSQXaVdp696\/pYgProtwqBLqLb0xwfoeFclx33dQXau7kiA0RucBGczhQugPX\/2JYiA3dPwtZzreXvB4\/MWG40YpElWm4erMxMQcvPfHjSZPQdaqpjs8f9JisUbEr\/LLxDuSTFkjAB+mFa2iOJJCItw+dTLFcJwpgatlS1T5Ufb+J8BZLI5ws\/hQtxj6kM6LjGuTJ1D71UyTNps1m5153KYVV+cyUlQtIKZsTuHjm6VIo9RU4MECZ6L4fHY1KiUPOnMQdVPnKC5Oql\/E21GiUTbp4f9rTcfeGE6RCmXCJrip53oc4B+H0jB3h0U6BWL0WOzLhbweY8d\/fJEDU+IwvNu2baS1QUJ7MbbnErbx0yI6vSc+2gldre7aZgNSmpeBCDw2RUBqmuCfoQTMxEHFtK4PbrHb\/3D4SRNNGtKe3d88W+dAzeCC0tMUMt4GMZLwXfINNf89+5xFNCFuBb1zbg5xpsncYI9x27JnNlGb2Qo4IUJLn7L34RrkUJ4ph55RPYNoppXGAq0esrsiN9OicImvfzYjRqRPT4pP8xoEVN0sq1Rp\/Fqlfn2heKb97DxdctLwLDGLa+4K18e0yq4jIARyGZoSmu9JZEyWkmkInUxrSzWlVkj9TsWTX7KuJaEkpVlPe7LXiEiqWeN\/PDv28Zo7IzWsIkCHevAfcyPGQa6yCr7NrxSZrC\/MZlYWylIYWHQzi4Cu8OqynuyJ7w1xGTW4BArxcFj4mcO6ZlhejzxvoKCB0rWDsMvnbtzlNLshDT+lcaK6b\/HEjd0RCuB5D1ABJQBHUCQPK0SGY9hGtU"}
-- 6 lignes

=== 2a payments 'TVA non recuperee' ===
{"rowid":"76","datep":"2026-02-19","amount":"44.98","accountancy_code":"6064","label":"Fournitures — Amazon (TVA non récupérée faute de pièce)"}
{"rowid":"79","datep":"2026-04-14","amount":"147.76","accountancy_code":"6061","label":"Carburant — Leclerc station (TVA non récupérée faute de pièce)"}
{"rowid":"81","datep":"2026-05-04","amount":"37.73","accountancy_code":"6063","label":"Fournitures d'atelier — Négo Achat C+ (TVA non récupérée faute de pièce)"}
{"rowid":"85","datep":"2026-05-20","amount":"31.7","accountancy_code":"6063","label":"Fournitures d'atelier — Delvia (TVA non récupérée faute de pièce)"}
{"rowid":"87","datep":"2026-05-26","amount":"143.8","accountancy_code":"6061","label":"Carburant — Relais Bretteville (TVA non récupérée faute de pièce)"}
{"rowid":"91","datep":"2026-07-03","amount":"35.01","accountancy_code":"6064","label":"Fournitures — Amazon (TVA non récupérée faute de pièce)"}
{"rowid":"92","datep":"2026-07-03","amount":"10.72","accountancy_code":"6064","label":"Fournitures — Amazon (TVA non récupérée faute de pièce)"}
{"rowid":"94","datep":"2026-07-16","amount":"12","accountancy_code":"6063","label":"Fournitures d'atelier — Setin (TVA non récupérée faute de pièce)"}
{"rowid":"102","datep":"2026-08-06","amount":"280.9","accountancy_code":"6063","label":"Fournitures d'atelier — Setin (TVA non récupérée faute de pièce)"}
-- 9 lignes

=== 2b total TVA non recuperee ===
{"nb":"9","total_ttc":"744.6","tva_perdue_si_20":"124.1"}
-- 1 lignes

=== 3 compte 471 ===
{"rowid":"72","datep":"2026-01-14","sens":"0","amount":"16.75","label":"Acompte HTC — annulé le jour même (1\/2)"}
{"rowid":"73","datep":"2026-01-14","sens":"1","amount":"16.75","label":"Annulation acompte HTC (1\/2)"}
{"rowid":"74","datep":"2026-01-14","sens":"1","amount":"16.75","label":"Annulation acompte HTC (2\/2)"}
{"rowid":"104","datep":"2026-01-14","sens":"0","amount":"16.75","label":"Acompte HTC - tentative annulee (3e debit du releve)"}
{"rowid":"30","datep":"2026-01-23","sens":"0","amount":"60","label":"Crédit-bail — acte de gestion à identifier"}
{"rowid":"34","datep":"2026-02-17","sens":"1","amount":"54","label":"Crédit-bail — acte de gestion à identifier"}
{"rowid":"75","datep":"2026-02-17","sens":"0","amount":"5.99","label":"Uber One — nature à confirmer"}
{"rowid":"77","datep":"2026-03-17","sens":"0","amount":"5.99","label":"Uber One — nature à confirmer"}
{"rowid":"82","datep":"2026-05-12","sens":"0","amount":"253.43","label":"Achat Verpakgigant — remboursé le 15\/05"}
{"rowid":"83","datep":"2026-05-15","sens":"1","amount":"253.43","label":"Remboursement Verpakgigant"}
{"rowid":"68","datep":"2026-05-19","sens":"0","amount":"550","label":"Virement notaire du 19\/05 — part non justifiée"}
-- 11 lignes

=== 4a plage factures fourn ===
{"mn":"2026-01-01","mx":"2026-10-20","nb":"256"}
-- 1 lignes

=== 4b plage factures clients ===
{"mn":"2025-07-09","mx":"2026-10-21","nb":"392"}
-- 1 lignes

=== 5a ventilation lignes clients 2026 ===
{"nb":"1243","ventilees":"14"}
-- 1 lignes

=== 5b ventilation lignes fourn 2026 ===
{"nb":"364","ventilees":"244"}
-- 1 lignes

=== 6a clients ttc<>ht+tva ===
ERREUR: Unknown column 'total_localtax1' in 'where clause'

=== 6b fourn ttc<>ht+tva ===
ERREUR: Unknown column 'total_localtax1' in 'where clause'

=== 7 encaissements 2026 par annee de facture ===
{"mois":"2026-01","an_fact":"2025","ttc":"7475.11","tva":"1245.86"}
{"mois":"2026-01","an_fact":"2026","ttc":"322.74","tva":"53.79"}
{"mois":"2026-02","an_fact":"2025","ttc":"3040.32","tva":"506.68"}
{"mois":"2026-02","an_fact":"2026","ttc":"20835.37","tva":"3472.56"}
{"mois":"2026-03","an_fact":"2026","ttc":"7852.37","tva":"1308.75"}
{"mois":"2026-04","an_fact":"2026","ttc":"21023.84","tva":"3504.05"}
{"mois":"2026-05","an_fact":"2026","ttc":"40285.76","tva":"6550.27"}
{"mois":"2026-06","an_fact":"2026","ttc":"31048.97","tva":"4764.21"}
{"mois":"2026-07","an_fact":"2026","ttc":"50526.4","tva":"8421.04"}
{"mois":"2026-08","an_fact":"2026","ttc":"31215.25","tva":"5202.53"}
{"mois":"2026-09","an_fact":"2026","ttc":"36660.11","tva":"6109.97"}
{"mois":"2026-10","an_fact":"2026","ttc":"15525.79","tva":"2587.63"}
-- 12 lignes

=== 8 encaissements par statut de facture ===
{"fk_statut":"2","nb":"259","ttc":"265282.92"}
{"fk_statut":"1","nb":"2","ttc":"529.11"}
-- 2 lignes

=== 9a devises clients ===
{"multicurrency_code":"EUR","nb":"392"}
-- 1 lignes

=== 9b devises fourn ===
{"multicurrency_code":"EUR","nb":"256"}
-- 1 lignes

=== 10 fourn etrangers ===
{"rowid":"347","nom":"SCI MARLEG","tva_intra":"","fk_pays":null,"code":null,"label":null,"nbfact":"9","ht":"32966","tva":"4993.2"}
{"rowid":"353","nom":"MULTILAQUE","tva_intra":"","fk_pays":null,"code":null,"label":null,"nbfact":"5","ht":"5753.46","tva":"1150.69"}
{"rowid":"372","nom":"ARCELOR MITTAL","tva_intra":"","fk_pays":null,"code":null,"label":null,"nbfact":"4","ht":"5308.08","tva":"1061.61"}
{"rowid":"355","nom":"DEVELOPIMMO","tva_intra":"","fk_pays":null,"code":null,"label":null,"nbfact":"1","ht":"5000","tva":"1000"}
{"rowid":"359","nom":"KDI","tva_intra":"","fk_pays":null,"code":null,"label":null,"nbfact":"5","ht":"4691.47","tva":"938.29"}
{"rowid":"361","nom":"METALMAQ","tva_intra":"","fk_pays":null,"code":null,"label":null,"nbfact":"1","ht":"2712","tva":"0"}
{"rowid":"357","nom":"EQUIPEMENT SCIENTIFIQUE","tva_intra":"","fk_pays":null,"code":null,"label":null,"nbfact":"2","ht":"1199.33","tva":"239.87"}
{"rowid":"399","nom":"BULTEAU SYSTEMS","tva_intra":"FR03440279214","fk_pays":"76","code":"HR","label":"Croatia","nbfact":"1","ht":"567.45","tva":"113.49"}
{"rowid":"362","nom":"NOTAIRE","tva_intra":"","fk_pays":null,"code":null,"label":null,"nbfact":"1","ht":"425","tva":"60.01"}
{"rowid":"356","nom":"EDF","tva_intra":"","fk_pays":null,"code":null,"label":null,"nbfact":"4","ht":"325.62","tva":"65.12"}
{"rowid":"354","nom":"ANTAI","tva_intra":"","fk_pays":null,"code":null,"label":null,"nbfact":"1","ht":"287.76","tva":"0"}
{"rowid":"394","nom":"ETABLISSEMENTS JACQUET","tva_intra":"FR88403432693","fk_pays":"76","code":"HR","label":"Croatia","nbfact":"1","ht":"200","tva":"40"}
{"rowid":"360","nom":"LA POSTE","tva_intra":"","fk_pays":null,"code":null,"label":null,"nbfact":"6","ht":"184.44","tva":"0"}
{"rowid":"366","nom":"MPI","tva_intra":"","fk_pays":null,"code":null,"label":null,"nbfact":"1","ht":"160.5","tva":"32.1"}
{"rowid":"391","nom":"SARL ABORDS ET PAYSAGES","tva_intra":"FR07892610262","fk_pays":"76","code":"HR","label":"Croatia","nbfact":"1","ht":"159.92","tva":"31.98"}
{"rowid":"364","nom":"SETIN","tva_intra":"","fk_pays":null,"code":null,"label":null,"nbfact":"1","ht":"124.88","tva":"24.98"}
{"rowid":"365","nom":"TAUPIN","tva_intra":"","fk_pays":null,"code":null,"label":null,"nbfact":"1","ht":"93.6","tva":"18.72"}
{"rowid":"367","nom":"DMD METAL","tva_intra":"","fk_pays":null,"code":null,"label":null,"nbfact":"1","ht":"80","tva":"16"}
{"rowid":"385","nom":"AIR GPL","tva_intra":"FR79841268089","fk_pays":"76","code":"HR","label":"Croatia","nbfact":"1","ht":"73.73","tva":"14.75"}
{"rowid":"363","nom":"OCMANDY","tva_intra":"","fk_pays":null,"code":null,"label":null,"nbfact":"1","ht":"41.32","tva":"8.26"}
{"rowid":"400","nom":"STAHLWERK Schweissgeräte GmbH","tva_intra":"","fk_pays":"76","code":"HR","label":"Croatia","nbfact":"1","ht":"39.08","tva":"7.81"}
{"rowid":"395","nom":"shenzhenshitianpengshengkejiyouxiangongsi","tva_intra":"FR14990073504","fk_pays":"76","code":"HR","label":"Croatia","nbfact":"1","ht":"33.32","tva":"0"}
{"rowid":"396","nom":"POWER TOOLS MAREK BIELESZ SPOLKA KOMANDYTOWA","tva_intra":"","fk_pays":"76","code":"HR","label":"Croatia","nbfact":"1","ht":"19.17","tva":"0"}
{"rowid":"397","nom":"Ulbrich Suzana Ltd","tva_intra":"","fk_pays":"76","code":"HR","label":"Croatia","nbfact":"1","ht":"16.64","tva":"3.33"}
{"rowid":"321","nom":"huizhoushizhenxindianzikejiyouxiangongsi","tva_intra":"FR28913301727","fk_pays":"9","code":"CN","label":"China","nbfact":"1","ht":"16.62","tva":"0"}
{"rowid":"320","nom":"Shenzhenshi Fengmaishiyeyouxiangongsi","tva_intra":"","fk_pays":"76","code":"HR","label":"Croatia","nbfact":"1","ht":"15.82","tva":"0"}
{"rowid":"358","nom":"INPI","tva_intra":"","fk_pays":null,"code":null,"label":null,"nbfact":"1","ht":"1.24","tva":"0"}
-- 27 lignes