{"id":60,"date":"2013-01-11T07:20:00","date_gmt":"2013-01-11T07:20:00","guid":{"rendered":"http:\/\/www.greytrix.com\/blogs\/sagemas\/?p=60"},"modified":"2024-06-19T06:20:24","modified_gmt":"2024-06-19T06:20:24","slug":"data-integrity-and-optimization-tools-in-sage-100-erp","status":"publish","type":"post","link":"https:\/\/www.greytrix.com\/blogs\/sagemas\/2013\/01\/11\/data-integrity-and-optimization-tools-in-sage-100-erp\/","title":{"rendered":"Data Integrity and Optimization tools in Sage 100 ERP"},"content":{"rendered":"<p>Here in this blog, we are going to look at one more feature of Sage 100 ERP (formerly known as Sage MAS 90\/200 ERP) which helps in maintaining data accurately and optimizes the same. We can use this feature to rebuild the primary module files. Since it updates the keys of various master files, any incorrect use of it may create more data corruption issues. Hence, it is advised that this feature should be used only under the direction of an expert.<\/p>\n<p>Before we dig more into it, let us look at some below situations that can cause the data\/performance issue:<\/p>\n<ul>\n<li>Power failure.<\/li>\n<li>Improper shutdowns, such as those caused by power outages or performing a hard restart: pressing and holding the power button, and the restart button.<\/li>\n<li>Hardware problems or failures, including hard drive failures, bad sectors, bad RAM, etc.<\/li>\n<\/ul>\n<p>Though Sage 100 ERP is a very robust system, at times, due to above unknown reasons data in the system gets corrupted. We can handle the data corruption issues by using Sage 100 ERP System\u2019s inbuilt data correction features.<\/p>\n<p><strong>Integrity Check:<\/strong><\/p>\n<ol>\n<li>In this process, it scans the selected list of files for the data in-consistencies.<\/li>\n<li>During this whole process, it performs a complete validation of each record, verifies the data dictionaries, and checks for read\/write capability.<\/li>\n<li>When the process completes, a text file is launched in Notepad providing information about the integrity check.<\/li>\n<li>In case of errors, a message box appears each time to rebuild the file. All the empty required field found during the entire process are documented so that users can manually repair the file.<\/li>\n<\/ol>\n<p><strong>Optimize file:<\/strong><\/p>\n<ol>\n<li>As the name suggests, it helps in speeding up the Sage 100 look-up\/update\/ retrieval\/ traversing processes.<br \/>\nIn this, all the data is re-written into a new file. It also removes unnecessary excess empty data blocks and arranges the primary keys in alpha-numeric order.<br \/>\nA text file is launched in Notepad providing information about the file optimization.<\/li>\n<\/ol>\n<p><strong>Note:<\/strong> This feature is not provided in Sage MAS 200 ERP SQL versions.<\/p>\n<p><strong>About Us<\/strong><br \/>\n<a href=\"https:\/\/www.greytrix.com\/\">Greytrix<\/a>\u00a0is a 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 integrations, third party add-on development and implementation expertise.<\/p>\n<p>Greytrix\u00a0has some unique solutions of\u00a0<a href=\"https:\/\/www.greytrix.com\/product\/sage-crm\/gumu-sage-100-erp-integration\">Sage 100 integration with Sage CRM<\/a>,\u00a0and\u00a0<a href=\"https:\/\/www.greytrix.com\/product\/sage-100-erp\/gumu-100-salesforce-integration\">Salesforce.com<\/a>\u00a0along with\u00a0<a href=\"https:\/\/www.greytrix.com\/product\/sage-100-erp\/sage-50-us-sage-100-migration\">Sage 100 Migration from Sage 50 US<\/a>,\u00a0<a href=\"https:\/\/www.greytrix.com\/product\/intacct-apps-and-products\/gumu-sage-intacct-sage-100-migration\">Sage Intacct<\/a>,\u00a0<a href=\"https:\/\/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=\"https:\/\/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>Here in this blog, we are going to look at one more feature of Sage 100 ERP (formerly known as Sage MAS 90\/200 ERP) which helps in maintaining data accurately and optimizes the same. We can use this feature to rebuild the primary module files. Since it updates the keys of various master files, any\u2026 <span class=\"read-more\"><a href=\"https:\/\/www.greytrix.com\/blogs\/sagemas\/2013\/01\/11\/data-integrity-and-optimization-tools-in-sage-100-erp\/\">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":[61,62,166,177,187],"tags":[],"class_list":["post-60","post","type-post","status-publish","format-standard","hentry","category-data-integrity-check","category-data-optimization","category-rebuild-keys","category-sage-100-erp","category-sage-mas-90200-erp"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v26.3 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Sage 100 ERP&#039;s Data Integrity and Optimization Tools<\/title>\n<meta name=\"description\" content=\"Discover Upon completion of the process, Notepad opens a text file containing details about the integrity check.\" \/>\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\/2013\/01\/11\/data-integrity-and-optimization-tools-in-sage-100-erp\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Sage 100 ERP&#039;s Data Integrity and Optimization Tools\" \/>\n<meta property=\"og:description\" content=\"Discover Upon completion of the process, Notepad opens a text file containing details about the integrity check.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.greytrix.com\/blogs\/sagemas\/2013\/01\/11\/data-integrity-and-optimization-tools-in-sage-100-erp\/\" \/>\n<meta property=\"og:site_name\" content=\"GUMU\u2122 Integrations \u2013 Tips, Tricks and Components\" \/>\n<meta property=\"article:published_time\" content=\"2013-01-11T07:20:00+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-06-19T06:20:24+00:00\" \/>\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=\"2 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\/2013\/01\/11\/data-integrity-and-optimization-tools-in-sage-100-erp\/\",\"url\":\"https:\/\/www.greytrix.com\/blogs\/sagemas\/2013\/01\/11\/data-integrity-and-optimization-tools-in-sage-100-erp\/\",\"name\":\"Sage 100 ERP's Data Integrity and Optimization Tools\",\"isPartOf\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagemas\/#website\"},\"datePublished\":\"2013-01-11T07:20:00+00:00\",\"dateModified\":\"2024-06-19T06:20:24+00:00\",\"author\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagemas\/#\/schema\/person\/b57e6e3564a12ef62967850ae0416728\"},\"description\":\"Discover Upon completion of the process, Notepad opens a text file containing details about the integrity check.\",\"breadcrumb\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagemas\/2013\/01\/11\/data-integrity-and-optimization-tools-in-sage-100-erp\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.greytrix.com\/blogs\/sagemas\/2013\/01\/11\/data-integrity-and-optimization-tools-in-sage-100-erp\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagemas\/2013\/01\/11\/data-integrity-and-optimization-tools-in-sage-100-erp\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.greytrix.com\/blogs\/sagemas\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Data Integrity and Optimization tools in Sage 100 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":"Sage 100 ERP's Data Integrity and Optimization Tools","description":"Discover Upon completion of the process, Notepad opens a text file containing details about the integrity check.","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\/2013\/01\/11\/data-integrity-and-optimization-tools-in-sage-100-erp\/","og_locale":"en_US","og_type":"article","og_title":"Sage 100 ERP's Data Integrity and Optimization Tools","og_description":"Discover Upon completion of the process, Notepad opens a text file containing details about the integrity check.","og_url":"https:\/\/www.greytrix.com\/blogs\/sagemas\/2013\/01\/11\/data-integrity-and-optimization-tools-in-sage-100-erp\/","og_site_name":"GUMU\u2122 Integrations \u2013 Tips, Tricks and Components","article_published_time":"2013-01-11T07:20:00+00:00","article_modified_time":"2024-06-19T06:20:24+00:00","author":"greysagemas","twitter_card":"summary_large_image","twitter_misc":{"Written by":"greysagemas","Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.greytrix.com\/blogs\/sagemas\/2013\/01\/11\/data-integrity-and-optimization-tools-in-sage-100-erp\/","url":"https:\/\/www.greytrix.com\/blogs\/sagemas\/2013\/01\/11\/data-integrity-and-optimization-tools-in-sage-100-erp\/","name":"Sage 100 ERP's Data Integrity and Optimization Tools","isPartOf":{"@id":"https:\/\/www.greytrix.com\/blogs\/sagemas\/#website"},"datePublished":"2013-01-11T07:20:00+00:00","dateModified":"2024-06-19T06:20:24+00:00","author":{"@id":"https:\/\/www.greytrix.com\/blogs\/sagemas\/#\/schema\/person\/b57e6e3564a12ef62967850ae0416728"},"description":"Discover Upon completion of the process, Notepad opens a text file containing details about the integrity check.","breadcrumb":{"@id":"https:\/\/www.greytrix.com\/blogs\/sagemas\/2013\/01\/11\/data-integrity-and-optimization-tools-in-sage-100-erp\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.greytrix.com\/blogs\/sagemas\/2013\/01\/11\/data-integrity-and-optimization-tools-in-sage-100-erp\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.greytrix.com\/blogs\/sagemas\/2013\/01\/11\/data-integrity-and-optimization-tools-in-sage-100-erp\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.greytrix.com\/blogs\/sagemas\/"},{"@type":"ListItem","position":2,"name":"Data Integrity and Optimization tools in Sage 100 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\/60","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=60"}],"version-history":[{"count":2,"href":"https:\/\/www.greytrix.com\/blogs\/sagemas\/wp-json\/wp\/v2\/posts\/60\/revisions"}],"predecessor-version":[{"id":5064,"href":"https:\/\/www.greytrix.com\/blogs\/sagemas\/wp-json\/wp\/v2\/posts\/60\/revisions\/5064"}],"wp:attachment":[{"href":"https:\/\/www.greytrix.com\/blogs\/sagemas\/wp-json\/wp\/v2\/media?parent=60"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sagemas\/wp-json\/wp\/v2\/categories?post=60"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sagemas\/wp-json\/wp\/v2\/tags?post=60"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}