{"id":92,"date":"2011-09-23T07:48:27","date_gmt":"2011-09-23T07:48:27","guid":{"rendered":"http:\/\/greytrix.com\/blogs\/sageaccpacerp\/?p=92"},"modified":"2025-05-28T04:34:03","modified_gmt":"2025-05-28T04:34:03","slug":"custom-fec-field-edit-control-control-in-accpac-sdk","status":"publish","type":"post","link":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2011\/09\/23\/custom-fec-field-edit-control-control-in-accpac-sdk\/","title":{"rendered":"Custom FEC (Field Edit control) control in Accpac SDK"},"content":{"rendered":"<div style=\"text-align: left;\"><strong>Scenario:<\/strong><\/div>\n<div style=\"text-align: left;\">I am needed to design a Report User Interface; one of the parameters within the report is \u201cQuarter Selection\u201d.<\/div>\n<div style=\"text-align: left;\">As you may be aware of the Field edit control is always bound to any data source which fetches the value which are displayed within the FEC. But to my concern I don\u2019t have any such field available in my data source which will<br \/>\ndisplay the Quarters list. I am stuck; as I want this selection parameter on my Report UI and as well can\u2019t modify the Database to include this additional field. Please help me out in working out the solution.<\/div>\n<div style=\"text-align: left;\"><strong>Answer:<\/strong><\/div>\n<div style=\"text-align: left;\">We can definitely create the disconnected FEC also termed as Custom FEC control. Custom FEC provides same set of properties and methods as FEC control. Basically, custom FEC is disconnected from Data source so will not be able to<br \/>\nget the properties and method at design time, but runtime only. You can use the Custom FEC as combo box, finder, list box, Check box, date time picker etc. Just check the below screen shot you can find the drop down list for Quarter, which is nothing but the Custom FEC.<\/div>\n<div style=\"text-align: left;\"><\/div>\n<div style=\"text-align: left;\"><strong>Technical Approach:<\/strong><\/div>\n<div style=\"text-align: left;\">You need to declare that FEC control as Accpac custom control with the events. To aid an application in controlling the custom FEC data, the custom FEC raises some events. If the application wants to handle these events, the custom FEC must be declared as &#8220;WithEvents&#8221; member variable. Kindly check the below snippet of code guiding through the<br \/>\ndeclaration\/usage of the code.<\/div>\n<div style=\"text-align: left;\"><strong>Declaration:<\/strong><\/div>\n<div style=\"text-align: left;\"><em>Private WithEvents customFecRptType <\/em><\/div>\n<div style=\"text-align: left;\"><em>As AccpacCustomField<\/em><\/div>\n<div style=\"text-align: left;\"><\/div>\n<div>Private CustomPresentationStr_RptType<br \/>\nAs IAccpacCustomFieldPresentsStrings<\/div>\n<div style=\"text-align: left;\"><\/div>\n<div style=\"text-align: left;\"><strong>Code Snippet:<\/strong><\/div>\n<div style=\"text-align: left;\"><em>Set customFecRptType = New AccpacCustomField<\/em><\/div>\n<div style=\"text-align: left;\"><\/div>\n<div>With customFecRptType<\/div>\n<div>.PutSize 6<\/div>\n<div>.PutDescription &#8220;Select<br \/>\nQuarter&#8221;<\/div>\n<div>.PutPresentationType<br \/>\n(FLD_PRESENTS_LIST)<\/div>\n<div>.PutType (FLD_CHAR)<\/div>\n<div>Set customPresentationStr_RptType<br \/>\n= .PresentationStrings<\/div>\n<div>customPresentationStr_RptType.Append &#8220;1&#8221;, &#8220;Jan -Mar&#8221;<\/div>\n<div>customPresentationStr_RptType.Append &#8220;2&#8221;, &#8220;Apr -Jun&#8221;<\/div>\n<div>customPresentationStr_RptType.Append &#8220;3&#8221;, &#8220;Jul -Sep&#8221;<\/div>\n<div>customPresentationStr_RptType.Append &#8220;4&#8221;, &#8220;Oct -Dec&#8221;<\/div>\n<div>End With &#8216;with customFecRptType<\/div>\n<div style=\"text-align: left;\"><!--more-->Set fecQuarterSelector.AccpacField = customFecRptType<\/div>\n","protected":false},"excerpt":{"rendered":"<p>Scenario: I am needed to design a Report User Interface; one of the parameters within the report is \u201cQuarter Selection\u201d. As you may be aware of the Field edit control is always bound to any data source which fetches the value which are displayed within the FEC. But to my concern I don\u2019t have any\u2026 <span class=\"read-more\"><a href=\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2011\/09\/23\/custom-fec-field-edit-control-control-in-accpac-sdk\/\">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":[5,2],"tags":[2234],"class_list":["post-92","post","type-post","status-publish","format-standard","hentry","category-accpac-sdk","category-sage-accpac","tag-reports"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v26.3 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Custom FEC (Field Edit control) control in Accpac SDK<\/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\/09\/23\/custom-fec-field-edit-control-control-in-accpac-sdk\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Custom FEC (Field Edit control) control in Accpac SDK\" \/>\n<meta property=\"og:description\" content=\"Scenario: I am needed to design a Report User Interface; one of the parameters within the report is \u201cQuarter Selection\u201d. As you may be aware of the Field edit control is always bound to any data source which fetches the value which are displayed within the FEC. But to my concern I don\u2019t have any\u2026 Read More &raquo;\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2011\/09\/23\/custom-fec-field-edit-control-control-in-accpac-sdk\/\" \/>\n<meta property=\"og:site_name\" content=\"Sage 300 ERP \u2013 Tips, Tricks and Components\" \/>\n<meta property=\"article:published_time\" content=\"2011-09-23T07:48:27+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2025-05-28T04:34:03+00:00\" \/>\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=\"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\/sageaccpacerp\/2011\/09\/23\/custom-fec-field-edit-control-control-in-accpac-sdk\/\",\"url\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2011\/09\/23\/custom-fec-field-edit-control-control-in-accpac-sdk\/\",\"name\":\"Custom FEC (Field Edit control) control in Accpac SDK\",\"isPartOf\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/#website\"},\"datePublished\":\"2011-09-23T07:48:27+00:00\",\"dateModified\":\"2025-05-28T04:34:03+00:00\",\"author\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/#\/schema\/person\/1aced4e22c30ccf606960de27c9542f5\"},\"breadcrumb\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2011\/09\/23\/custom-fec-field-edit-control-control-in-accpac-sdk\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2011\/09\/23\/custom-fec-field-edit-control-control-in-accpac-sdk\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2011\/09\/23\/custom-fec-field-edit-control-control-in-accpac-sdk\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Custom FEC (Field Edit control) control in Accpac SDK\"}]},{\"@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":"Custom FEC (Field Edit control) control in Accpac SDK","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\/09\/23\/custom-fec-field-edit-control-control-in-accpac-sdk\/","og_locale":"en_US","og_type":"article","og_title":"Custom FEC (Field Edit control) control in Accpac SDK","og_description":"Scenario: I am needed to design a Report User Interface; one of the parameters within the report is \u201cQuarter Selection\u201d. As you may be aware of the Field edit control is always bound to any data source which fetches the value which are displayed within the FEC. But to my concern I don\u2019t have any\u2026 Read More &raquo;","og_url":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2011\/09\/23\/custom-fec-field-edit-control-control-in-accpac-sdk\/","og_site_name":"Sage 300 ERP \u2013 Tips, Tricks and Components","article_published_time":"2011-09-23T07:48:27+00:00","article_modified_time":"2025-05-28T04:34:03+00:00","author":"sage300","twitter_card":"summary_large_image","twitter_misc":{"Written by":"sage300","Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2011\/09\/23\/custom-fec-field-edit-control-control-in-accpac-sdk\/","url":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2011\/09\/23\/custom-fec-field-edit-control-control-in-accpac-sdk\/","name":"Custom FEC (Field Edit control) control in Accpac SDK","isPartOf":{"@id":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/#website"},"datePublished":"2011-09-23T07:48:27+00:00","dateModified":"2025-05-28T04:34:03+00:00","author":{"@id":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/#\/schema\/person\/1aced4e22c30ccf606960de27c9542f5"},"breadcrumb":{"@id":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2011\/09\/23\/custom-fec-field-edit-control-control-in-accpac-sdk\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2011\/09\/23\/custom-fec-field-edit-control-control-in-accpac-sdk\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2011\/09\/23\/custom-fec-field-edit-control-control-in-accpac-sdk\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/"},{"@type":"ListItem","position":2,"name":"Custom FEC (Field Edit control) control in Accpac SDK"}]},{"@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\/92","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=92"}],"version-history":[{"count":2,"href":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-json\/wp\/v2\/posts\/92\/revisions"}],"predecessor-version":[{"id":35701,"href":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-json\/wp\/v2\/posts\/92\/revisions\/35701"}],"wp:attachment":[{"href":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-json\/wp\/v2\/media?parent=92"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-json\/wp\/v2\/categories?post=92"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-json\/wp\/v2\/tags?post=92"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}