{"id":4283,"date":"2021-06-30T10:09:19","date_gmt":"2021-06-30T10:09:19","guid":{"rendered":"https:\/\/www.greytrix.com\/blogs\/sagemas\/?p=4283"},"modified":"2025-05-30T11:13:56","modified_gmt":"2025-05-30T11:13:56","slug":"import-ar-debit-note-entries-from-xsl-file-in-sage-500","status":"publish","type":"post","link":"https:\/\/www.greytrix.com\/blogs\/sagemas\/2021\/06\/30\/import-ar-debit-note-entries-from-xsl-file-in-sage-500\/","title":{"rendered":"Import AR Debit Note entries from XSL file in Sage 500"},"content":{"rendered":"\n<p>This is a unique utility useful when the user want to create huge number entries for AR Debit Note entries in Sage 500.<\/p>\n\n\n\n<p>In multiple companies may use the larger number of AR Debit Note transaction in every day in order to generate the financial transaction. If the client has to create a large number of AR transaction entries, it would be a time-consuming task.<\/p>\n\n\n\n<p>In order to ease the process of creating AR Debit note entries, Greytrix has been developed a utility which shall import AR Debit Note entries from data files such as XLS etc.<\/p>\n\n\n\n<p>The data file should contain all the required fields regarding the AR Debit Note entry i.e. Customer no, amount, Item number, Quantity<\/p>\n\n\n\n<ul class=\"wp-block-list\"><li>XLS File records : Customer no, amount, Item number, Quantity<\/li><\/ul>\n\n\n\n<p><strong>For example<\/strong>:&nbsp; &nbsp;&nbsp; Algar,90,Autoswitch,1<\/p>\n\n\n\n<p><strong>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <\/strong>Algar,810,Cable,1<\/p>\n\n\n\n<p>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Algar,105,Cable500,1<\/p>\n\n\n\n<p>                              Algar,10,Cable250,1<\/p>\n\n\n\n<center><a href=\"https:\/\/www.greytrix.com\/blogs\/sagemas\/wp-content\/uploads\/2021\/06\/Img1.png\" target=\"_blank\" rel=\"noreferrer noopener\"><img decoding=\"async\" class=\"size-full\" style=\"border: 1px solid #A9A9A9; padding: 2px; margin: 2px;\nalign: center;\" src=\"https:\/\/www.greytrix.com\/blogs\/sagemas\/wp-content\/uploads\/2021\/06\/Img1.png\" alt=\"Process invoice screen\"><\/a><\/center>\n\n\n\n<p>User will need to generate a new batch number, set the Posting Date, and leave Entry Type as Standard. Then user will click the browse button to select the file to be imported and click to Import AR Debit Note entries transaction from XLS files.<\/p>\n\n\n\n<p>This way user can import larger number of the AR Debit Note entries into the MAS 500 by using data file.<\/p>\n\n\n\n<p>If you feel you could be benefited from this utility or for any other form of customizations feel to contact us at <a href=\"mailto:accpac@greytrix.com\">accpac@greytrix.com<\/a><\/p>\n\n\n\n<p><span style=\"font-size: Medium;\"><strong>About Us<\/strong><\/span><\/p>\n\n\n\n<p><a rel=\"noreferrer noopener\" href=\"https:\/\/www.greytrix.com\/\" target=\"_blank\">Greytrix<\/a>\u00a0&#8211; a globally recognized and one of the oldest Sage Development Partner is a one-stop solution provider for Sage ERP and Sage CRM organizational needs. Being acknowledged and rewarded for multi-man years of experience, we bring complete end-to-end assistance for your technical consultations, product customizations, data migration, system integrations, third party add-on development and implementation competence. \u00a0<\/p>\n\n\n\n<p><a href=\"https:\/\/www.greytrix.com\/\">Greytrix<\/a> helps in upgrading Sage ERP and CRM to the latest version\nand provides migration for <a href=\"https:\/\/www.greytrix.com\/product\/professional-services\/migrate-qb-sage-erp-to-sage-intacct\">Sage\nIntacct from Sage 300, Sage 100, Sage 50 and QuickBooks<\/a>; for Sage 100, Sage 300 (Sage Accpac), Sage X3 from <a href=\"https:\/\/www.greytrix.com\/product\/sage-300-erp\/sage-pro-sage-300-migration\">Sage\nPro<\/a>, <a href=\"https:\/\/www.greytrix.com\/product\/sage-300-erp\/sage-50-us-sage-300-migration\">Sage\n50 US<\/a>, <a href=\"https:\/\/www.greytrix.com\/product\/sage-300-erp\/sage-50-ca-sage-300-migration\">Sage\n50 CA<\/a>, <a href=\"https:\/\/www.greytrix.com\/resources\/sage-erp-crm-migration.pdf\">Sage 50\nUS, Sage Business Works, Sage Business Vision<\/a> and <a href=\"https:\/\/www.greytrix.com\/product\/sage-100-erp\/quickbooks-sage-100-migration\">QuickBooks<\/a>; for Sage CRM from <a href=\"https:\/\/www.greytrix.com\/resources\/sage-erp-crm-migration.pdf\">Salesforce\n| ACT! | SalesLogix | Goldmine | Sugar CRM | Maximizer<\/a><\/p>\n\n\n\n<p>For more information on\nSage ERP \u2013 CRM migration solutions, please contact us at&nbsp;<a href=\"mailto:erpmig@greytrix.com\">erpmig@greytrix.com<\/a>.&nbsp;We will like to hear from you.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>This is a unique utility useful when the user want to create huge number entries for AR Debit Note entries in Sage 500. In multiple companies may use the larger number of AR Debit Note transaction in every day in order to generate the financial transaction. If the client has to create a large number\u2026 <span class=\"read-more\"><a href=\"https:\/\/www.greytrix.com\/blogs\/sagemas\/2021\/06\/30\/import-ar-debit-note-entries-from-xsl-file-in-sage-500\/\">Read More &raquo;<\/a><\/span><\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[180],"tags":[584,583,412,585],"class_list":["post-4283","post","type-post","status-publish","format-standard","hentry","category-sage-500-erp","tag-debit-note-entries","tag-import-ar","tag-sage-500","tag-xsl-file"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v26.3 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Import AR Debit Notes in Sage 500 from XLS File<\/title>\n<meta name=\"description\" content=\"Learn how to import AR Debit Note entries from an XLS file into Sage 500 ERP using a simple, efficient process to streamline data entry.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.greytrix.com\/blogs\/sagemas\/2021\/06\/30\/import-ar-debit-note-entries-from-xsl-file-in-sage-500\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Import AR Debit Notes in Sage 500 from XLS File\" \/>\n<meta property=\"og:description\" content=\"Learn how to import AR Debit Note entries from an XLS file into Sage 500 ERP using a simple, efficient process to streamline data entry.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.greytrix.com\/blogs\/sagemas\/2021\/06\/30\/import-ar-debit-note-entries-from-xsl-file-in-sage-500\/\" \/>\n<meta property=\"og:site_name\" content=\"GUMU\u2122 Integrations \u2013 Tips, Tricks and Components\" \/>\n<meta property=\"article:published_time\" content=\"2021-06-30T10:09:19+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2025-05-30T11:13:56+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.greytrix.com\/blogs\/sagemas\/wp-content\/uploads\/2021\/06\/Img1.png\" \/>\n<meta name=\"author\" content=\"Greytrix\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Greytrix\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"3 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagemas\/2021\/06\/30\/import-ar-debit-note-entries-from-xsl-file-in-sage-500\/\",\"url\":\"https:\/\/www.greytrix.com\/blogs\/sagemas\/2021\/06\/30\/import-ar-debit-note-entries-from-xsl-file-in-sage-500\/\",\"name\":\"Import AR Debit Notes in Sage 500 from XLS File\",\"isPartOf\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagemas\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagemas\/2021\/06\/30\/import-ar-debit-note-entries-from-xsl-file-in-sage-500\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagemas\/2021\/06\/30\/import-ar-debit-note-entries-from-xsl-file-in-sage-500\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.greytrix.com\/blogs\/sagemas\/wp-content\/uploads\/2021\/06\/Img1.png\",\"datePublished\":\"2021-06-30T10:09:19+00:00\",\"dateModified\":\"2025-05-30T11:13:56+00:00\",\"author\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagemas\/#\/schema\/person\/fd9c05a71d5918541dd32f868e89cb10\"},\"description\":\"Learn how to import AR Debit Note entries from an XLS file into Sage 500 ERP using a simple, efficient process to streamline data entry.\",\"breadcrumb\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagemas\/2021\/06\/30\/import-ar-debit-note-entries-from-xsl-file-in-sage-500\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.greytrix.com\/blogs\/sagemas\/2021\/06\/30\/import-ar-debit-note-entries-from-xsl-file-in-sage-500\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagemas\/2021\/06\/30\/import-ar-debit-note-entries-from-xsl-file-in-sage-500\/#primaryimage\",\"url\":\"https:\/\/www.greytrix.com\/blogs\/sagemas\/wp-content\/uploads\/2021\/06\/Img1.png\",\"contentUrl\":\"https:\/\/www.greytrix.com\/blogs\/sagemas\/wp-content\/uploads\/2021\/06\/Img1.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagemas\/2021\/06\/30\/import-ar-debit-note-entries-from-xsl-file-in-sage-500\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.greytrix.com\/blogs\/sagemas\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Import AR Debit Note entries from XSL file in Sage 500\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagemas\/#website\",\"url\":\"https:\/\/www.greytrix.com\/blogs\/sagemas\/\",\"name\":\"GUMU\u2122 Integrations \u2013 Tips, Tricks and Components\",\"description\":\"Welcome to the GUMU\u2122 blog, your one-stop source to gain all the insights on seamless integration solutions for ERP and CRM systems. Developed by Greytrix, GUMU\u2122 is a powerful integration platform that bridges the gap between your business applications. Whether you\u2019re looking to integrate a CRM (Salesforce, Dynamics 365 CRM, and Sage CRM) or an ERP (Sage ERP, Acumatica) with each other or any other third-party application, GUMU\u2122 is a robust and reliable integrator tailored to your unique needs. Join us as we explore the abilities of GUMU\u2122 and learn how it transforms your integration experience. \",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.greytrix.com\/blogs\/sagemas\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagemas\/#\/schema\/person\/fd9c05a71d5918541dd32f868e89cb10\",\"name\":\"Greytrix\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagemas\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/3cdb553d6ca07df0e407d5e092f2410d163e0fd40b27734b345b04c8f0786969?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/3cdb553d6ca07df0e407d5e092f2410d163e0fd40b27734b345b04c8f0786969?s=96&d=mm&r=g\",\"caption\":\"Greytrix\"},\"url\":\"https:\/\/www.greytrix.com\/blogs\/sagemas\/author\/greytrix\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Import AR Debit Notes in Sage 500 from XLS File","description":"Learn how to import AR Debit Note entries from an XLS file into Sage 500 ERP using a simple, efficient process to streamline data entry.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.greytrix.com\/blogs\/sagemas\/2021\/06\/30\/import-ar-debit-note-entries-from-xsl-file-in-sage-500\/","og_locale":"en_US","og_type":"article","og_title":"Import AR Debit Notes in Sage 500 from XLS File","og_description":"Learn how to import AR Debit Note entries from an XLS file into Sage 500 ERP using a simple, efficient process to streamline data entry.","og_url":"https:\/\/www.greytrix.com\/blogs\/sagemas\/2021\/06\/30\/import-ar-debit-note-entries-from-xsl-file-in-sage-500\/","og_site_name":"GUMU\u2122 Integrations \u2013 Tips, Tricks and Components","article_published_time":"2021-06-30T10:09:19+00:00","article_modified_time":"2025-05-30T11:13:56+00:00","og_image":[{"url":"https:\/\/www.greytrix.com\/blogs\/sagemas\/wp-content\/uploads\/2021\/06\/Img1.png","type":"","width":"","height":""}],"author":"Greytrix","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Greytrix","Est. reading time":"3 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.greytrix.com\/blogs\/sagemas\/2021\/06\/30\/import-ar-debit-note-entries-from-xsl-file-in-sage-500\/","url":"https:\/\/www.greytrix.com\/blogs\/sagemas\/2021\/06\/30\/import-ar-debit-note-entries-from-xsl-file-in-sage-500\/","name":"Import AR Debit Notes in Sage 500 from XLS File","isPartOf":{"@id":"https:\/\/www.greytrix.com\/blogs\/sagemas\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.greytrix.com\/blogs\/sagemas\/2021\/06\/30\/import-ar-debit-note-entries-from-xsl-file-in-sage-500\/#primaryimage"},"image":{"@id":"https:\/\/www.greytrix.com\/blogs\/sagemas\/2021\/06\/30\/import-ar-debit-note-entries-from-xsl-file-in-sage-500\/#primaryimage"},"thumbnailUrl":"https:\/\/www.greytrix.com\/blogs\/sagemas\/wp-content\/uploads\/2021\/06\/Img1.png","datePublished":"2021-06-30T10:09:19+00:00","dateModified":"2025-05-30T11:13:56+00:00","author":{"@id":"https:\/\/www.greytrix.com\/blogs\/sagemas\/#\/schema\/person\/fd9c05a71d5918541dd32f868e89cb10"},"description":"Learn how to import AR Debit Note entries from an XLS file into Sage 500 ERP using a simple, efficient process to streamline data entry.","breadcrumb":{"@id":"https:\/\/www.greytrix.com\/blogs\/sagemas\/2021\/06\/30\/import-ar-debit-note-entries-from-xsl-file-in-sage-500\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.greytrix.com\/blogs\/sagemas\/2021\/06\/30\/import-ar-debit-note-entries-from-xsl-file-in-sage-500\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.greytrix.com\/blogs\/sagemas\/2021\/06\/30\/import-ar-debit-note-entries-from-xsl-file-in-sage-500\/#primaryimage","url":"https:\/\/www.greytrix.com\/blogs\/sagemas\/wp-content\/uploads\/2021\/06\/Img1.png","contentUrl":"https:\/\/www.greytrix.com\/blogs\/sagemas\/wp-content\/uploads\/2021\/06\/Img1.png"},{"@type":"BreadcrumbList","@id":"https:\/\/www.greytrix.com\/blogs\/sagemas\/2021\/06\/30\/import-ar-debit-note-entries-from-xsl-file-in-sage-500\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.greytrix.com\/blogs\/sagemas\/"},{"@type":"ListItem","position":2,"name":"Import AR Debit Note entries from XSL file in Sage 500"}]},{"@type":"WebSite","@id":"https:\/\/www.greytrix.com\/blogs\/sagemas\/#website","url":"https:\/\/www.greytrix.com\/blogs\/sagemas\/","name":"GUMU\u2122 Integrations \u2013 Tips, Tricks and Components","description":"Welcome to the GUMU\u2122 blog, your one-stop source to gain all the insights on seamless integration solutions for ERP and CRM systems. Developed by Greytrix, GUMU\u2122 is a powerful integration platform that bridges the gap between your business applications. Whether you\u2019re looking to integrate a CRM (Salesforce, Dynamics 365 CRM, and Sage CRM) or an ERP (Sage ERP, Acumatica) with each other or any other third-party application, GUMU\u2122 is a robust and reliable integrator tailored to your unique needs. Join us as we explore the abilities of GUMU\u2122 and learn how it transforms your integration experience. ","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.greytrix.com\/blogs\/sagemas\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/www.greytrix.com\/blogs\/sagemas\/#\/schema\/person\/fd9c05a71d5918541dd32f868e89cb10","name":"Greytrix","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.greytrix.com\/blogs\/sagemas\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/3cdb553d6ca07df0e407d5e092f2410d163e0fd40b27734b345b04c8f0786969?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/3cdb553d6ca07df0e407d5e092f2410d163e0fd40b27734b345b04c8f0786969?s=96&d=mm&r=g","caption":"Greytrix"},"url":"https:\/\/www.greytrix.com\/blogs\/sagemas\/author\/greytrix\/"}]}},"_links":{"self":[{"href":"https:\/\/www.greytrix.com\/blogs\/sagemas\/wp-json\/wp\/v2\/posts\/4283","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.greytrix.com\/blogs\/sagemas\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.greytrix.com\/blogs\/sagemas\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sagemas\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sagemas\/wp-json\/wp\/v2\/comments?post=4283"}],"version-history":[{"count":1,"href":"https:\/\/www.greytrix.com\/blogs\/sagemas\/wp-json\/wp\/v2\/posts\/4283\/revisions"}],"predecessor-version":[{"id":4289,"href":"https:\/\/www.greytrix.com\/blogs\/sagemas\/wp-json\/wp\/v2\/posts\/4283\/revisions\/4289"}],"wp:attachment":[{"href":"https:\/\/www.greytrix.com\/blogs\/sagemas\/wp-json\/wp\/v2\/media?parent=4283"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sagemas\/wp-json\/wp\/v2\/categories?post=4283"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sagemas\/wp-json\/wp\/v2\/tags?post=4283"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}