{"id":7307,"date":"2018-01-07T20:38:49","date_gmt":"2018-01-07T19:38:49","guid":{"rendered":"https:\/\/www.auditsi.eu\/?p=7307"},"modified":"2018-01-07T20:38:49","modified_gmt":"2018-01-07T19:38:49","slug":"importer-des-ecritures-dans-un-systeme-comptable","status":"publish","type":"post","link":"https:\/\/www.auditsi.eu\/?p=7307","title":{"rendered":"Importer des \u00e9critures dans un syst\u00e8me comptable"},"content":{"rendered":"<p style=\"text-align: justify;\">L&#8217;importation d&#8217;\u00e9critures dans la comptabilit\u00e9 assure des gains de productivit\u00e9 et \u00e9vite les erreurs de saisie. Dans un groupe de soci\u00e9t\u00e9s, l&#8217;importation des op\u00e9rations d&#8217;achats chez la soci\u00e9t\u00e9 acheteuse assure la correcte r\u00e9ciprocit\u00e9 en montant mais aussi en date avec la soci\u00e9t\u00e9 vendeuse.<\/p>\n<p><a href=\"https:\/\/www.auditsi.eu\/?attachment_id=7274\" rel=\"attachment wp-att-7274\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-7274\" src=\"https:\/\/www.auditsi.eu\/wp-content\/uploads\/2018\/01\/Achats-chez-la-m\u00e8re.png\" alt=\"Achats chez la m\u00e8re\" width=\"825\" height=\"141\" srcset=\"https:\/\/www.auditsi.eu\/wp-content\/uploads\/2018\/01\/Achats-chez-la-m\u00e8re.png 825w, https:\/\/www.auditsi.eu\/wp-content\/uploads\/2018\/01\/Achats-chez-la-m\u00e8re-300x51.png 300w, https:\/\/www.auditsi.eu\/wp-content\/uploads\/2018\/01\/Achats-chez-la-m\u00e8re-768x131.png 768w, https:\/\/www.auditsi.eu\/wp-content\/uploads\/2018\/01\/Achats-chez-la-m\u00e8re-730x125.png 730w\" sizes=\"auto, (max-width: 825px) 100vw, 825px\" \/><\/a><\/p>\n<p style=\"text-align: justify;\">La r\u00e9ussite des op\u00e9rations d&#8217;importation\u00a0d&#8217;\u00e9critures\u00a0s&#8217;appuie le suivi\u00a0d&#8217;\u00e9tapes incontournables : validation de la conformit\u00e9 des donn\u00e9es \u00e0 importer, cr\u00e9ation de journaux comptables sp\u00e9cifiques, param\u00e9trage de l&#8217;importation dans le syst\u00e8me comptable.<\/p>\n<p style=\"text-align: justify;\">La validation de\u00a0la conformit\u00e9\u00a0des donn\u00e9es\u00a0\u00e0 importer avec la structure de donn\u00e9es attendue par le syst\u00e8me comptable\u00a0constitue la premi\u00e8re \u00e9tape :<\/p>\n<ul>\n<li style=\"text-align: justify;\">existence des comptes g\u00e9n\u00e9raux, des codes tiers,\u00a0des codes journaux,<\/li>\n<li style=\"text-align: justify;\">dates des \u00e9critures comptables \u00e0 importer conformes avec les\u00a0p\u00e9riodes comptables ouvertes dans le syst\u00e8me,<\/li>\n<li style=\"text-align: justify;\">conformit\u00e9 des formats de donn\u00e9es : d\u00e9cimales, formats des dates (jj\/mm\/aaaa, jjmmaa&#8230;), longueurs des num\u00e9ros de compte&#8230;<\/li>\n<\/ul>\n<p style=\"text-align: justify;\">L&#8217;\u00e9tape de validation\u00a0prend en compte\u00a0bien entendu\u00a0les contraintes de donn\u00e9es impos\u00e9es\u00a0par la r\u00e9glementation en vigueur (notamment avec les prescriptions sur la pr\u00e9sentation du <a href=\"https:\/\/www.auditsi.eu\/?tag=fec\">FEC<\/a>). Par exemple, la pr\u00e9sence d&#8217;un num\u00e9ro de pi\u00e8ce comptable est imp\u00e9rative quelle que soit la nature de l&#8217;\u00e9criture (achat, vente, OD&#8230;) afin d&#8217;assurer la tra\u00e7abilit\u00e9.<\/p>\n<p style=\"text-align: justify;\">M\u00eame si aucune prescription l\u00e9gale ne l&#8217;impose, il appara\u00eet n\u00e9cessaire de cr\u00e9er\u00a0des journaux comptables sp\u00e9cifiques aux \u00e9critures import\u00e9es pour chacune des interfaces (il en est ainsi par exemple pour les \u00e9critures import\u00e9es depuis la paye, la gestion commerciale, le logiciel de gestion des immobilisations&#8230;) afin de faciliter les op\u00e9rations de contr\u00f4le d&#8217;int\u00e9gration de donn\u00e9es (rapprochement entre les donn\u00e9es\u00a0d&#8217;origine et les donn\u00e9es int\u00e9gr\u00e9es dans le journal comptable).<\/p>\n<p style=\"text-align: justify;\">L&#8217;int\u00e9gration de donn\u00e9es dans un syst\u00e8me comptable n\u00e9cessite la cr\u00e9ation d&#8217;un format d&#8217;importation des \u00e9critures comptables afin de permettre au syst\u00e8me comptable d&#8217;int\u00e9grer les \u00e9critures. Deux \u00e9l\u00e9ments sont \u00e0 param\u00e9trer : les champs de donn\u00e9es et le format du fichier (au format texte).<\/p>\n<p style=\"text-align: justify;\">Concernant les champs de donn\u00e9es, il s&#8217;agit de champs classiques d\u00e9crivant des \u00e9critures comptables, soit\u00a0\u00e0 minima\u00a0: date d&#8217;\u00e9criture, code journal, compte g\u00e9n\u00e9ral, libell\u00e9 d&#8217;\u00e9criture, d\u00e9bit\/cr\u00e9dit ou solde, r\u00e9f\u00e9rence pi\u00e8ce comptable. D&#8217;autres champs pourront utilement \u00eatre cr\u00e9\u00e9s, comme la date d&#8217;\u00e9ch\u00e9ance pour des factures d&#8217;achat.<\/p>\n<div id=\"attachment_7262\" style=\"width: 645px\" class=\"wp-caption aligncenter\"><a href=\"https:\/\/www.auditsi.eu\/?attachment_id=7262\" rel=\"attachment wp-att-7262\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-7262\" class=\"size-full wp-image-7262\" src=\"https:\/\/www.auditsi.eu\/wp-content\/uploads\/2018\/01\/SAGE100-Import-param\u00e9trable-1.png\" alt=\"D\u00e9finition des champs \u00e0 importer dans SAGE 100 Comptabilit\u00e9 i7\" width=\"635\" height=\"621\" srcset=\"https:\/\/www.auditsi.eu\/wp-content\/uploads\/2018\/01\/SAGE100-Import-param\u00e9trable-1.png 635w, https:\/\/www.auditsi.eu\/wp-content\/uploads\/2018\/01\/SAGE100-Import-param\u00e9trable-1-300x293.png 300w\" sizes=\"auto, (max-width: 635px) 100vw, 635px\" \/><\/a><p id=\"caption-attachment-7262\" class=\"wp-caption-text\">D\u00e9finition des champs \u00e0 importer dans SAGE 100 Comptabilit\u00e9 i7<\/p><\/div>\n<p style=\"text-align: justify;\">Concernant le format de fichier, il en existe de deux sortes d\u00e9limit\u00e9s ou fixes (ce sujet est abord\u00e9 <a href=\"https:\/\/www.auditsi.eu\/?p=1732\">ici<\/a>).\u00a0Quel que soit le format retenu (d\u00e9termin\u00e9 en fonction des\u00a0caract\u00e9ristiques du syst\u00e8me informatique),\u00a0diff\u00e9rents\u00a0param\u00e8tres sont \u00e0 d\u00e9finir :\u00a0d\u00e9limiteur de champ (pour le cas d&#8217;un fichier texte d\u00e9limit\u00e9), mat\u00e9rialisation de la d\u00e9cimale, format des dates&#8230;<\/p>\n<div id=\"attachment_7264\" style=\"width: 603px\" class=\"wp-caption aligncenter\"><a href=\"https:\/\/www.auditsi.eu\/?attachment_id=7264\" rel=\"attachment wp-att-7264\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-7264\" class=\"size-full wp-image-7264\" src=\"https:\/\/www.auditsi.eu\/wp-content\/uploads\/2018\/01\/SAGE100-Import-param\u00e9trable-2.png\" alt=\"D\u00e9finition du format de fichier \u00e0 importer dans SAGE 100 Comptabilit\u00e9 i7\" width=\"593\" height=\"505\" srcset=\"https:\/\/www.auditsi.eu\/wp-content\/uploads\/2018\/01\/SAGE100-Import-param\u00e9trable-2.png 593w, https:\/\/www.auditsi.eu\/wp-content\/uploads\/2018\/01\/SAGE100-Import-param\u00e9trable-2-300x255.png 300w\" sizes=\"auto, (max-width: 593px) 100vw, 593px\" \/><\/a><p id=\"caption-attachment-7264\" class=\"wp-caption-text\">D\u00e9finition du format de fichier \u00e0 importer dans SAGE 100 Comptabilit\u00e9 i7<\/p><\/div>\n<p style=\"text-align: justify;\">&#8212;<\/p>\n<p style=\"text-align: justify;\">Approfondir le sujet :\u00a0 <a href=\"https:\/\/www.auditsi.eu\/?tag=importation-decritures-comptables\">importation d&#8217;\u00e9critures comptables<\/a> \/ <a href=\"https:\/\/www.auditsi.eu\/?tag=importation-de-donnees\">importation de donn\u00e9es<\/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 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=\"Importer%20des%20%C3%A9critures%20dans%20un%20syst%C3%A8me%20comptable\";<\/script><script type=\"text\/javascript\" src=\"https:\/\/static.hupso.com\/share\/js\/counters.js\"><\/script><!-- Hupso Share Buttons --><\/div>","protected":false},"excerpt":{"rendered":"<p>L&#8217;importation d&#8217;\u00e9critures dans la comptabilit\u00e9 assure des gains de productivit\u00e9 et \u00e9vite les erreurs de saisie. Dans un groupe de soci\u00e9t\u00e9s, l&#8217;importation des op\u00e9rations d&#8217;achats chez la soci\u00e9t\u00e9 acheteuse assure la correcte r\u00e9ciprocit\u00e9 en montant mais aussi en date avec la soci\u00e9t\u00e9 vendeuse. La r\u00e9ussite des op\u00e9rations d&#8217;importation\u00a0d&#8217;\u00e9critures\u00a0s&#8217;appuie le suivi\u00a0d&#8217;\u00e9tapes incontournables : validation de la &#8230;<\/p>\n<p><a href=\"https:\/\/www.auditsi.eu\/?p=7307\" class=\"more-link\">Continue reading &lsquo;Importer des \u00e9critures dans un syst\u00e8me comptable&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=\"Importer%20des%20%C3%A9critures%20dans%20un%20syst%C3%A8me%20comptable\";<\/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":[7],"tags":[1894,1071,1895],"class_list":["post-7307","post","type-post","status-publish","format-standard","hentry","category-breves","tag-importation-decritures-comptables","tag-reciprocites","tag-systeme"],"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\/7307","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=7307"}],"version-history":[{"count":7,"href":"https:\/\/www.auditsi.eu\/index.php?rest_route=\/wp\/v2\/posts\/7307\/revisions"}],"predecessor-version":[{"id":7315,"href":"https:\/\/www.auditsi.eu\/index.php?rest_route=\/wp\/v2\/posts\/7307\/revisions\/7315"}],"wp:attachment":[{"href":"https:\/\/www.auditsi.eu\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=7307"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.auditsi.eu\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=7307"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.auditsi.eu\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=7307"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}