=== SYNTHESE TVA 2026 (mois de la PERIODE) === periode col_debits ded_debits pos_debits | col_encais ded_encais pos_encais | reel_tresor ec_debits ec_encais 2026-01 1451.82 4553.74 -3101.92 | 1299.65 4518.74 -3219.09 | -3115.00 13.08 -104.09 2026-02 3879.91 1853.09 2026.82 | 3979.24 734.52 3244.72 | 2367.00 -340.18 877.72 2026-03 4860.85 6345.38 -1484.53 | 1308.75 1631.70 -322.95 | -4808.00 3323.47 4485.05 2026-04 5296.11 2180.58 3115.53 | 3504.05 3176.42 327.63 | 1272.00 1843.53 -944.37 2026-05 6260.73 7712.06 -1451.33 | 6550.27 6136.39 413.88 | 3.00 -1454.33 410.88 2026-06 5286.01 6613.83 -1327.82 | 4764.21 4409.37 354.84 | -2194.00 866.18 2548.84 2026-07 6496.17 4720.17 1776.00 | 8421.04 7286.80 1134.24 | 3617.00 -1841.00 -2482.76 2026-08 6378.46 2311.04 4067.42 | 5202.53 5986.17 -783.64 | 5550.00 -1482.58 -6333.64 2026-09 4713.30 3171.40 1541.90 | 6109.97 2498.23 3611.74 | - - - 2026-10 3358.58 1677.73 1680.85 | 2587.63 1166.39 1421.24 | - - - TOTAL 47981.94 41139.02 6842.92 | 43727.34 37544.73 6182.61 | 2692.00 DETAIL des mouvements tresor rattaches (periode => lignes payment_various): 2025-12 => 7014.00 [17/2026-01-28/44551/-7014.00] 2026-01 => -3115.00 [18/2026-02-25/44567/+3115.00] 2026-02 => 2367.00 [19/2026-03-25/44551/-2367.00] 2026-03 => -4808.00 [20/2026-04-30/44567/+4808.00] 2026-04 => 1272.00 [22/2026-05-28/44551/-1272.00] 2026-05 => 3.00 [24/2026-06-24/44551/-3.00] 2026-06 => -2194.00 [25/2026-07-30/44567/+2194.00] 2026-07 => 3617.00 [118/2026-08-26/44551/-3617.00] 2026-08 => 5550.00 [112/2026-09-29/44551/-5550.00] CUMUL PERIODES JANV-JUIN 2026 : debits=-2223.25 encaissements=799.04 reel=-6475.00 ecart_debits=4251.75 ecart_encais=7274.04 === AB1 lignes de la facture abandonnee FA2509-0028 === {"rowid":"114","product_type":"1","tva_tx":"20.0000","ht":"64746.26","tva":"12949.25","descr":"Transfert du chiffre de d'affaire ancien logiciels"} -- 1 lignes === AB2 paiements sur factures abandonnees === -- 0 lignes === AB3 autres factures du meme client === {"rowid":"8","ref":"FA2507-0004","datef":"2025-07-19","fk_statut":"2","ht":"1733.44","tva":"346.71"} {"rowid":"10","ref":"FA2507-0006","datef":"2025-07-23","fk_statut":"2","ht":"793.16","tva":"158.61"} {"rowid":"11","ref":"FA2507-0007","datef":"2025-07-23","fk_statut":"2","ht":"380.34","tva":"76.08"} {"rowid":"12","ref":"FA2507-0008","datef":"2025-07-23","fk_statut":"2","ht":"804.26","tva":"160.84"} {"rowid":"13","ref":"FA2507-0009","datef":"2025-07-23","fk_statut":"2","ht":"701.55","tva":"140.31"} {"rowid":"14","ref":"FA2507-0010","datef":"2025-07-23","fk_statut":"2","ht":"773.76","tva":"154.75"} {"rowid":"15","ref":"FA2507-0011","datef":"2025-07-23","fk_statut":"2","ht":"18.26","tva":"3.65"} {"rowid":"16","ref":"FA2507-0012","datef":"2025-07-23","fk_statut":"2","ht":"570.29","tva":"114.06"} {"rowid":"18","ref":"FA2507-0014","datef":"2025-07-23","fk_statut":"2","ht":"970.87","tva":"194.17"} {"rowid":"19","ref":"FA2507-0015","datef":"2025-07-23","fk_statut":"2","ht":"738.09","tva":"147.62"} {"rowid":"20","ref":"FA2507-0016","datef":"2025-07-23","fk_statut":"2","ht":"1080","tva":"216"} {"rowid":"21","ref":"FA2507-0017","datef":"2025-07-24","fk_statut":"2","ht":"246.65","tva":"49.32"} {"rowid":"22","ref":"FA2507-0018","datef":"2025-07-24","fk_statut":"2","ht":"693.47","tva":"138.68"} {"rowid":"23","ref":"FA2507-0019","datef":"2025-07-24","fk_statut":"2","ht":"76.34","tva":"15.27"} {"rowid":"27","ref":"FA2509-0023","datef":"2025-09-01","fk_statut":"2","ht":"390.98","tva":"78.18"} {"rowid":"34","ref":"FA2509-0028","datef":"2025-09-02","fk_statut":"3","ht":"64746.26","tva":"12949.25"} {"rowid":"35","ref":"FA2509-0029","datef":"2025-09-03","fk_statut":"2","ht":"370","tva":"74"} {"rowid":"36","ref":"FA2509-0030","datef":"2025-09-08","fk_statut":"2","ht":"785.05","tva":"156.99"} {"rowid":"38","ref":"FA2509-0032","datef":"2025-09-08","fk_statut":"2","ht":"1498.69","tva":"299.74"} {"rowid":"40","ref":"FA2509-0034","datef":"2025-09-11","fk_statut":"2","ht":"609.7","tva":"121.94"} {"rowid":"41","ref":"FA2509-0035","datef":"2025-09-14","fk_statut":"2","ht":"557.82","tva":"111.56"} {"rowid":"42","ref":"FA2509-0036","datef":"2025-09-14","fk_statut":"2","ht":"1244.63","tva":"248.92"} {"rowid":"43","ref":"FA2509-0037","datef":"2025-09-14","fk_statut":"2","ht":"910","tva":"182"} {"rowid":"45","ref":"FA2509-0039","datef":"2025-09-18","fk_statut":"2","ht":"1317.68","tva":"263.52"} {"rowid":"46","ref":"FA2509-0040","datef":"2025-09-18","fk_statut":"2","ht":"286","tva":"57.2"} {"rowid":"50","ref":"FA2509-0044","datef":"2025-09-18","fk_statut":"2","ht":"242.66","tva":"48.53"} {"rowid":"51","ref":"FA2509-0045","datef":"2025-09-19","fk_statut":"2","ht":"303.48","tva":"60.69"} {"rowid":"52","ref":"FA2509-0046","datef":"2025-09-19","fk_statut":"2","ht":"312.2","tva":"62.43"} {"rowid":"63","ref":"FA2510-0057","datef":"2025-10-19","fk_statut":"2","ht":"562.6","tva":"112.53"} {"rowid":"64","ref":"FA2510-0058","datef":"2025-10-19","fk_statut":"2","ht":"2124.29","tva":"424.86"} {"rowid":"65","ref":"FA2510-0059","datef":"2025-10-19","fk_statut":"2","ht":"204.21","tva":"40.84"} {"rowid":"66","ref":"FA2510-0060","datef":"2025-10-19","fk_statut":"2","ht":"792.52","tva":"158.51"} {"rowid":"67","ref":"FA2510-0061","datef":"2025-10-19","fk_statut":"2","ht":"198.78","tva":"39.75"} {"rowid":"68","ref":"FA2510-0062","datef":"2025-10-19","fk_statut":"2","ht":"410.9","tva":"82.15"} {"rowid":"69","ref":"FA2510-0063","datef":"2025-10-19","fk_statut":"2","ht":"462.5","tva":"92.5"} {"rowid":"70","ref":"FA2510-0064","datef":"2025-10-19","fk_statut":"2","ht":"1011.61","tva":"202.33"} {"rowid":"72","ref":"FA2510-0066","datef":"2025-10-19","fk_statut":"2","ht":"1508.14","tva":"301.61"} {"rowid":"73","ref":"FA2510-0067","datef":"2025-10-19","fk_statut":"2","ht":"2965.87","tva":"593.19"} {"rowid":"74","ref":"FA2510-0068","datef":"2025-10-19","fk_statut":"2","ht":"1649.01","tva":"329.79"} {"rowid":"75","ref":"FA2510-0069","datef":"2025-10-22","fk_statut":"2","ht":"1760","tva":"352"} {"rowid":"85","ref":"FA2512-0078","datef":"2025-12-04","fk_statut":"2","ht":"1072.44","tva":"214.48"} {"rowid":"86","ref":"FA2512-0079","datef":"2025-12-04","fk_statut":"2","ht":"64.97","tva":"12.99"} {"rowid":"87","ref":"FA2512-0080","datef":"2025-12-04","fk_statut":"2","ht":"1134.18","tva":"226.84"} {"rowid":"90","ref":"FA2512-0083","datef":"2025-12-04","fk_statut":"2","ht":"8246.31","tva":"1649.27"} {"rowid":"91","ref":"FA2512-0084","datef":"2025-12-04","fk_statut":"2","ht":"510.9","tva":"102.18"} {"rowid":"92","ref":"FA2512-0085","datef":"2025-12-05","fk_statut":"2","ht":"644.89","tva":"128.97"} {"rowid":"97","ref":"FA2512-0089","datef":"2025-12-22","fk_statut":"2","ht":"879.84","tva":"175.97"} {"rowid":"109","ref":"FA2512-0101","datef":"2025-12-23","fk_statut":"2","ht":"94.42","tva":"18.88"} {"rowid":"112","ref":"FA2512-0104","datef":"2025-12-23","fk_statut":"2","ht":"92.14","tva":"18.44"} {"rowid":"113","ref":"FA2512-0105","datef":"2025-12-23","fk_statut":"2","ht":"769.4","tva":"153.88"} {"rowid":"114","ref":"FA2512-0106","datef":"2025-12-23","fk_statut":"2","ht":"1138.53","tva":"227.71"} {"rowid":"115","ref":"FA2512-0107","datef":"2025-12-23","fk_statut":"2","ht":"120.78","tva":"24.15"} {"rowid":"116","ref":"FA2512-0108","datef":"2025-12-23","fk_statut":"2","ht":"267.52","tva":"53.51"} {"rowid":"118","ref":"FA2512-0110","datef":"2025-12-23","fk_statut":"2","ht":"394.87","tva":"78.97"} {"rowid":"119","ref":"FA2512-0111","datef":"2025-12-23","fk_statut":"2","ht":"2007.03","tva":"401.4"} {"rowid":"120","ref":"FA2512-0112","datef":"2025-12-23","fk_statut":"2","ht":"304.57","tva":"60.92"} {"rowid":"123","ref":"FA2512-0115","datef":"2025-12-23","fk_statut":"2","ht":"1073.39","tva":"214.7"} {"rowid":"137","ref":"FA2601-0122","datef":"2026-01-21","fk_statut":"2","ht":"2171.02","tva":"434.23"} {"rowid":"138","ref":"FA2601-0123","datef":"2026-01-21","fk_statut":"2","ht":"766.92","tva":"153.39"} {"rowid":"139","ref":"FA2601-0124","datef":"2026-01-21","fk_statut":"2","ht":"87.68","tva":"17.55"} {"rowid":"140","ref":"FA2601-0125","datef":"2026-01-27","fk_statut":"2","ht":"1452.09","tva":"290.43"} {"rowid":"141","ref":"FA2601-0126","datef":"2026-01-27","fk_statut":"2","ht":"460.94","tva":"92.2"} {"rowid":"142","ref":"FA2601-0127","datef":"2026-01-27","fk_statut":"2","ht":"844.59","tva":"168.9"} {"rowid":"150","ref":"FA2602-0132","datef":"2026-02-09","fk_statut":"2","ht":"917.11","tva":"183.41"} {"rowid":"151","ref":"FA2602-0133","datef":"2026-02-09","fk_statut":"2","ht":"352.6","tva":"70.54"} {"rowid":"152","ref":"FA2602-0134","datef":"2026-02-09","fk_statut":"2","ht":"809.26","tva":"161.85"} {"rowid":"161","ref":"FA2602-0142","datef":"2026-02-25","fk_statut":"2","ht":"985.1","tva":"197.02"} {"rowid":"173","ref":"FA2603-0153","datef":"2026-03-14","fk_statut":"2","ht":"326.17","tva":"65.24"} {"rowid":"174","ref":"FA2603-0154","datef":"2026-03-14","fk_statut":"2","ht":"128.39","tva":"25.68"} {"rowid":"178","ref":"FA2603-0158","datef":"2026-03-14","fk_statut":"2","ht":"250","tva":"50"} {"rowid":"180","ref":"FA2603-0160","datef":"2026-03-15","fk_statut":"2","ht":"553.39","tva":"110.69"} {"rowid":"181","ref":"FA2603-0161","datef":"2026-03-15","fk_statut":"2","ht":"1523","tva":"304.6"} {"rowid":"182","ref":"FA2603-0162","datef":"2026-03-15","fk_statut":"2","ht":"338.74","tva":"67.74"} {"rowid":"183","ref":"FA2603-0163","datef":"2026-03-15","fk_statut":"2","ht":"450.23","tva":"90.05"} {"rowid":"196","ref":"FA2604-0176","datef":"2026-04-17","fk_statut":"2","ht":"410.71","tva":"82.15"} {"rowid":"206","ref":"FA2604-0186","datef":"2026-04-18","fk_statut":"2","ht":"59.76","tva":"11.95"} {"rowid":"215","ref":"FA2604-0195","datef":"2026-04-18","fk_statut":"2","ht":"464.41","tva":"92.89"} {"rowid":"218","ref":"FA2604-0198","datef":"2026-04-18","fk_statut":"2","ht":"1208.4","tva":"241.69"} {"rowid":"219","ref":"FA2604-0199","datef":"2026-04-18","fk_statut":"2","ht":"145.36","tva":"29.07"} {"rowid":"220","ref":"FA2604-0200","datef":"2026-04-18","fk_statut":"2","ht":"316.97","tva":"63.39"} {"rowid":"221","ref":"FA2604-0201","datef":"2026-04-18","fk_statut":"2","ht":"150.59","tva":"30.13"} {"rowid":"224","ref":"FA2604-0204","datef":"2026-04-18","fk_statut":"2","ht":"1024.98","tva":"205"} {"rowid":"226","ref":"FA2604-0206","datef":"2026-04-18","fk_statut":"2","ht":"1036.77","tva":"207.35"} {"rowid":"227","ref":"FA2604-0207","datef":"2026-04-18","fk_statut":"2","ht":"450.98","tva":"90.22"} {"rowid":"229","ref":"FA2604-0208","datef":"2026-04-18","fk_statut":"2","ht":"373.9","tva":"74.78"} {"rowid":"232","ref":"FA2605-0210","datef":"2026-05-07","fk_statut":"2","ht":"5438.28","tva":"1087.63"} {"rowid":"238","ref":"FA2605-0216","datef":"2026-05-12","fk_statut":"2","ht":"444.95","tva":"88.98"} {"rowid":"243","ref":"FA2605-0221","datef":"2026-05-20","fk_statut":"2","ht":"1198.42","tva":"239.68"} {"rowid":"244","ref":"FA2605-0222","datef":"2026-05-20","fk_statut":"2","ht":"129.74","tva":"25.95"} {"rowid":"245","ref":"FA2605-0223","datef":"2026-05-20","fk_statut":"2","ht":"1073.45","tva":"214.71"} {"rowid":"254","ref":"FA2605-0232","datef":"2026-05-30","fk_statut":"2","ht":"564.22","tva":"112.84"} {"rowid":"255","ref":"FA2605-0233","datef":"2026-05-30","fk_statut":"2","ht":"134.25","tva":"26.85"} {"rowid":"263","ref":"FA2606-0241","datef":"2026-06-10","fk_statut":"2","ht":"1148.94","tva":"229.79"} {"rowid":"264","ref":"FA2606-0242","datef":"2026-06-10","fk_statut":"2","ht":"194.82","tva":"38.96"} {"rowid":"265","ref":"FA2606-0243","datef":"2026-06-10","fk_statut":"2","ht":"235.08","tva":"47.02"} {"rowid":"271","ref":"FA2606-0249","datef":"2026-06-23","fk_statut":"2","ht":"1850.43","tva":"370.1"} {"rowid":"277","ref":"FA2606-0255","datef":"2026-06-29","fk_statut":"2","ht":"797.86","tva":"159.58"} {"rowid":"278","ref":"FA2606-0256","datef":"2026-06-29","fk_statut":"2","ht":"450.83","tva":"90.16"} {"rowid":"293","ref":"FA2607-0271","datef":"2026-07-19","fk_statut":"2","ht":"273.7","tva":"54.75"} {"rowid":"294","ref":"FA2607-0272","datef":"2026-07-19","fk_statut":"2","ht":"825.35","tva":"165.08"} {"rowid":"296","ref":"FA2607-0274","datef":"2026-07-19","fk_statut":"2","ht":"289.09","tva":"57.83"} {"rowid":"297","ref":"FA2607-0275","datef":"2026-07-19","fk_statut":"2","ht":"321.26","tva":"64.26"} {"rowid":"300","ref":"FA2607-0278","datef":"2026-07-21","fk_statut":"2","ht":"1953.56","tva":"390.72"} {"rowid":"302","ref":"FA2607-0280","datef":"2026-07-21","fk_statut":"2","ht":"60.66","tva":"12.13"} {"rowid":"303","ref":"FA2607-0281","datef":"2026-07-21","fk_statut":"2","ht":"589.2","tva":"117.82"} {"rowid":"306","ref":"FA2607-0284","datef":"2026-07-24","fk_statut":"2","ht":"114.84","tva":"22.97"} {"rowid":"312","ref":"FA2607-0290","datef":"2026-07-29","fk_statut":"2","ht":"116.5","tva":"23.3"} {"rowid":"319","ref":"FA2607-0297","datef":"2026-07-31","fk_statut":"2","ht":"2904.6","tva":"580.91"} {"rowid":"320","ref":"FA2607-0298","datef":"2026-07-31","fk_statut":"2","ht":"150.33","tva":"30.07"} {"rowid":"323","ref":"FA2608-0301","datef":"2026-08-03","fk_statut":"2","ht":"135.91","tva":"27.17"} {"rowid":"328","ref":"FA2608-0306","datef":"2026-08-03","fk_statut":"2","ht":"247.93","tva":"49.59"} {"rowid":"331","ref":"FA2608-0309","datef":"2026-08-03","fk_statut":"2","ht":"191.28","tva":"38.25"} {"rowid":"332","ref":"FA2608-0310","datef":"2026-08-03","fk_statut":"2","ht":"596.75","tva":"119.35"} {"rowid":"333","ref":"FA2608-0311","datef":"2026-08-03","fk_statut":"2","ht":"414.56","tva":"82.91"} {"rowid":"334","ref":"FA2608-0312","datef":"2026-08-03","fk_statut":"2","ht":"85.12","tva":"17.03"} {"rowid":"335","ref":"FA2608-0313","datef":"2026-08-03","fk_statut":"2","ht":"1035.58","tva":"207.12"} {"rowid":"337","ref":"FA2608-0315","datef":"2026-08-03","fk_statut":"2","ht":"1468.34","tva":"293.65"} {"rowid":"338","ref":"FA2608-0316","datef":"2026-08-03","fk_statut":"2","ht":"299.91","tva":"59.99"} {"rowid":"339","ref":"FA2608-0317","datef":"2026-08-03","fk_statut":"2","ht":"19.95","tva":"3.99"} {"rowid":"340","ref":"FA2608-0318","datef":"2026-08-03","fk_statut":"2","ht":"351.2","tva":"70.24"} {"rowid":"341","ref":"FA2608-0319","datef":"2026-08-03","fk_statut":"2","ht":"52.52","tva":"10.5"} {"rowid":"342","ref":"FA2608-0320","datef":"2026-08-04","fk_statut":"2","ht":"1707.45","tva":"341.48"} {"rowid":"343","ref":"FA2608-0321","datef":"2026-08-04","fk_statut":"2","ht":"1781.32","tva":"356.26"} {"rowid":"344","ref":"FA2608-0322","datef":"2026-08-05","fk_statut":"2","ht":"960.29","tva":"192.06"} {"rowid":"345","ref":"FA2608-0323","datef":"2026-08-05","fk_statut":"2","ht":"66.32","tva":"13.26"} {"rowid":"346","ref":"FA2608-0324","datef":"2026-08-05","fk_statut":"2","ht":"1632.6","tva":"326.52"} {"rowid":"348","ref":"FA2608-0326","datef":"2026-08-05","fk_statut":"2","ht":"300","tva":"60"} {"rowid":"349","ref":"FA2608-0327","datef":"2026-08-05","fk_statut":"2","ht":"400","tva":"80"} {"rowid":"350","ref":"FA2608-0328","datef":"2026-08-05","fk_statut":"2","ht":"459.74","tva":"91.95"} {"rowid":"353","ref":"FA2608-0331","datef":"2026-08-08","fk_statut":"1","ht":"94.56","tva":"18.91"} {"rowid":"378","ref":"(PROV378)","datef":"2026-08-19","fk_statut":"0","ht":"164.28","tva":"32.87"} {"rowid":"379","ref":"(PROV379)","datef":"2026-08-19","fk_statut":"0","ht":"767.65","tva":"153.53"} {"rowid":"407","ref":"FA2609-0365","datef":"2026-09-21","fk_statut":"2","ht":"549.86","tva":"109.98"} {"rowid":"411","ref":"FA2609-0369","datef":"2026-09-28","fk_statut":"2","ht":"6311.44","tva":"1262.28"} {"rowid":"413","ref":"FA2609-0371","datef":"2026-09-28","fk_statut":"2","ht":"1417.17","tva":"283.46"} {"rowid":"414","ref":"FA2609-0372","datef":"2026-09-28","fk_statut":"2","ht":"1493.57","tva":"298.73"} {"rowid":"415","ref":"FA2609-0373","datef":"2026-09-28","fk_statut":"2","ht":"1570.56","tva":"314.07"} -- 137 lignes === CR1 tiers fk_pays=76 === {"nb":"14","avec_tvaintra_FR":"6","cp_5chiffres":"1"} -- 1 lignes === CR2 liste tiers fk_pays=76 === {"rowid":"385","nom":"AIR GPL","tva_intra":"FR79841268089","zip":null,"town":null} {"rowid":"327","nom":"autosen gmbh","tva_intra":"","zip":null,"town":null} {"rowid":"399","nom":"BULTEAU SYSTEMS","tva_intra":"FR03440279214","zip":null,"town":null} {"rowid":"393","nom":"ETABLISSEMENTS JACQUET","tva_intra":"FR88403432693","zip":"14730","town":"GIBERVILLE"} {"rowid":"394","nom":"ETABLISSEMENTS JACQUET","tva_intra":"FR88403432693","zip":null,"town":null} {"rowid":"370","nom":"Furneaux Riddall & Co Ltd","tva_intra":"","zip":null,"town":null} {"rowid":"396","nom":"POWER TOOLS MAREK BIELESZ SPOLKA KOMANDYTOWA","tva_intra":"","zip":null,"town":null} {"rowid":"391","nom":"SARL ABORDS ET PAYSAGES","tva_intra":"FR07892610262","zip":null,"town":null} {"rowid":"320","nom":"Shenzhenshi Fengmaishiyeyouxiangongsi","tva_intra":"","zip":null,"town":null} {"rowid":"395","nom":"shenzhenshitianpengshengkejiyouxiangongsi","tva_intra":"FR14990073504","zip":null,"town":null} {"rowid":"400","nom":"STAHLWERK Schweissgeräte GmbH","tva_intra":"","zip":null,"town":null} {"rowid":"379","nom":"TE Connectivity Solutions GmbH","tva_intra":"","zip":null,"town":null} {"rowid":"392","nom":"TEKNI-PLI","tva_intra":"","zip":null,"town":null} {"rowid":"397","nom":"Ulbrich Suzana Ltd","tva_intra":"","zip":null,"town":null} -- 14 lignes === S1 assiette 0% suspecte === {"ht_0pct":"14626.71"} -- 1 lignes