{"id":21,"date":"2011-06-06T09:50:00","date_gmt":"2011-06-06T09:50:00","guid":{"rendered":"http:\/\/greytrix.com\/Blogs\/sageaccpacerp\/?p=21"},"modified":"2025-05-27T05:56:06","modified_gmt":"2025-05-27T05:56:06","slug":"adding-columns-to-the-detail-grid-of-transaction-screens","status":"publish","type":"post","link":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2011\/06\/06\/adding-columns-to-the-detail-grid-of-transaction-screens\/","title":{"rendered":"Adding columns to the detail grid of Transaction Screens in Sage 300"},"content":{"rendered":"

You must be wondering why one has to write a blog on this topic specifically when Sage has a powerful and easy to use Optional field\u2019s module which not only captures custom information on Maintenance and Transaction Screen but also Tracks the information from Originating document through GL and not to forget the capability of reporting based on Optional fields.<\/p>\n

Well though Optional field Module completely eliminates the need for customization to capture additional\/custom information, there are still few screens where we don\u2019t have the advantage of using optional fields and if a need arises to capture additional\/custom information on this screens one has no other option than customization and hence we thought to put it down in a blog<\/p>\n

Recently we did a customization where we had to add three columns to the IC Kitting Items screen (i.e. \u2018Category\u2019, \u2018Type\u2019 and \u2018Unit Price\u2019). Taking this as an example let us see how to add custom or user-defined columns to a Grid on UI of Sage Accpac ERP.
\nBelow is the original screen of the Accpac I\/C Kitting Items screen.
\n\"\"<\/a>To add three new fields to the detail grid of the I\/C Kitting Items we have to first create a Override subclass view for the detail view (i.e. ICKITD) and need to added three new columns to the view (it is assumed that you are aware of how to deal with Views in Accpac if not then you must refer to Sage Accpac SDK)<\/p>\n

With above Sub-Classing these fields get created into Database and are also a part of business logic\u2026<\/p>\n

Now to add three new columns to I\/C Kitting Items screen; we will have to customize the screen and have to add following code to the UI Opened.<\/p>\n

Private Sub ACCPACIC1550UICtrl1_OnUIAppOpened()
\nOn Error GoTo ErorHandler
\nDim lintcolumnCount As Integer
\n‘set the number of column present in the viewlist
\nlintcolumnCount = vwkTDtlList.ColumnCount
\n‘Add the category column
\nvwkTDtlList.AddColumn lintcolumnCount, “CATEGORY”, 0, “Category”, ALIGMENT_LEFT, 100, True, True, False
\n\u2018The below code is used to populate the finder against the category column. The standard
\n\u2018category finder will get populated against the column as the view ID of the category is
\n\u2018IC0120.
\nvwkTDtlList.SetFinderInfo lintcolumnCount, “IC0210”, 1
\nlintcolumnCount = vwkTDtlList.ColumnCount
\n‘Add the add unit price column
\nvwkTDtlList.AddColumn lintcolumnCount, “TYPE”, 0, “Price Type”, ALIGMENT_RIGHT, 100, True, False, False
\nvwkTDtlList.Refresh
\nlintcolumnCount = vwkTDtlList.ColumnCount
\n‘Add the add unit price coloumn
\nvwkTDtlList.AddColumn lintcolumnCount, “UNITPRICE”, 0, “Unit PricePercentage”, ALIGMENT_RIGHT, 150, True, False, False
\nvwkTDtlList.Refresh
\nExit Sub
\nErorHandler:
\nErrorHandler (“ACCPACIC1550UICtrl1_OnUIAppOpened”)
\nEnd Sub
\n<Snippet><\/p>\n

That\u2019s it, rest all is taken care by View\u2026
\nBelow is the screen shot of the newly added columns to I\/C Kitting Items screen.
\n\"\"<\/a>For any queries or more information, please drop us an email at sage@greytrix.com<\/a>.<\/b><\/p>\n

About Us<\/strong><\/span>
\nGreytrix is 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.
\nGreytrix<\/a>\u00a0has some unique solutions of\u00a0Sage 300 integration with Sage CRM,<\/a>\u00a0Salesforce.com\u00a0<\/a>and\u00a0Magento eCommerce<\/a> along with Sage 300 Migration from Sage 50 US, Sage 50 CA, Sage PRO, QuickBooks, Sage Business Vision and Sage Business Works. We also offer best-in-class\u00a0Sage 300 customization and development services<\/a>\u00a0to Sage business partners, end users, and Sage PSG worldwide.
\nFor more details on Sage 300 Services, please contact us at\u00a0accpac@greytrix.com<\/a>. We will be glad to assist you.\u00a0<\/strong><\/p>\n","protected":false},"excerpt":{"rendered":"

You must be wondering why one has to write a blog on this topic specifically when Sage has a powerful and easy to use Optional field\u2019s module which not only captures custom information on Maintenance and Transaction Screen but also Tracks the information from Originating document through GL and not to forget the capability of\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":[86,106,1150,1236,2415,2416,2889],"class_list":["post-21","post","type-post","status-publish","format-standard","hentry","category-sage-accpac","tag-accpac-i-c-kitting-items","tag-adding-columns-to-detail-grid","tag-grid-of-transaction-screens","tag-ic-kitting-items-screen","tag-sage-300-technical-assistance","tag-sage-300-technical-blogs","tag-transaction-screens-in-sage-300"],"yoast_head":"\nAdding columns to the detail grid of Transaction Screens in Sage 300<\/title>\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\/2011\/06\/06\/adding-columns-to-the-detail-grid-of-transaction-screens\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Adding columns to the detail grid of Transaction Screens in Sage 300\" \/>\n<meta property=\"og:description\" content=\"You must be wondering why one has to write a blog on this topic specifically when Sage has a powerful and easy to use Optional field\u2019s module which not only captures custom information on Maintenance and Transaction Screen but also Tracks the information from Originating document through GL and not to forget the capability of\u2026 Read More »\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2011\/06\/06\/adding-columns-to-the-detail-grid-of-transaction-screens\/\" \/>\n<meta property=\"og:site_name\" content=\"Sage 300 ERP \u2013 Tips, Tricks and Components\" \/>\n<meta property=\"article:published_time\" content=\"2011-06-06T09:50:00+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2025-05-27T05:56:06+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2011\/06\/Kitting-Item.jpg\" \/>\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\/2011\/06\/06\/adding-columns-to-the-detail-grid-of-transaction-screens\/\",\"url\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2011\/06\/06\/adding-columns-to-the-detail-grid-of-transaction-screens\/\",\"name\":\"Adding columns to the detail grid of Transaction Screens in Sage 300\",\"isPartOf\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2011\/06\/06\/adding-columns-to-the-detail-grid-of-transaction-screens\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2011\/06\/06\/adding-columns-to-the-detail-grid-of-transaction-screens\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2011\/06\/Kitting-Item.jpg\",\"datePublished\":\"2011-06-06T09:50:00+00:00\",\"dateModified\":\"2025-05-27T05:56:06+00:00\",\"author\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/#\/schema\/person\/1aced4e22c30ccf606960de27c9542f5\"},\"breadcrumb\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2011\/06\/06\/adding-columns-to-the-detail-grid-of-transaction-screens\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2011\/06\/06\/adding-columns-to-the-detail-grid-of-transaction-screens\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2011\/06\/06\/adding-columns-to-the-detail-grid-of-transaction-screens\/#primaryimage\",\"url\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2011\/06\/Kitting-Item.jpg\",\"contentUrl\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2011\/06\/Kitting-Item.jpg\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2011\/06\/06\/adding-columns-to-the-detail-grid-of-transaction-screens\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Adding columns to the detail grid of Transaction Screens in Sage 300\"}]},{\"@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 columns to the detail grid of Transaction Screens in Sage 300","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\/2011\/06\/06\/adding-columns-to-the-detail-grid-of-transaction-screens\/","og_locale":"en_US","og_type":"article","og_title":"Adding columns to the detail grid of Transaction Screens in Sage 300","og_description":"You must be wondering why one has to write a blog on this topic specifically when Sage has a powerful and easy to use Optional field\u2019s module which not only captures custom information on Maintenance and Transaction Screen but also Tracks the information from Originating document through GL and not to forget the capability of\u2026 Read More »","og_url":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2011\/06\/06\/adding-columns-to-the-detail-grid-of-transaction-screens\/","og_site_name":"Sage 300 ERP \u2013 Tips, Tricks and Components","article_published_time":"2011-06-06T09:50:00+00:00","article_modified_time":"2025-05-27T05:56:06+00:00","og_image":[{"url":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2011\/06\/Kitting-Item.jpg","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\/2011\/06\/06\/adding-columns-to-the-detail-grid-of-transaction-screens\/","url":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2011\/06\/06\/adding-columns-to-the-detail-grid-of-transaction-screens\/","name":"Adding columns to the detail grid of Transaction Screens in Sage 300","isPartOf":{"@id":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2011\/06\/06\/adding-columns-to-the-detail-grid-of-transaction-screens\/#primaryimage"},"image":{"@id":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2011\/06\/06\/adding-columns-to-the-detail-grid-of-transaction-screens\/#primaryimage"},"thumbnailUrl":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2011\/06\/Kitting-Item.jpg","datePublished":"2011-06-06T09:50:00+00:00","dateModified":"2025-05-27T05:56:06+00:00","author":{"@id":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/#\/schema\/person\/1aced4e22c30ccf606960de27c9542f5"},"breadcrumb":{"@id":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2011\/06\/06\/adding-columns-to-the-detail-grid-of-transaction-screens\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2011\/06\/06\/adding-columns-to-the-detail-grid-of-transaction-screens\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2011\/06\/06\/adding-columns-to-the-detail-grid-of-transaction-screens\/#primaryimage","url":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2011\/06\/Kitting-Item.jpg","contentUrl":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2011\/06\/Kitting-Item.jpg"},{"@type":"BreadcrumbList","@id":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2011\/06\/06\/adding-columns-to-the-detail-grid-of-transaction-screens\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/"},{"@type":"ListItem","position":2,"name":"Adding columns to the detail grid of Transaction Screens in Sage 300"}]},{"@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\/21","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=21"}],"version-history":[{"count":1,"href":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-json\/wp\/v2\/posts\/21\/revisions"}],"predecessor-version":[{"id":26328,"href":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-json\/wp\/v2\/posts\/21\/revisions\/26328"}],"wp:attachment":[{"href":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-json\/wp\/v2\/media?parent=21"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-json\/wp\/v2\/categories?post=21"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-json\/wp\/v2\/tags?post=21"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}