{"id":17517,"date":"2018-01-15T05:09:02","date_gmt":"2018-01-15T05:09:02","guid":{"rendered":"http:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/?p=17517"},"modified":"2024-03-26T05:37:15","modified_gmt":"2024-03-26T05:37:15","slug":"adding-code-to-avoid-drill-down-issues-in-sage-300-customization-screens","status":"publish","type":"post","link":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2018\/01\/15\/adding-code-to-avoid-drill-down-issues-in-sage-300-customization-screens\/","title":{"rendered":"Adding Code to avoid Drill down issues in Sage 300 Customization Screens"},"content":{"rendered":"

Here we come up with the new fixture of Customization in Sage 300, while we customize the standard screens of Sage 300 as per our customer requirements without harming the standard functionality of Sage 300<\/a>.
\nNew Stuff:<\/strong>–\u00a0Validate Item with defined combination of Vendor & Item on Purchase Order<\/a>
\nAs we deploy our customized screen we will encounter the drill down issue if we don\u2019t add the proper solution to our code.
\nFor e.g.: The below screenshot is of PO Receipt Entry in which we are not facing any issue and the customization is running properly.
\n\"\"<\/a>
\nAfter creating the above entry, we can open the PO Generated Batch<\/strong> from the other screen also through drill down or you can refer the below screenshot.
\n\"\"<\/a>
\nHere you can see all the GRN Entries are getting populated in the single screen and when you click the drill down button (which is in the right side of Entry Number Finder) then the blank screen appears of the respective GRN Screen. You can see the below screenshot of the same.
\n\"\"<\/a>
\nTo avoid the blank screen we need to add some code to populate proper data if the drill down is clicked from any other screens in Accpac so that the end user should not face this type of problems.
\nYou have to add the below code in your customization to avoid drill down the issue.
\nCode:<\/u><\/strong>
\n\u2018*********************************
\nPublic Sub AccpacIC3410UICtrl1_BeforeUIAppOpened ()
\nOn Error GoTo ERRHANDLER
\nAccpacIC3410UICtrl1.ServerName = ServerName
\nAccpacIC3410UICtrl1.SessionID = SessionID
\nAccpacIC3410UICtrl1.ObjectHandle = ObjectHandle
\nExit Sub
\nERRHANDLER:
\n\u2018Insert error handling code below
\nMsgBox “Unexpected error in: AccpacIC3410UICtrl1
\n|AccpacIC3410UICtrl1_BeforeUIAppOpened” & vbCrLf & _
\n“Error #” & Err. Number & “: ” & Err.Description, _VbCritical + vbOKOnly, App.Title
\nEnd Sub
\n\u2018*********************************
\nAfter adding the above code the drill down issue is solved and the system will open the respective PO selected when we click the drill down button. You can refer the below screenshot for the same.
\n\"\"<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"

Here we come up with the new fixture of Customization in Sage 300, while we customize the standard screens of Sage 300 as per our customer requirements without harming the standard functionality of Sage 300. New Stuff:–\u00a0Validate Item with defined combination of Vendor & Item on Purchase Order As we deploy our customized screen we\u2026 Read More »<\/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":[2],"tags":[471,817,818,2708],"class_list":["post-17517","post","type-post","status-publish","format-standard","hentry","category-sage-accpac","tag-code-to-solve-drill-down-issue-in-accpac-300","tag-drill-down","tag-drill-down-issue","tag-solution-for-solving-drill-down-issue"],"yoast_head":"\nAdding code to eliminate drill down difficulties in Sage 300 customization screens.<\/title>\n<meta name=\"description\" content=\"If we do not include the appropriate solution in our code, we will meet the drill down issue when deploying our customized screen.\" \/>\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\/2018\/01\/15\/adding-code-to-avoid-drill-down-issues-in-sage-300-customization-screens\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Adding code to eliminate drill down difficulties in Sage 300 customization screens.\" \/>\n<meta property=\"og:description\" content=\"If we do not include the appropriate solution in our code, we will meet the drill down issue when deploying our customized screen.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2018\/01\/15\/adding-code-to-avoid-drill-down-issues-in-sage-300-customization-screens\/\" \/>\n<meta property=\"og:site_name\" content=\"Sage 300 ERP \u2013 Tips, Tricks and Components\" \/>\n<meta property=\"article:published_time\" content=\"2018-01-15T05:09:02+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-03-26T05:37:15+00:00\" \/>\n<meta property=\"og:image\" content=\"http:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2018\/01\/5.png\" \/>\n<meta name=\"author\" content=\"sage300\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"sage300\" \/>\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\/sageaccpacerp\/2018\/01\/15\/adding-code-to-avoid-drill-down-issues-in-sage-300-customization-screens\/\",\"url\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2018\/01\/15\/adding-code-to-avoid-drill-down-issues-in-sage-300-customization-screens\/\",\"name\":\"Adding code to eliminate drill down difficulties in Sage 300 customization screens.\",\"isPartOf\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2018\/01\/15\/adding-code-to-avoid-drill-down-issues-in-sage-300-customization-screens\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2018\/01\/15\/adding-code-to-avoid-drill-down-issues-in-sage-300-customization-screens\/#primaryimage\"},\"thumbnailUrl\":\"http:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2018\/01\/5.png\",\"datePublished\":\"2018-01-15T05:09:02+00:00\",\"dateModified\":\"2024-03-26T05:37:15+00:00\",\"author\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/#\/schema\/person\/1aced4e22c30ccf606960de27c9542f5\"},\"description\":\"If we do not include the appropriate solution in our code, we will meet the drill down issue when deploying our customized screen.\",\"breadcrumb\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2018\/01\/15\/adding-code-to-avoid-drill-down-issues-in-sage-300-customization-screens\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2018\/01\/15\/adding-code-to-avoid-drill-down-issues-in-sage-300-customization-screens\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2018\/01\/15\/adding-code-to-avoid-drill-down-issues-in-sage-300-customization-screens\/#primaryimage\",\"url\":\"http:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2018\/01\/5.png\",\"contentUrl\":\"http:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2018\/01\/5.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2018\/01\/15\/adding-code-to-avoid-drill-down-issues-in-sage-300-customization-screens\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Adding Code to avoid Drill down issues in Sage 300 Customization Screens\"}]},{\"@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\/1aced4e22c30ccf606960de27c9542f5\",\"name\":\"sage300\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/#\/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\":\"sage300\"},\"url\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/author\/sageaccpac\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Adding code to eliminate drill down difficulties in Sage 300 customization screens.","description":"If we do not include the appropriate solution in our code, we will meet the drill down issue when deploying our customized screen.","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\/2018\/01\/15\/adding-code-to-avoid-drill-down-issues-in-sage-300-customization-screens\/","og_locale":"en_US","og_type":"article","og_title":"Adding code to eliminate drill down difficulties in Sage 300 customization screens.","og_description":"If we do not include the appropriate solution in our code, we will meet the drill down issue when deploying our customized screen.","og_url":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2018\/01\/15\/adding-code-to-avoid-drill-down-issues-in-sage-300-customization-screens\/","og_site_name":"Sage 300 ERP \u2013 Tips, Tricks and Components","article_published_time":"2018-01-15T05:09:02+00:00","article_modified_time":"2024-03-26T05:37:15+00:00","og_image":[{"url":"http:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2018\/01\/5.png","type":"","width":"","height":""}],"author":"sage300","twitter_card":"summary_large_image","twitter_misc":{"Written by":"sage300","Est. reading time":"3 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2018\/01\/15\/adding-code-to-avoid-drill-down-issues-in-sage-300-customization-screens\/","url":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2018\/01\/15\/adding-code-to-avoid-drill-down-issues-in-sage-300-customization-screens\/","name":"Adding code to eliminate drill down difficulties in Sage 300 customization screens.","isPartOf":{"@id":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2018\/01\/15\/adding-code-to-avoid-drill-down-issues-in-sage-300-customization-screens\/#primaryimage"},"image":{"@id":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2018\/01\/15\/adding-code-to-avoid-drill-down-issues-in-sage-300-customization-screens\/#primaryimage"},"thumbnailUrl":"http:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2018\/01\/5.png","datePublished":"2018-01-15T05:09:02+00:00","dateModified":"2024-03-26T05:37:15+00:00","author":{"@id":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/#\/schema\/person\/1aced4e22c30ccf606960de27c9542f5"},"description":"If we do not include the appropriate solution in our code, we will meet the drill down issue when deploying our customized screen.","breadcrumb":{"@id":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2018\/01\/15\/adding-code-to-avoid-drill-down-issues-in-sage-300-customization-screens\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2018\/01\/15\/adding-code-to-avoid-drill-down-issues-in-sage-300-customization-screens\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2018\/01\/15\/adding-code-to-avoid-drill-down-issues-in-sage-300-customization-screens\/#primaryimage","url":"http:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2018\/01\/5.png","contentUrl":"http:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2018\/01\/5.png"},{"@type":"BreadcrumbList","@id":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2018\/01\/15\/adding-code-to-avoid-drill-down-issues-in-sage-300-customization-screens\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/"},{"@type":"ListItem","position":2,"name":"Adding Code to avoid Drill down issues in Sage 300 Customization Screens"}]},{"@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\/1aced4e22c30ccf606960de27c9542f5","name":"sage300","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/#\/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":"sage300"},"url":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/author\/sageaccpac\/"}]}},"_links":{"self":[{"href":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-json\/wp\/v2\/posts\/17517","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\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-json\/wp\/v2\/comments?post=17517"}],"version-history":[{"count":2,"href":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-json\/wp\/v2\/posts\/17517\/revisions"}],"predecessor-version":[{"id":33944,"href":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-json\/wp\/v2\/posts\/17517\/revisions\/33944"}],"wp:attachment":[{"href":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-json\/wp\/v2\/media?parent=17517"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-json\/wp\/v2\/categories?post=17517"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-json\/wp\/v2\/tags?post=17517"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}