{"id":204,"date":"2022-06-09T11:48:37","date_gmt":"2022-06-09T11:48:37","guid":{"rendered":"https:\/\/www.greytrix.com\/blogs\/acumatica\/?p=204"},"modified":"2024-12-02T05:45:25","modified_gmt":"2024-12-02T05:45:25","slug":"add-standard-field-to-the-selector-lookup-of-acumatica","status":"publish","type":"post","link":"https:\/\/www.greytrix.com\/blogs\/acumatica\/2022\/06\/09\/add-standard-field-to-the-selector-lookup-of-acumatica\/","title":{"rendered":"Add standard field to the selector\/lookup of Acumatica"},"content":{"rendered":"\n<p>A\u00a0lookup\u00a0or a selector\u00a0control contains the data like a table or a grid which is displayed in the form of rows and columns. The data consists of the records from a table (DAC) within <a href=\"https:\/\/www.greytrix.com\/acumatica-cloud-erp\/\">Acumatica ERP<\/a> and allows the selection of a specific row. Acumatica selector control has an inbuilt filtering and sorting functionality for better user accessibility.<\/p>\n\n\n\n<p>The rows displayed in the grid area depends on the records present in a particular DAC and has fixed set of columns as specified for the core Acumatica product.<\/p>\n\n\n\n<p>Consider that we need to search a vendor, and we do not have a vendor id, but we have some other information of the Vendor. For such cases, <a href=\"https:\/\/www.greytrix.com\/acumatica-cloud-erp\/\">Acumatica<\/a> provides a selector control to search the record with various criteria and retrieve the required vendor. There are situations where the user will always have certain information shared which is not specified in a selector column, then we need a way to customize and add it have to selector control.<\/p>\n\n\n\n<p>In this blog, we will be customizing the Vendor class selector and adding a new column as a standard currency field from vendor class.<\/p>\n\n\n\n<p><strong><u>Customize the Data Field<\/u><\/strong><\/p>\n\n\n\n<p>Navigate to Payables &gt; Profiles &gt; Vendors &gt; Vendor Class selector control. Once the selector is opened, use the inspect element feature by clicking \u201cControl+Alt+Click\u201d.<\/p>\n\n\n\n<p>Customize the selector control by adding data fields on clicking actions button of element properties and select the project name in which the customization to be done.<\/p>\n\n\n<p><a href=\"https:\/\/www.greytrix.com\/blogs\/acumatica\/wp-content\/uploads\/2022\/06\/Fig-1-Inspect-element-and-customize-data-fields.png\" target=\"_blank\" rel=\"noreferrer noopener\"><img fetchpriority=\"high\" decoding=\"async\" class=\"alignnone\" style=\"border: 1px solid #A9A9A9; padding: 2px; margin: 2px; align: center;\" title=\"Fig 1 Inspect element and customize data fields\" src=\"https:\/\/www.greytrix.com\/blogs\/acumatica\/wp-content\/uploads\/2022\/06\/Fig-1-Inspect-element-and-customize-data-fields.png\" alt=\"Fig 1 Inspect element and customize data fields\" width=\"828\" height=\"355\" \/><\/a><\/p>\n\n\n<p><strong><u>Edit Selector and add new column<\/u><\/strong><\/p>\n\n\n\n<p>Click on \u201cEdit Selector Columns\u201d button on the more actions of vendor data class. On Customize selector columns wizard, click on ADD columns button to view all controls including selector and custom columns on the separate wizard. Check the column to be visible on the selector control and click on OK button.<\/p>\n\n\n<p><a href=\"https:\/\/www.greytrix.com\/blogs\/acumatica\/wp-content\/uploads\/2022\/06\/Fig-2-Edit-Selector-and-add-column-1.png\" target=\"_blank\" rel=\"noreferrer noopener\"><img decoding=\"async\" class=\"alignnone\" style=\"border: 1px solid #A9A9A9; padding: 2px; margin: 2px; align: center;\" title=\"Fig 2 Edit Selector and add column\" src=\"https:\/\/www.greytrix.com\/blogs\/acumatica\/wp-content\/uploads\/2022\/06\/Fig-2-Edit-Selector-and-add-column-1.png\" alt=\"Fig 2 Edit Selector and add column\" width=\"1052\" height=\"582\" \/><\/a><\/p>\n\n\n<p><strong><u>Save and Publish<\/u><\/strong><\/p>\n\n\n\n<p>Save the changes and publish the current project to make the changes visible on the selector control.<\/p>\n\n\n<p><a href=\"https:\/\/www.greytrix.com\/blogs\/acumatica\/wp-content\/uploads\/2022\/06\/Fig-3-Save-and-Publish-1.png\" target=\"_blank\" rel=\"noreferrer noopener\"><img decoding=\"async\" class=\"alignnone\" style=\"border: 1px solid #A9A9A9; padding: 2px; margin: 2px; align: center;\" title=\"Fig 3 Save and Publish\" src=\"https:\/\/www.greytrix.com\/blogs\/acumatica\/wp-content\/uploads\/2022\/06\/Fig-3-Save-and-Publish-1.png\" alt=\"Fig 3 Save and Publish\" width=\"664\" height=\"256\" \/><\/a><\/p>\n\n\n<p><strong><u>Standard Field added up on the selector control<\/u><\/strong><\/p>\n\n\n\n<p>Currency ID field is now added in the selector control of vendor class field.<\/p>\n\n\n<p><a href=\"https:\/\/www.greytrix.com\/blogs\/acumatica\/wp-content\/uploads\/2022\/06\/Fig-4-Currency-Id-on-selector-control.png\" target=\"_blank\" rel=\"noreferrer noopener\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone\" style=\"border: 1px solid #A9A9A9; padding: 2px; margin: 2px; align: center;\" title=\"Fig 4 Currency Id on selector control\" src=\"https:\/\/www.greytrix.com\/blogs\/acumatica\/wp-content\/uploads\/2022\/06\/Fig-4-Currency-Id-on-selector-control.png\" alt=\"Fig 4 Currency Id on selector control\" width=\"600\" height=\"402\" \/><\/a><\/p>\n<p>This is how a user can easily add a new standard field from DAC on the selector controls in <a href=\"https:\/\/www.greytrix.com\/acumatica-cloud-erp\/\">Acumatica<\/a> without having any knowledge of programming.<\/p>\n\n","protected":false},"excerpt":{"rendered":"<p>A\u00a0lookup\u00a0or a selector\u00a0control contains the data like a table or a grid which is displayed in the form of rows and columns. The data consists of the records from a table (DAC) within Acumatica ERP and allows the selection of a specific row. Acumatica selector control has an inbuilt filtering and sorting functionality for better\u2026 <span class=\"read-more\"><a href=\"https:\/\/www.greytrix.com\/blogs\/acumatica\/2022\/06\/09\/add-standard-field-to-the-selector-lookup-of-acumatica\/\">Read More &raquo;<\/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":[15,3,14],"tags":[76,75,73,72,70],"class_list":["post-204","post","type-post","status-publish","format-standard","hentry","category-acumatica-customization","category-acumatica-erp","category-acumatica-services","tag-customize-selector","tag-customize-selector-fields","tag-edit-selector","tag-lookup","tag-selector"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v26.3 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Enhance Acumatica Selector Lookup: Add Standard Field<\/title>\n<meta name=\"description\" content=\"Learn how to add standard fields to Acumatica&#039;s selector lookup efficiently for enhanced functionality.Boost your Acumatica experience today\" \/>\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\/acumatica\/2022\/06\/09\/add-standard-field-to-the-selector-lookup-of-acumatica\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Enhance Acumatica Selector Lookup: Add Standard Field\" \/>\n<meta property=\"og:description\" content=\"Learn how to add standard fields to Acumatica&#039;s selector lookup efficiently for enhanced functionality.Boost your Acumatica experience today\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.greytrix.com\/blogs\/acumatica\/2022\/06\/09\/add-standard-field-to-the-selector-lookup-of-acumatica\/\" \/>\n<meta property=\"og:site_name\" content=\"Acumatica \u2013 Tips, Tricks and Components\" \/>\n<meta property=\"article:published_time\" content=\"2022-06-09T11:48:37+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-12-02T05:45:25+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.greytrix.com\/blogs\/acumatica\/wp-content\/uploads\/2022\/06\/Fig-1-Inspect-element-and-customize-data-fields.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=\"5 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/acumatica\/2022\/06\/09\/add-standard-field-to-the-selector-lookup-of-acumatica\/\",\"url\":\"https:\/\/www.greytrix.com\/blogs\/acumatica\/2022\/06\/09\/add-standard-field-to-the-selector-lookup-of-acumatica\/\",\"name\":\"Enhance Acumatica Selector Lookup: Add Standard Field\",\"isPartOf\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/acumatica\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/acumatica\/2022\/06\/09\/add-standard-field-to-the-selector-lookup-of-acumatica\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/acumatica\/2022\/06\/09\/add-standard-field-to-the-selector-lookup-of-acumatica\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.greytrix.com\/blogs\/acumatica\/wp-content\/uploads\/2022\/06\/Fig-1-Inspect-element-and-customize-data-fields.png\",\"datePublished\":\"2022-06-09T11:48:37+00:00\",\"dateModified\":\"2024-12-02T05:45:25+00:00\",\"author\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/acumatica\/#\/schema\/person\/c49d53021d39726d820c6fd517b2c2ec\"},\"description\":\"Learn how to add standard fields to Acumatica's selector lookup efficiently for enhanced functionality.Boost your Acumatica experience today\",\"breadcrumb\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/acumatica\/2022\/06\/09\/add-standard-field-to-the-selector-lookup-of-acumatica\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.greytrix.com\/blogs\/acumatica\/2022\/06\/09\/add-standard-field-to-the-selector-lookup-of-acumatica\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/acumatica\/2022\/06\/09\/add-standard-field-to-the-selector-lookup-of-acumatica\/#primaryimage\",\"url\":\"https:\/\/www.greytrix.com\/blogs\/acumatica\/wp-content\/uploads\/2022\/06\/Fig-1-Inspect-element-and-customize-data-fields.png\",\"contentUrl\":\"https:\/\/www.greytrix.com\/blogs\/acumatica\/wp-content\/uploads\/2022\/06\/Fig-1-Inspect-element-and-customize-data-fields.png\",\"width\":828,\"height\":355},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/acumatica\/2022\/06\/09\/add-standard-field-to-the-selector-lookup-of-acumatica\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.greytrix.com\/blogs\/acumatica\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Add standard field to the selector\/lookup of Acumatica\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/acumatica\/#website\",\"url\":\"https:\/\/www.greytrix.com\/blogs\/acumatica\/\",\"name\":\"Acumatica \u2013 Tips, Tricks and Components\",\"description\":\"\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.greytrix.com\/blogs\/acumatica\/?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\/acumatica\/#\/schema\/person\/c49d53021d39726d820c6fd517b2c2ec\",\"name\":\"greytrix\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/acumatica\/#\/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\/acumatica\/author\/greytrix\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Enhance Acumatica Selector Lookup: Add Standard Field","description":"Learn how to add standard fields to Acumatica's selector lookup efficiently for enhanced functionality.Boost your Acumatica experience today","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\/acumatica\/2022\/06\/09\/add-standard-field-to-the-selector-lookup-of-acumatica\/","og_locale":"en_US","og_type":"article","og_title":"Enhance Acumatica Selector Lookup: Add Standard Field","og_description":"Learn how to add standard fields to Acumatica's selector lookup efficiently for enhanced functionality.Boost your Acumatica experience today","og_url":"https:\/\/www.greytrix.com\/blogs\/acumatica\/2022\/06\/09\/add-standard-field-to-the-selector-lookup-of-acumatica\/","og_site_name":"Acumatica \u2013 Tips, Tricks and Components","article_published_time":"2022-06-09T11:48:37+00:00","article_modified_time":"2024-12-02T05:45:25+00:00","og_image":[{"url":"https:\/\/www.greytrix.com\/blogs\/acumatica\/wp-content\/uploads\/2022\/06\/Fig-1-Inspect-element-and-customize-data-fields.png","type":"","width":"","height":""}],"author":"greytrix","twitter_card":"summary_large_image","twitter_misc":{"Written by":"greytrix","Est. reading time":"5 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.greytrix.com\/blogs\/acumatica\/2022\/06\/09\/add-standard-field-to-the-selector-lookup-of-acumatica\/","url":"https:\/\/www.greytrix.com\/blogs\/acumatica\/2022\/06\/09\/add-standard-field-to-the-selector-lookup-of-acumatica\/","name":"Enhance Acumatica Selector Lookup: Add Standard Field","isPartOf":{"@id":"https:\/\/www.greytrix.com\/blogs\/acumatica\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.greytrix.com\/blogs\/acumatica\/2022\/06\/09\/add-standard-field-to-the-selector-lookup-of-acumatica\/#primaryimage"},"image":{"@id":"https:\/\/www.greytrix.com\/blogs\/acumatica\/2022\/06\/09\/add-standard-field-to-the-selector-lookup-of-acumatica\/#primaryimage"},"thumbnailUrl":"https:\/\/www.greytrix.com\/blogs\/acumatica\/wp-content\/uploads\/2022\/06\/Fig-1-Inspect-element-and-customize-data-fields.png","datePublished":"2022-06-09T11:48:37+00:00","dateModified":"2024-12-02T05:45:25+00:00","author":{"@id":"https:\/\/www.greytrix.com\/blogs\/acumatica\/#\/schema\/person\/c49d53021d39726d820c6fd517b2c2ec"},"description":"Learn how to add standard fields to Acumatica's selector lookup efficiently for enhanced functionality.Boost your Acumatica experience today","breadcrumb":{"@id":"https:\/\/www.greytrix.com\/blogs\/acumatica\/2022\/06\/09\/add-standard-field-to-the-selector-lookup-of-acumatica\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.greytrix.com\/blogs\/acumatica\/2022\/06\/09\/add-standard-field-to-the-selector-lookup-of-acumatica\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.greytrix.com\/blogs\/acumatica\/2022\/06\/09\/add-standard-field-to-the-selector-lookup-of-acumatica\/#primaryimage","url":"https:\/\/www.greytrix.com\/blogs\/acumatica\/wp-content\/uploads\/2022\/06\/Fig-1-Inspect-element-and-customize-data-fields.png","contentUrl":"https:\/\/www.greytrix.com\/blogs\/acumatica\/wp-content\/uploads\/2022\/06\/Fig-1-Inspect-element-and-customize-data-fields.png","width":828,"height":355},{"@type":"BreadcrumbList","@id":"https:\/\/www.greytrix.com\/blogs\/acumatica\/2022\/06\/09\/add-standard-field-to-the-selector-lookup-of-acumatica\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.greytrix.com\/blogs\/acumatica\/"},{"@type":"ListItem","position":2,"name":"Add standard field to the selector\/lookup of Acumatica"}]},{"@type":"WebSite","@id":"https:\/\/www.greytrix.com\/blogs\/acumatica\/#website","url":"https:\/\/www.greytrix.com\/blogs\/acumatica\/","name":"Acumatica \u2013 Tips, Tricks and Components","description":"","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.greytrix.com\/blogs\/acumatica\/?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\/acumatica\/#\/schema\/person\/c49d53021d39726d820c6fd517b2c2ec","name":"greytrix","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.greytrix.com\/blogs\/acumatica\/#\/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\/acumatica\/author\/greytrix\/"}]}},"_links":{"self":[{"href":"https:\/\/www.greytrix.com\/blogs\/acumatica\/wp-json\/wp\/v2\/posts\/204","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.greytrix.com\/blogs\/acumatica\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.greytrix.com\/blogs\/acumatica\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/acumatica\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/acumatica\/wp-json\/wp\/v2\/comments?post=204"}],"version-history":[{"count":6,"href":"https:\/\/www.greytrix.com\/blogs\/acumatica\/wp-json\/wp\/v2\/posts\/204\/revisions"}],"predecessor-version":[{"id":3043,"href":"https:\/\/www.greytrix.com\/blogs\/acumatica\/wp-json\/wp\/v2\/posts\/204\/revisions\/3043"}],"wp:attachment":[{"href":"https:\/\/www.greytrix.com\/blogs\/acumatica\/wp-json\/wp\/v2\/media?parent=204"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/acumatica\/wp-json\/wp\/v2\/categories?post=204"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/acumatica\/wp-json\/wp\/v2\/tags?post=204"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}