{"id":6750,"date":"2017-01-22T12:15:40","date_gmt":"2017-01-22T11:15:40","guid":{"rendered":"https:\/\/www.auditsi.eu\/?p=6750"},"modified":"2018-01-06T12:26:04","modified_gmt":"2018-01-06T11:26:04","slug":"format-dimport-decritures-comptables-dcsnet","status":"publish","type":"post","link":"https:\/\/www.auditsi.eu\/?p=6750","title":{"rendered":"Format du fichier d&#8217;importation d&#8217;\u00e9critures comptables DCSnet"},"content":{"rendered":"<p style=\"text-align: justify;\">L&#8217;importation d&#8217;\u00e9critures dans les syst\u00e8mes comptables offre des gains de productivit\u00e9 en\u00a0\u00e9vitant de ressaisir manuellement des donn\u00e9es qui existent d\u00e9j\u00e0 sous forme informatique. Il en est ainsi par exemple des \u00e9critures de paye, d&#8217;amortissement ou encore de situation mensuelle.<\/p>\n<p style=\"text-align: justify;\">Le module comptabilit\u00e9 du\u00a0<a href=\"https:\/\/www.auditsi.eu\/?tag=dms\">DMS<\/a> DCSnet (\u00e9dit\u00e9 par Reynolds &amp; Reynolds) permet d&#8217;importer des \u00e9critures comptables.<\/p>\n<p style=\"text-align: justify;\"><a href=\"https:\/\/www.auditsi.eu\/?attachment_id=6762\" rel=\"attachment wp-att-6762\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-6762\" src=\"https:\/\/www.auditsi.eu\/wp-content\/uploads\/2017\/01\/Import-DCS.png\" alt=\"Ecritures comptables sous Excel pr\u00eates \u00e0 importer dans DCSnet\" width=\"904\" height=\"280\" srcset=\"https:\/\/www.auditsi.eu\/wp-content\/uploads\/2017\/01\/Import-DCS.png 904w, https:\/\/www.auditsi.eu\/wp-content\/uploads\/2017\/01\/Import-DCS-300x93.png 300w, https:\/\/www.auditsi.eu\/wp-content\/uploads\/2017\/01\/Import-DCS-768x238.png 768w, https:\/\/www.auditsi.eu\/wp-content\/uploads\/2017\/01\/Import-DCS-730x226.png 730w\" sizes=\"auto, (max-width: 904px) 100vw, 904px\" \/><\/a><\/p>\n<p style=\"text-align: justify;\">Le fichier d&#8217;\u00e9critures \u00e0 importer (au <a href=\"https:\/\/www.auditsi.eu\/?tag=csv\">format CSV<\/a>) dans DCSnet doit comprendre les colonnes suivantes :<\/p>\n<ul>\n<li>DATE_ECRIT : date d&#8217;\u00e9criture<\/li>\n<li>PIECE : r\u00e9f\u00e9rence pi\u00e8ce<\/li>\n<li>COMPTE : num\u00e9ro de compte<\/li>\n<li>DOC<\/li>\n<li>Z_POINT : r\u00e9f\u00e9rence de pointage<\/li>\n<li>LIBELLE : libell\u00e9 d&#8217;\u00e9criture<\/li>\n<li>C_REG : code r\u00e8glement<\/li>\n<li>DATE_ECH : date d&#8217;\u00e9ch\u00e9ance<\/li>\n<li>SENS : sens d&#8217;\u00e9criture (D : D\u00e9bit, C : Cr\u00e9dit)<\/li>\n<li>MONTANT : montant<\/li>\n<li>TVA : code TVA (0 si pas de TVA)<\/li>\n<\/ul>\n<p style=\"text-align: justify;\">Contraintes :<\/p>\n<p><a href=\"https:\/\/www.auditsi.eu\/?attachment_id=7107\" rel=\"attachment wp-att-7107\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-7107\" src=\"https:\/\/www.auditsi.eu\/wp-content\/uploads\/2017\/01\/DCSnet-contraintes-importations.png\" alt=\"DCSnet contraintes importations\" width=\"790\" height=\"346\" srcset=\"https:\/\/www.auditsi.eu\/wp-content\/uploads\/2017\/01\/DCSnet-contraintes-importations.png 790w, https:\/\/www.auditsi.eu\/wp-content\/uploads\/2017\/01\/DCSnet-contraintes-importations-300x131.png 300w, https:\/\/www.auditsi.eu\/wp-content\/uploads\/2017\/01\/DCSnet-contraintes-importations-768x336.png 768w, https:\/\/www.auditsi.eu\/wp-content\/uploads\/2017\/01\/DCSnet-contraintes-importations-730x320.png 730w\" sizes=\"auto, (max-width: 790px) 100vw, 790px\" \/><\/a><\/p>\n<p style=\"text-align: justify;\">Le code journal est saisi manuellement par l&#8217;utilisateur lors de l&#8217;importation du fichier d&#8217;\u00e9critures dans DCSnet (ce qui ne permet pas d&#8217;importer d&#8217;\u00e9critures comptables mouvementant plusieurs journaux en une seule op\u00e9ration d&#8217;importation).<\/p>\n<p style=\"text-align: justify;\">Les ent\u00eates de colonne figurent obligatoirement en premi\u00e8re ligne du fichier texte \u00e0 l&#8217;image de cet exemple :<\/p>\n<p style=\"text-align: justify;\"><a href=\"https:\/\/www.auditsi.eu\/?attachment_id=6751\" rel=\"attachment wp-att-6751\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-6751\" src=\"https:\/\/www.auditsi.eu\/wp-content\/uploads\/2017\/01\/Import-DCS-CSV.png\" alt=\"Fichier \u00e9critures comptables au format CSV \u00e0 importer dans DCSnet\" width=\"664\" height=\"270\" srcset=\"https:\/\/www.auditsi.eu\/wp-content\/uploads\/2017\/01\/Import-DCS-CSV.png 664w, https:\/\/www.auditsi.eu\/wp-content\/uploads\/2017\/01\/Import-DCS-CSV-300x122.png 300w\" sizes=\"auto, (max-width: 664px) 100vw, 664px\" \/><\/a><\/p>\n<p style=\"text-align: justify;\">Notons au passage que le s\u00e9parateur de donn\u00e9es d&#8217;un fichier au <a href=\"https:\/\/www.auditsi.eu\/?tag=csv\">format CSV<\/a> (pour <em>Comma Separated Value<\/em>)\u00a0est g\u00e9n\u00e9ralement en France le point virgule (;) alors que le format am\u00e9ricain retient la virgule. L&#8217;<a href=\"https:\/\/www.auditsi.eu\/?p=6387\">enregistrement d&#8217;un tableau de donn\u00e9es au format CSV<\/a> \u00e0 partir de la version fran\u00e7aise Excel utilise donc\u00a0le point virgule comme s\u00e9parateur de donn\u00e9es, ce qui n&#8217;est pas le cas \u00e0 partir d&#8217;une macro VBA qui utilise par d\u00e9faut le s\u00e9parateur am\u00e9ricain (,) avec la commande <a href=\"https:\/\/www.auditsi.eu\/?s=saveas\"><em>.SaveAs<\/em><\/a> :<\/p>\n<pre class=\"lang:default decode:true\">ActiveWorkbook.SaveAs Filename:=s, FileFormat:=xlCSV, CreateBackup:=False<\/pre>\n<p style=\"text-align: justify;\">Pour rem\u00e9dier \u00e0 cette difficult\u00e9, il suffit d&#8217;ajouter l&#8217;assertion <em>Local:=True<\/em> \u00e0 la fin de la commande <em>.SaveAs<\/em> :<\/p>\n<pre class=\"lang:default decode:true\">ActiveWorkbook.SaveAs Filename:=s, FileFormat:=xlCSV, CreateBackup:=False, local:=True<\/pre>\n<p style=\"text-align: justify;\">DCSnet refusera syst\u00e9matiquement tout fichier qui ne comprendra pas le nom des ent\u00eates de colonne en premi\u00e8re ligne et le point virgule comme s\u00e9parateur de donn\u00e9es.<\/p>\n<p style=\"text-align: justify;\">___<\/p>\n<p>Tous les articles en rapport avec la <a href=\"http:\/\/www.auditsi.eu\/?tag=conversion-de-fichier\">conversion de fichier<\/a> \/ <a href=\"https:\/\/www.auditsi.eu\/?tag=dcsnet\">DCSnet<\/a><\/p>\n<p>Approfondir le sujet : <a title=\"Programmer en VBA\" href=\"http:\/\/www.auditsi.eu\/?cat=1569\">Programmer en VBA<\/a> \/ <a title=\"S\u00e9rie d'articles Ma\u00eetriser Excel\" href=\"http:\/\/www.auditsi.eu\/?p=4475\">D\u00e9couvrir la s\u00e9rie d\u2019articles Ma\u00eetriser Excel<\/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=\"Format%20du%20fichier%20d%27importation%20d%27%C3%A9critures%20comptables%20DCSnet\";<\/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 les syst\u00e8mes comptables offre des gains de productivit\u00e9 en\u00a0\u00e9vitant de ressaisir manuellement des donn\u00e9es qui existent d\u00e9j\u00e0 sous forme informatique. Il en est ainsi par exemple des \u00e9critures de paye, d&#8217;amortissement ou encore de situation mensuelle. Le module comptabilit\u00e9 du\u00a0DMS DCSnet (\u00e9dit\u00e9 par Reynolds &amp; Reynolds) permet d&#8217;importer des \u00e9critures comptables. Le &#8230;<\/p>\n<p><a href=\"https:\/\/www.auditsi.eu\/?p=6750\" class=\"more-link\">Continue reading &lsquo;Format du fichier d&#8217;importation d&#8217;\u00e9critures comptables DCSnet&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=\"Format%20du%20fichier%20d%27importation%20d%27%C3%A9critures%20comptables%20DCSnet\";<\/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":[544,8],"tags":[1680,1791,308,939,1789,1691,1633,986,1894,985,1790,1793,723,1641,1792,1682],"class_list":["post-6750","post","type-post","status-publish","format-standard","hentry","category-distribution-automobile-secteurs-dactivite","category-extractions-de-donnees","tag-saveas","tag-comma-separated-value","tag-conversion-de-fichier","tag-csv","tag-dcsnet","tag-ecritures-comptables","tag-excel","tag-fichier-texte","tag-importation-decritures-comptables","tag-importation-de-donnees","tag-localtrue","tag-point-virgule","tag-productivite","tag-vba","tag-virgule","tag-xlcsv"],"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\/6750","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=6750"}],"version-history":[{"count":12,"href":"https:\/\/www.auditsi.eu\/index.php?rest_route=\/wp\/v2\/posts\/6750\/revisions"}],"predecessor-version":[{"id":7108,"href":"https:\/\/www.auditsi.eu\/index.php?rest_route=\/wp\/v2\/posts\/6750\/revisions\/7108"}],"wp:attachment":[{"href":"https:\/\/www.auditsi.eu\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=6750"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.auditsi.eu\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=6750"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.auditsi.eu\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=6750"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}