{"id":12672,"date":"2024-12-30T00:21:13","date_gmt":"2024-12-29T23:21:13","guid":{"rendered":"https:\/\/www.auditsi.eu\/?p=12672"},"modified":"2024-12-30T00:21:13","modified_gmt":"2024-12-29T23:21:13","slug":"projet-ixp-v1-21beta-controles-de-coherences-et-gestion-multifec","status":"publish","type":"post","link":"https:\/\/www.auditsi.eu\/?p=12672","title":{"rendered":"Projet IXP (v1.21beta) : contr\u00f4les de coh\u00e9rences et gestion MULTIFEC"},"content":{"rendered":"<p style=\"text-align: justify;\">Quelques nouvelles des fonctions impl\u00e9ment\u00e9es ces derniers jours.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-12674\" src=\"https:\/\/www.auditsi.eu\/wp-content\/uploads\/2024\/12\/E258.png\" alt=\"E258_CAISSE_SLDQUOTID\" width=\"992\" height=\"398\" srcset=\"https:\/\/www.auditsi.eu\/wp-content\/uploads\/2024\/12\/E258.png 992w, https:\/\/www.auditsi.eu\/wp-content\/uploads\/2024\/12\/E258-300x120.png 300w, https:\/\/www.auditsi.eu\/wp-content\/uploads\/2024\/12\/E258-768x308.png 768w, https:\/\/www.auditsi.eu\/wp-content\/uploads\/2024\/12\/E258-730x293.png 730w\" sizes=\"auto, (max-width: 992px) 100vw, 992px\" \/><\/p>\n<p style=\"text-align: justify;\">Tout d&#8217;abord, j&#8217;ai commenc\u00e9 \u00e0 int\u00e9grer des <strong>contr\u00f4les de coh\u00e9rence<\/strong> (par cycle comptable), au premier rang desquels l&#8217;analyse des <strong>soldes de caisse quotidiens<\/strong>. L&#8217;objectif \u00e9tant de d\u00e9tecter les <strong>soldes cr\u00e9diteurs<\/strong> r\u00e9v\u00e9lateurs d&#8217;anomalies dans le suivi des flux d&#8217;esp\u00e8ces voire de malversations.<\/p>\n<p style=\"text-align: justify;\">De nombreux autres contr\u00f4les doivent suivre.<\/p>\n<p style=\"text-align: justify;\">Deuxi\u00e8me sujet de d\u00e9veloppement, la <strong>gestion MULTIFEC<\/strong> qui permet maintenant la mise \u00e0 jour de bases de FEC multi-soci\u00e9t\u00e9s ou multi-p\u00e9riodes.<\/p>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"generic\">\u00a7 -----------------------------------------------------------------------\r\n\u00a7  EXEMPLE MISE A JOUR BASE MULTIFEC\r\n\u00a7  29\/12\/2024 B. RIVIERE, www.auditsi.eu\r\n\u00a7 -----------------------------------------------------------------------\r\n\r\n\u00a7 Cette expression charge un fichier MULTIFEC\r\n\u00a7 et met \u00e0 jour l'un des FEC d\u00e9sign\u00e9 par l'utilisateur\r\n\r\n\u00a7 Supprime tous les FEC charg\u00e9s en m\u00e9moire\r\nFEC_LIBERERTOUT[]:\r\n\u00a7 Charge le fichier MULTIFEC d\u00e9sign\u00e9 par l'utilisateur\r\nFEC_SELECT[\"\"]:DRC[nom_MULTIFEC]:\r\nMULTIFEC_CHARGER[nom_MULTIFEC]:\r\n\u00a7 Demande \u00e0 l'utilisateur de s\u00e9lectionner un FEC\r\nFEC_SELECT[\"\"]:DRC[chemin_FEC]:\r\n\u00a7 Calcul du n\u00b0 SIREN \u00e0 partir du nom du FEC\r\nGAUCHE[DROITE[chemin_FEC;24];9]:DRC[SIREN]:\r\n\u00a7 Calcul date cl\u00f4ture AAAAMM \u00e0 partir du nom du FEC\r\nGAUCHE[DROITE[chemin_FEC;12];6]:DRC[AAAAMM]:\r\n\u00a7 Supprime FEC pr\u00e9existant le cas \u00e9ch\u00e9ant\r\nFEC_LIBERER[SIREN;AAAAMM]:\r\n\u00a7 Charge le FEC\r\nFEC_CHARGER[chemin_FEC;\"\"]:\r\n\u00a7 Exporte le fichier MULTIFEC \u00e0 jour\r\nFEC_EXPORT[nom_MULTIFEC]<\/pre>\n<p style=\"text-align: justify;\">___<\/p>\n<p style=\"text-align: justify;\">Le&nbsp;<a href=\"https:\/\/www.auditsi.eu\/?page_id=12603\"><strong>projet IXP<\/strong><\/a>&nbsp;est dot\u00e9 de nombreuses&nbsp;<strong>fonctions de calculs<\/strong>&nbsp;(langage d\u2019expression LIXP) qui portent sur des sujets vari\u00e9s qu\u2019un r\u00e9viseur ou auditeur comptable retrouve dans son quotidien : reconstitution d\u2019\u00e9ch\u00e9ancier d\u2019emprunt, calcul de RSP (r\u00e9serve sp\u00e9ciale de participation) avec prise en compte du forfait social, pourcentage d\u2019int\u00e9r\u00eat (y compris avec participation crois\u00e9e sur la consolidante) et analyse des comptes de soci\u00e9t\u00e9s \u00e0 partir du FEC (fusion de FEC, diff\u00e9rence de versions entre deux FEC, requ\u00eates SQL sur FEC, analyse de la TVA\u2026).<\/p>\n<div id=\"sconnect-is-installed\" style=\"display: none; text-align: justify;\">2.13.0.0<\/div>\n<div id=\"sconnect-is-installed\" style=\"display: none; text-align: justify;\">2.13.0.0<\/div>\n<div id=\"sconnect-is-installed\" style=\"display: none;\">2.13.0.0<\/div>\n<div id=\"sconnect-is-installed\" style=\"display: none;\">2.13.0.0<\/div>\n<div style=\"padding-bottom:20px; padding-top:10px;\" class=\"hupso-share-buttons\"><!-- Hupso Share Buttons - https:\/\/www.hupso.com\/share\/ --><a class=\"hupso_counters\" href=\"https:\/\/www.hupso.com\/share\/\"><img decoding=\"async\" src=\"https:\/\/static.hupso.com\/share\/buttons\/lang\/fr\/share-small.png\" style=\"border:0px; padding-top:2px; float:left;\" alt=\"Share Button\"\/><\/a><script type=\"text\/javascript\">var hupso_services_c=new Array(\"twitter\",\"facebook_like\",\"facebook_send\",\"email\",\"print\",\"linkedin\");var hupso_counters_lang = \"fr_FR\";var hupso_image_folder_url = \"\";var hupso_twitter_via=\"BenoitRiviere14\";var hupso_url_c=\"\";var hupso_title_c=\"Projet%20IXP%20%28v1.21beta%29%20%3A%20contr%C3%B4les%20de%20coh%C3%A9rences%20et%20gestion%20MULTIFEC\";<\/script><script type=\"text\/javascript\" src=\"https:\/\/static.hupso.com\/share\/js\/counters.js\"><\/script><!-- Hupso Share Buttons --><\/div>","protected":false},"excerpt":{"rendered":"<p>Quelques nouvelles des fonctions impl\u00e9ment\u00e9es ces derniers jours. Tout d&#8217;abord, j&#8217;ai commenc\u00e9 \u00e0 int\u00e9grer des contr\u00f4les de coh\u00e9rence (par cycle comptable), au premier rang desquels l&#8217;analyse des soldes de caisse quotidiens. L&#8217;objectif \u00e9tant de d\u00e9tecter les soldes cr\u00e9diteurs r\u00e9v\u00e9lateurs d&#8217;anomalies dans le suivi des flux d&#8217;esp\u00e8ces voire de malversations. De nombreux autres contr\u00f4les doivent suivre. &#8230;<\/p>\n<p><a href=\"https:\/\/www.auditsi.eu\/?p=12672\" class=\"more-link\">Continue reading &lsquo;Projet IXP (v1.21beta) : contr\u00f4les de coh\u00e9rences et gestion MULTIFEC&rsquo; &raquo;<\/a><\/p>\n<div style=\"padding-bottom:20px; padding-top:10px;\" class=\"hupso-share-buttons\"><!-- Hupso Share Buttons - https:\/\/www.hupso.com\/share\/ --><a class=\"hupso_counters\" href=\"https:\/\/www.hupso.com\/share\/\"><img src=\"https:\/\/static.hupso.com\/share\/buttons\/lang\/fr\/share-small.png\" style=\"border:0px; padding-top:2px; float:left;\" alt=\"Share Button\"\/><\/a><script type=\"text\/javascript\">var hupso_services_c=new Array(\"twitter\",\"facebook_like\",\"facebook_send\",\"email\",\"print\",\"linkedin\");var hupso_counters_lang = \"fr_FR\";var hupso_image_folder_url = \"\";var hupso_twitter_via=\"BenoitRiviere14\";var hupso_url_c=\"\";var hupso_title_c=\"Projet%20IXP%20%28v1.21beta%29%20%3A%20contr%C3%B4les%20de%20coh%C3%A9rences%20et%20gestion%20MULTIFEC\";<\/script><script type=\"text\/javascript\" src=\"https:\/\/static.hupso.com\/share\/js\/counters.js\"><\/script><!-- Hupso Share Buttons --><\/div>","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"advanced_seo_description":"","jetpack_seo_html_title":"","jetpack_seo_noindex":false,"ngg_post_thumbnail":0,"_jetpack_memberships_contains_paid_content":false,"footnotes":"","_links_to":"","_links_to_target":""},"categories":[50,304,3292,3291,49],"tags":[166,2314,2318,2329,523,168,1890,169,1210,1211,1621,358,3294,3295,3297,2317,1643],"class_list":["post-12672","post","type-post","status-publish","format-standard","hentry","category-audit-de-donnees","category-cycle-tresorerie","category-ixp","category-lixp","category-logiciels-daudit","tag-analyse-de-donnees","tag-caisse","tag-caisse-creditrice","tag-caisse-negative","tag-controle-de-coherence","tag-detection-des-anomalies","tag-detournement-de-fonds","tag-exception-a-des-regles","tag-fec","tag-fichier-des-ecritures-comptables","tag-fraude","tag-irregularites-comptables","tag-ixp","tag-lixp","tag-multifec","tag-solde-progressif","tag-sql"],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"jetpack_likes_enabled":false,"_links":{"self":[{"href":"https:\/\/www.auditsi.eu\/index.php?rest_route=\/wp\/v2\/posts\/12672","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.auditsi.eu\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.auditsi.eu\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.auditsi.eu\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.auditsi.eu\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=12672"}],"version-history":[{"count":4,"href":"https:\/\/www.auditsi.eu\/index.php?rest_route=\/wp\/v2\/posts\/12672\/revisions"}],"predecessor-version":[{"id":12677,"href":"https:\/\/www.auditsi.eu\/index.php?rest_route=\/wp\/v2\/posts\/12672\/revisions\/12677"}],"wp:attachment":[{"href":"https:\/\/www.auditsi.eu\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=12672"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.auditsi.eu\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=12672"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.auditsi.eu\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=12672"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}