{"id":27896,"date":"2020-02-27T10:38:40","date_gmt":"2020-02-27T10:38:40","guid":{"rendered":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/?p=27896"},"modified":"2024-05-03T05:09:33","modified_gmt":"2024-05-03T05:09:33","slug":"how-to-upgrade-sage-300-custom-module-from-data-activation-using-datalevel-2","status":"publish","type":"post","link":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2020\/02\/27\/how-to-upgrade-sage-300-custom-module-from-data-activation-using-datalevel-2\/","title":{"rendered":"How to upgrade Sage 300 custom module from Data Activation using DataLevel"},"content":{"rendered":"\n

Sage 300 development partner over the years have developed custom modules in Sage 300. Based on the requirement changes development partner makes the necessary changes to module, but sometimes these changes are made after the module is already deployed in the live environment and the user has started using the module. So to deploy the changes if at the database level we cannot deactivate and activate the module. This will cause data lose. <\/p>\n\n\n\n

New Stuff: <\/strong> How to make NFR Copy or Trial Copy of Sage 300 custom module<\/a><\/p>\n\n\n\n

When custom modules require changes at the database level such as (Adding new column\/ Changing the existing column length, etc.). Here we have 2 options to apply the changes to the company by either providing an upgrade screen or once the latest files are installed the module re-appears in Sage 300 Data Activation screen. <\/p>\n\n\n\n

Upgrade\nwith separate screen:<\/strong><\/p>\n\n\n\n

Below\nis an example of \u201cGreytrix Document Attachment \uf0e0\nUpgrade\/Deactivate UI\u201d screen with \u201cUpgrade\u201d button that allow\nto apply the changes. \n<\/p>\n\n\n\n

In this case, if the user skips the step to click the Upgrade button, the screens using the data source of the changed view will crash. <\/p>\n\n\n\n

\"Upgrade\"<\/a><\/figure>\n\n\n\n

Upgrade\nusing Data Activation screen:<\/strong><\/p>\n\n\n\n

Data Activation provides the guarantee that the custom module cannot be used unless the new changes are applied. Using this method, we ensure that the module is first activated and then available for use. When the module appears in the Data Activation screen, it disappears from the sage 300 desktop until reactivated.<\/p>\n\n\n\n

Technically, Sage 300 SDK provides module visibility with the \u201cDataLevel\u201d mentioned in the \u201c.ini\u201d file of the project folder and the Data Level entry present in the CSAPP table for the particular module. When a mismatch is found, the module moves from the sage 300 desktop to the activation screen.<\/p>\n\n\n\n

A\nsnippet of code of our custom module \u201cGreytrix Document Attachment\u201d\nwhich may help the developer to make use of this functionality:<\/p>\n\n\n\n

Step\n1: Locating the INI file of the module<\/strong><\/p>\n\n\n\n

Generally,\ncustom module is created at path \u201cC:\\Dev\\GD\\…\u201d as per the\nmanual provided from the Sage.<\/p>\n\n\n\n

Developer\nwill be able to locate the INI file \u201cGD.INI\u201d file under\n\u201cC:\\Dev\\GD\\source\\project\\\u201d.<\/p>\n\n\n\n

Step\n2: Adding the code for changing the DataLevel<\/strong><\/p>\n\n\n\n

    \n
  1. Open GD.ini file in edit mode and search for section \u201c[General]\u201d. <\/li>\n\n\n\n
  2. Increment the Data Level value. If current value is 0, then make it 1. <\/li>\n<\/ol>\n\n\n\n
    \"Data<\/a><\/center>\n\n\n\n
      \n
    1. Open GDINIT1.c in edit mode and search for \u201cApp.wDataLevel\u201d. <\/li>\n\n\n\n
    2. Increment the value. If App.wDataLevel = 0 then make it App.wDataLevel = 1. <\/li>\n<\/ol>\n\n\n\n
      \"<\/a><\/center>\n\n\n\n

      Step\n3: Adding the files to the ERP.<\/strong><\/p>\n\n\n\n

        \n
      1. After the code is added, to the INI file, make the project and INIT view. The newly generated file can be found at path \u201cC:\\Dev\\GD\\build32\\runtime\\\u201d <\/li>\n\n\n\n
      2. Copy the all the recently updated files from the runtime folder and paste it in the Sage 300 Programs directory under GD67A folder. <\/li>\n\n\n\n
      3. When Sage 300 company is logged in, below message is displayed. <\/li>\n<\/ol>\n\n\n\n
        \"Sage<\/a><\/center>\n\n\n\n

        4. The message pops every time the company is login until the module is reactivated. <\/p>\n\n\n\n

        Upgrade from Data Activation reduces the changes of crashing when there are changes in the custom module which are not yet applied for the selected company.<\/p>\n\n\n\n

        About Us<\/strong><\/span><\/p>\n\n\n\n

        Greytrix<\/a> a globally recognized Premier Sage Gold Development Partner is a one stop solution provider for Sage ERP and Sage CRM needs. Being recognized 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 expertise.<\/p>\n\n\n\n

        Greytrix<\/a> helps in Sage ERP\nand CRM upgrades to the latest version and migration for Sage Intacct from\nSage 300, Sage 100, Sage 50 and QuickBooks<\/a>; for Sage\n100, Sage 300 (Sage Accpac), Sage Enterprise Management (Sage X3) from Sage Pro<\/a>, Sage 50 US<\/a>, Sage 50 CA<\/a>, Sage 50 Usage\nBusiness Works, Sage Business Vision<\/a> and QuickBooks<\/a>; for\nSage CRM from Salesforce | ACT! |\nSalesLogix | Goldmine | Sugar CRM | Maximizer<\/a><\/p>\n\n\n\n

        For more information on Sage ERP \u2013 CRM migration solutions, please contact us at erpmig@greytrix.com<\/a>. We will be glad to assist you.<\/p>\n","protected":false},"excerpt":{"rendered":"

        Sage 300 development partner over the years have developed custom modules in Sage 300. Based on the requirement changes development partner makes the necessary changes to module, but sometimes these changes are made after the module is already deployed in the live environment and the user has started using the module. So to deploy the\u2026 Read More »<\/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":[2],"tags":[637,3413,3417,2357,2429,3414,3416,3418,3415,3419],"class_list":["post-27896","post","type-post","status-publish","format-standard","hentry","category-sage-accpac","tag-custom-module","tag-datalevel","tag-module-upgrade","tag-sage-300-erp","tag-sage-300c","tag-upgrade","tag-upgrade-sage-300-custom-module","tag-upgrade-sage-300-custom-module-from-data-activation","tag-upgrade-sage-300-module","tag-upgrade-using-datalevel"],"yoast_head":"\nHow to Upgrade the Sage 300 Custom Module with Data Level<\/title>\n<meta name=\"description\" content=\"Discover when custom modules necessitate database-level modifications like adding\/changing column length.\" \/>\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\/sageaccpacerp\/2020\/02\/27\/how-to-upgrade-sage-300-custom-module-from-data-activation-using-datalevel-2\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"How to Upgrade the Sage 300 Custom Module with Data Level\" \/>\n<meta property=\"og:description\" content=\"Discover when custom modules necessitate database-level modifications like adding\/changing column length.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2020\/02\/27\/how-to-upgrade-sage-300-custom-module-from-data-activation-using-datalevel-2\/\" \/>\n<meta property=\"og:site_name\" content=\"Sage 300 ERP \u2013 Tips, Tricks and Components\" \/>\n<meta property=\"article:published_time\" content=\"2020-02-27T10:38:40+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-05-03T05:09:33+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2020\/02\/1-1.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=\"4 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2020\/02\/27\/how-to-upgrade-sage-300-custom-module-from-data-activation-using-datalevel-2\/\",\"url\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2020\/02\/27\/how-to-upgrade-sage-300-custom-module-from-data-activation-using-datalevel-2\/\",\"name\":\"How to Upgrade the Sage 300 Custom Module with Data Level\",\"isPartOf\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2020\/02\/27\/how-to-upgrade-sage-300-custom-module-from-data-activation-using-datalevel-2\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2020\/02\/27\/how-to-upgrade-sage-300-custom-module-from-data-activation-using-datalevel-2\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2020\/02\/1-1.png\",\"datePublished\":\"2020-02-27T10:38:40+00:00\",\"dateModified\":\"2024-05-03T05:09:33+00:00\",\"author\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/#\/schema\/person\/93977cd8aa8fbd1f151d3f664e29c9f2\"},\"description\":\"Discover when custom modules necessitate database-level modifications like adding\/changing column length.\",\"breadcrumb\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2020\/02\/27\/how-to-upgrade-sage-300-custom-module-from-data-activation-using-datalevel-2\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2020\/02\/27\/how-to-upgrade-sage-300-custom-module-from-data-activation-using-datalevel-2\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2020\/02\/27\/how-to-upgrade-sage-300-custom-module-from-data-activation-using-datalevel-2\/#primaryimage\",\"url\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2020\/02\/1-1.png\",\"contentUrl\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2020\/02\/1-1.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2020\/02\/27\/how-to-upgrade-sage-300-custom-module-from-data-activation-using-datalevel-2\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"How to upgrade Sage 300 custom module from Data Activation using DataLevel\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/#website\",\"url\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/\",\"name\":\"Sage 300 ERP \u2013 Tips, Tricks and Components\",\"description\":\"Explore the world of Sage 300 with our insightful blogs, expert tips, and the latest updates. We\u2019ll empower you to leverage Sage 300 to its fullest potential. As your one-stop partner, Greytrix delivers exceptional solutions and integrations for Sage 300. Our blogs extend our support to businesses, covering the latest insights and trends. Dive in and transform your Sage 300 experience with us! \",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/?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\/sageaccpacerp\/#\/schema\/person\/93977cd8aa8fbd1f151d3f664e29c9f2\",\"name\":\"Greytrix\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/#\/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\/sageaccpacerp\/author\/greytrix\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"How to Upgrade the Sage 300 Custom Module with Data Level","description":"Discover when custom modules necessitate database-level modifications like adding\/changing column length.","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\/sageaccpacerp\/2020\/02\/27\/how-to-upgrade-sage-300-custom-module-from-data-activation-using-datalevel-2\/","og_locale":"en_US","og_type":"article","og_title":"How to Upgrade the Sage 300 Custom Module with Data Level","og_description":"Discover when custom modules necessitate database-level modifications like adding\/changing column length.","og_url":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2020\/02\/27\/how-to-upgrade-sage-300-custom-module-from-data-activation-using-datalevel-2\/","og_site_name":"Sage 300 ERP \u2013 Tips, Tricks and Components","article_published_time":"2020-02-27T10:38:40+00:00","article_modified_time":"2024-05-03T05:09:33+00:00","og_image":[{"url":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2020\/02\/1-1.png","type":"","width":"","height":""}],"author":"Greytrix","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Greytrix","Est. reading time":"4 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2020\/02\/27\/how-to-upgrade-sage-300-custom-module-from-data-activation-using-datalevel-2\/","url":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2020\/02\/27\/how-to-upgrade-sage-300-custom-module-from-data-activation-using-datalevel-2\/","name":"How to Upgrade the Sage 300 Custom Module with Data Level","isPartOf":{"@id":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2020\/02\/27\/how-to-upgrade-sage-300-custom-module-from-data-activation-using-datalevel-2\/#primaryimage"},"image":{"@id":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2020\/02\/27\/how-to-upgrade-sage-300-custom-module-from-data-activation-using-datalevel-2\/#primaryimage"},"thumbnailUrl":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2020\/02\/1-1.png","datePublished":"2020-02-27T10:38:40+00:00","dateModified":"2024-05-03T05:09:33+00:00","author":{"@id":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/#\/schema\/person\/93977cd8aa8fbd1f151d3f664e29c9f2"},"description":"Discover when custom modules necessitate database-level modifications like adding\/changing column length.","breadcrumb":{"@id":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2020\/02\/27\/how-to-upgrade-sage-300-custom-module-from-data-activation-using-datalevel-2\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2020\/02\/27\/how-to-upgrade-sage-300-custom-module-from-data-activation-using-datalevel-2\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2020\/02\/27\/how-to-upgrade-sage-300-custom-module-from-data-activation-using-datalevel-2\/#primaryimage","url":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2020\/02\/1-1.png","contentUrl":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2020\/02\/1-1.png"},{"@type":"BreadcrumbList","@id":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2020\/02\/27\/how-to-upgrade-sage-300-custom-module-from-data-activation-using-datalevel-2\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/"},{"@type":"ListItem","position":2,"name":"How to upgrade Sage 300 custom module from Data Activation using DataLevel"}]},{"@type":"WebSite","@id":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/#website","url":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/","name":"Sage 300 ERP \u2013 Tips, Tricks and Components","description":"Explore the world of Sage 300 with our insightful blogs, expert tips, and the latest updates. We\u2019ll empower you to leverage Sage 300 to its fullest potential. As your one-stop partner, Greytrix delivers exceptional solutions and integrations for Sage 300. Our blogs extend our support to businesses, covering the latest insights and trends. Dive in and transform your Sage 300 experience with us! ","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/?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\/sageaccpacerp\/#\/schema\/person\/93977cd8aa8fbd1f151d3f664e29c9f2","name":"Greytrix","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/#\/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\/sageaccpacerp\/author\/greytrix\/"}]}},"_links":{"self":[{"href":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-json\/wp\/v2\/posts\/27896","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-json\/wp\/v2\/comments?post=27896"}],"version-history":[{"count":7,"href":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-json\/wp\/v2\/posts\/27896\/revisions"}],"predecessor-version":[{"id":34446,"href":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-json\/wp\/v2\/posts\/27896\/revisions\/34446"}],"wp:attachment":[{"href":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-json\/wp\/v2\/media?parent=27896"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-json\/wp\/v2\/categories?post=27896"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-json\/wp\/v2\/tags?post=27896"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}