{"id":1582,"date":"2017-09-22T07:22:57","date_gmt":"2017-09-22T07:22:57","guid":{"rendered":"http:\/\/www.greytrix.com\/blogs\/sagemas\/?p=1582"},"modified":"2025-06-05T11:03:11","modified_gmt":"2025-06-05T11:03:11","slug":"data-import-manager-in-mas-500","status":"publish","type":"post","link":"https:\/\/www.greytrix.com\/blogs\/sagemas\/2017\/09\/22\/data-import-manager-in-mas-500\/","title":{"rendered":"Data Import Manager Module in Sage 500 ERP"},"content":{"rendered":"<p style=\"text-align: justify;\">Data Import Manager is a unique module in Sage 500 ERP (formerly known as MAS 500). Using this tool, users can easily import data from a source of application like XLS, CSV and XML file.<\/p>\n<p style=\"text-align: justify;\"><em><strong>New Stuff<\/strong><\/em>:\u00a0<a href=\"http:\/\/www.greytrix.com\/blogs\/sagemas\/2017\/09\/12\/credit-and-rebill-functionality-on-posted-invoice-in-sage-500\/\" target=\"_blank\" rel=\"noopener\">Credit and Rebill functionality on Posted invoice in Sage 500<\/a><\/p>\n<p>Data Import Manager workflow can be divided into three categories:<\/p>\n<ul>\n<li>Maintain Source Connection<\/li>\n<li>Maintain Import Job<\/li>\n<li>Process Import Job<\/li>\n<\/ul>\n<p style=\"text-align: justify;\"><a href=\"https:\/\/www.greytrix.com\/blogs\/sagemas\/wp-content\/uploads\/2017\/09\/Image1-2-1.jpg\"><img fetchpriority=\"high\" decoding=\"async\" class=\"aligncenter wp-image-1583 size-full\" src=\"https:\/\/www.greytrix.com\/blogs\/sagemas\/wp-content\/uploads\/2017\/09\/Image1-2-1.jpg\" alt=\"workflow diagram\" width=\"519\" height=\"223\" \/><\/a><strong>1. Maintain Source connection:\u00a0 <\/strong><\/p>\n<p style=\"text-align: justify;\">Maintain Source Connection defines the connection and source tables from source data to Sage 500 ERP databases. This connection is used at runtime to connect to a data source and import the data into Sage 500 ERP tables. The screenshot below displays where the users can define the source connection details.<\/p>\n<p><a href=\"https:\/\/www.greytrix.com\/blogs\/sagemas\/wp-content\/uploads\/2017\/09\/Image2-1.jpg\"><img decoding=\"async\" class=\"aligncenter\" src=\"https:\/\/www.greytrix.com\/blogs\/sagemas\/wp-content\/uploads\/2017\/09\/Image2-1.jpg\" alt=\"Maintain Source Connection\" width=\"553\" height=\"574\" \/><\/a><\/p>\n<p style=\"text-align: justify;\"><strong>2. Maintain Import Job : <\/strong><\/p>\n<p style=\"text-align: justify;\">Users can define the Source connection and Destination entity.\u00a0 A source data connection previously created in Maintain Source Connection is assigned to the import job definition.\u00a0 The Destination entity is a Sage 500 business object where users can select to import data source on that Destination.<\/p>\n<p style=\"text-align: justify;\">Once the user defines the complete information and saves into the Maintain Import job, the utility generates the SQL job in SQL Server for importing the data from source records thereby inserting into the staging table of Sage MAS 500.<\/p>\n<p><a href=\"https:\/\/www.greytrix.com\/blogs\/sagemas\/wp-content\/uploads\/2017\/09\/Image3-1.jpg\"><img decoding=\"async\" class=\"aligncenter\" src=\"https:\/\/www.greytrix.com\/blogs\/sagemas\/wp-content\/uploads\/2017\/09\/Image3-1.jpg\" alt=\"Maintain Import job\" width=\"545\" height=\"474\" \/><\/a><\/p>\n<p style=\"text-align: justify;\"><strong>3. Process Import Job task :<\/strong><\/p>\n<p style=\"text-align: justify;\">The Process Import Job is the final activity of the data import process. Process Import Job utility is used to process records based on the information provided in the \u201cMaintain Source connection\u201d and \u201cMaintain Import Job\u201d. Using this utility, users will be able to transfer records in Sage 500.<\/p>\n<p><span style=\"font-size: Medium;\"><strong>About Us<\/strong><\/span><br \/>\nGreytrix is one stop solution provider for Sage ERP and Sage CRM needs. We provide complete end-to-end assistance for your technical consultations, product customizations, data migration, system integration, third-party add-on development and implementation expertise.<\/p>\n<p><a href=\"http:\/\/www.greytrix.com\/\">Greytrix<\/a>\u00a0has some unique solutions of\u00a0<a href=\"http:\/\/www.greytrix.com\/product\/sage-crm\/gumu-sage-100-erp-integration\">Sage 100 integration with Sage CRM<\/a>,\u00a0and <a href=\"http:\/\/www.greytrix.com\/product\/sage-100-erp\/gumu-100-salesforce-integration\">Salesforce.com\u00a0<\/a> along with Sage 100 Migration from <a href=\"http:\/\/www.greytrix.com\/product\/sage-100-erp\/sage-50-us-sage-100-migration\">Sage 50 US<\/a>, <a href=\"http:\/\/www.greytrix.com\/product\/sage-100-erp\/quickbooks-sage-100-migration\">QuickBooks<\/a>, Sage Business Vision and Sage Business Works. We also offer best-in-class\u00a0<a href=\"http:\/\/www.greytrix.com\/product\/erp-development\/sage-100-erp\">Sage 100 customization and development services\u00a0<\/a>to Sage business partners, end users, and Sage PSG worldwide.<\/p>\n<p>For more details on Sage 100 Services, please contact us at\u00a0<a href=\"mailto:sage@greytrix.com\">sage@greytrix.com<\/a>. We will be glad to assist you.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Data Import Manager is a unique module in Sage 500 ERP (formerly known as MAS 500). Using this tool, users can easily import data from a source of application like XLS, CSV and XML file. New Stuff:\u00a0Credit and Rebill functionality on Posted invoice in Sage 500 Data Import Manager workflow can be divided into three\u2026 <span class=\"read-more\"><a href=\"https:\/\/www.greytrix.com\/blogs\/sagemas\/2017\/09\/22\/data-import-manager-in-mas-500\/\">Read More &raquo;<\/a><\/span><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[116],"tags":[275,276,277,315,413,431],"class_list":["post-1582","post","type-post","status-publish","format-standard","hentry","category-mas-500","tag-data-import","tag-data-import-manager-module","tag-data-import-manager-workflow","tag-import-manager","tag-sage-500-erp","tag-sage-mas-500"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v26.3 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Data Import Manager in MAS 500 ERP Overview<\/title>\n<meta name=\"description\" content=\"Discover how the Data Import Manager in MAS 500 ERP simplifies importing data. Learn key features and benefits to streamline your data management process.\" \/>\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\/2017\/09\/22\/data-import-manager-in-mas-500\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Data Import Manager in MAS 500 ERP Overview\" \/>\n<meta property=\"og:description\" content=\"Discover how the Data Import Manager in MAS 500 ERP simplifies importing data. Learn key features and benefits to streamline your data management process.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.greytrix.com\/blogs\/sagemas\/2017\/09\/22\/data-import-manager-in-mas-500\/\" \/>\n<meta property=\"og:site_name\" content=\"GUMU\u2122 Integrations \u2013 Tips, Tricks and Components\" \/>\n<meta property=\"article:published_time\" content=\"2017-09-22T07:22:57+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2025-06-05T11:03:11+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.greytrix.com\/blogs\/sagemas\/wp-content\/uploads\/2017\/09\/Image1-2-1.jpg\" \/>\n<meta name=\"author\" content=\"greysagemas\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"greysagemas\" \/>\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\/2017\/09\/22\/data-import-manager-in-mas-500\/\",\"url\":\"https:\/\/www.greytrix.com\/blogs\/sagemas\/2017\/09\/22\/data-import-manager-in-mas-500\/\",\"name\":\"Data Import Manager in MAS 500 ERP Overview\",\"isPartOf\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagemas\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagemas\/2017\/09\/22\/data-import-manager-in-mas-500\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagemas\/2017\/09\/22\/data-import-manager-in-mas-500\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.greytrix.com\/blogs\/sagemas\/wp-content\/uploads\/2017\/09\/Image1-2-1.jpg\",\"datePublished\":\"2017-09-22T07:22:57+00:00\",\"dateModified\":\"2025-06-05T11:03:11+00:00\",\"author\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagemas\/#\/schema\/person\/b57e6e3564a12ef62967850ae0416728\"},\"description\":\"Discover how the Data Import Manager in MAS 500 ERP simplifies importing data. Learn key features and benefits to streamline your data management process.\",\"breadcrumb\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagemas\/2017\/09\/22\/data-import-manager-in-mas-500\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.greytrix.com\/blogs\/sagemas\/2017\/09\/22\/data-import-manager-in-mas-500\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagemas\/2017\/09\/22\/data-import-manager-in-mas-500\/#primaryimage\",\"url\":\"https:\/\/www.greytrix.com\/blogs\/sagemas\/wp-content\/uploads\/2017\/09\/Image1-2-1.jpg\",\"contentUrl\":\"https:\/\/www.greytrix.com\/blogs\/sagemas\/wp-content\/uploads\/2017\/09\/Image1-2-1.jpg\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagemas\/2017\/09\/22\/data-import-manager-in-mas-500\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.greytrix.com\/blogs\/sagemas\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Data Import Manager Module in Sage 500 ERP\"}]},{\"@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\/b57e6e3564a12ef62967850ae0416728\",\"name\":\"greysagemas\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagemas\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/c3b4325cb326e36467f945b9b9adf2bb85e907fe092d42eb36b39743b492e626?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/c3b4325cb326e36467f945b9b9adf2bb85e907fe092d42eb36b39743b492e626?s=96&d=mm&r=g\",\"caption\":\"greysagemas\"},\"url\":\"https:\/\/www.greytrix.com\/blogs\/sagemas\/author\/greysagemas\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Data Import Manager in MAS 500 ERP Overview","description":"Discover how the Data Import Manager in MAS 500 ERP simplifies importing data. Learn key features and benefits to streamline your data management process.","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\/2017\/09\/22\/data-import-manager-in-mas-500\/","og_locale":"en_US","og_type":"article","og_title":"Data Import Manager in MAS 500 ERP Overview","og_description":"Discover how the Data Import Manager in MAS 500 ERP simplifies importing data. Learn key features and benefits to streamline your data management process.","og_url":"https:\/\/www.greytrix.com\/blogs\/sagemas\/2017\/09\/22\/data-import-manager-in-mas-500\/","og_site_name":"GUMU\u2122 Integrations \u2013 Tips, Tricks and Components","article_published_time":"2017-09-22T07:22:57+00:00","article_modified_time":"2025-06-05T11:03:11+00:00","og_image":[{"url":"https:\/\/www.greytrix.com\/blogs\/sagemas\/wp-content\/uploads\/2017\/09\/Image1-2-1.jpg","type":"","width":"","height":""}],"author":"greysagemas","twitter_card":"summary_large_image","twitter_misc":{"Written by":"greysagemas","Est. reading time":"3 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.greytrix.com\/blogs\/sagemas\/2017\/09\/22\/data-import-manager-in-mas-500\/","url":"https:\/\/www.greytrix.com\/blogs\/sagemas\/2017\/09\/22\/data-import-manager-in-mas-500\/","name":"Data Import Manager in MAS 500 ERP Overview","isPartOf":{"@id":"https:\/\/www.greytrix.com\/blogs\/sagemas\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.greytrix.com\/blogs\/sagemas\/2017\/09\/22\/data-import-manager-in-mas-500\/#primaryimage"},"image":{"@id":"https:\/\/www.greytrix.com\/blogs\/sagemas\/2017\/09\/22\/data-import-manager-in-mas-500\/#primaryimage"},"thumbnailUrl":"https:\/\/www.greytrix.com\/blogs\/sagemas\/wp-content\/uploads\/2017\/09\/Image1-2-1.jpg","datePublished":"2017-09-22T07:22:57+00:00","dateModified":"2025-06-05T11:03:11+00:00","author":{"@id":"https:\/\/www.greytrix.com\/blogs\/sagemas\/#\/schema\/person\/b57e6e3564a12ef62967850ae0416728"},"description":"Discover how the Data Import Manager in MAS 500 ERP simplifies importing data. Learn key features and benefits to streamline your data management process.","breadcrumb":{"@id":"https:\/\/www.greytrix.com\/blogs\/sagemas\/2017\/09\/22\/data-import-manager-in-mas-500\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.greytrix.com\/blogs\/sagemas\/2017\/09\/22\/data-import-manager-in-mas-500\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.greytrix.com\/blogs\/sagemas\/2017\/09\/22\/data-import-manager-in-mas-500\/#primaryimage","url":"https:\/\/www.greytrix.com\/blogs\/sagemas\/wp-content\/uploads\/2017\/09\/Image1-2-1.jpg","contentUrl":"https:\/\/www.greytrix.com\/blogs\/sagemas\/wp-content\/uploads\/2017\/09\/Image1-2-1.jpg"},{"@type":"BreadcrumbList","@id":"https:\/\/www.greytrix.com\/blogs\/sagemas\/2017\/09\/22\/data-import-manager-in-mas-500\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.greytrix.com\/blogs\/sagemas\/"},{"@type":"ListItem","position":2,"name":"Data Import Manager Module in Sage 500 ERP"}]},{"@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\/b57e6e3564a12ef62967850ae0416728","name":"greysagemas","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.greytrix.com\/blogs\/sagemas\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/c3b4325cb326e36467f945b9b9adf2bb85e907fe092d42eb36b39743b492e626?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/c3b4325cb326e36467f945b9b9adf2bb85e907fe092d42eb36b39743b492e626?s=96&d=mm&r=g","caption":"greysagemas"},"url":"https:\/\/www.greytrix.com\/blogs\/sagemas\/author\/greysagemas\/"}]}},"_links":{"self":[{"href":"https:\/\/www.greytrix.com\/blogs\/sagemas\/wp-json\/wp\/v2\/posts\/1582","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\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sagemas\/wp-json\/wp\/v2\/comments?post=1582"}],"version-history":[{"count":2,"href":"https:\/\/www.greytrix.com\/blogs\/sagemas\/wp-json\/wp\/v2\/posts\/1582\/revisions"}],"predecessor-version":[{"id":4751,"href":"https:\/\/www.greytrix.com\/blogs\/sagemas\/wp-json\/wp\/v2\/posts\/1582\/revisions\/4751"}],"wp:attachment":[{"href":"https:\/\/www.greytrix.com\/blogs\/sagemas\/wp-json\/wp\/v2\/media?parent=1582"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sagemas\/wp-json\/wp\/v2\/categories?post=1582"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sagemas\/wp-json\/wp\/v2\/tags?post=1582"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}