{"id":7553,"date":"2014-05-22T11:16:06","date_gmt":"2014-05-22T11:16:06","guid":{"rendered":"http:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/?p=7553"},"modified":"2022-08-24T06:31:10","modified_gmt":"2022-08-24T06:31:10","slug":"how-to-filter-finder-based-on-optional-fields","status":"publish","type":"post","link":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2014\/05\/22\/how-to-filter-finder-based-on-optional-fields\/","title":{"rendered":"How to filter finder based on optional fields"},"content":{"rendered":"

In our previous blog, on Optional field we had discussed about the feature \u2018Validate\u2019 and \u2018Allow blank\u2019.
\nhttps:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2014\/04\/26\/validate-optional-field-in-sage-300-erp\/<\/a>
\nIn this blog, we will discuss about ability of the finder to filter based on the optional field data.
\nThe New Stuff :<\/span> <\/strong><\/em>Print picking slip after creation of OE Invoice in Sage 300<\/a>
\nSage 300 ERP allows you to store additional information which cannot be stored using standard fields related to the entity with use of optional field module. You can manage this information easily and more efficiently for analyzing business operations. The optional fields can be attached to various modules such as General Ledger Account, Customer, Vendor, Item, Transaction, which make it easier to record and track data.
\nSage 300 allows you to define unlimited number of optional fields of various data types such as Text, Amount, Date, Time, Integer, Number, and Yes\/No optional fields which you can further use in all Sage 300 modules for data tracking, filtering and reporting purpose.
\nIn this blog we will discuss how to filter standard Sage 300 finder based on the optional field values, for this we will take an example of the Item Number at OE Order entry transaction screen and filter the finder based on Item master optional field values.
\n1. You need to have the optional field module installed in Sage 300.
\n2. You need to create optional fields in Common Services–>Optional fields
\n3. Inventory Control–>IC Set up–>Optional fields–>Assign below optional fields to Item Master<\/p>\n

\"1\"<\/a><\/p>\n

4. Go to IC Item and Price Lists–>Items
\nSet value for the above optional fields for Items<\/p>\n

\"2\"<\/a><\/p>\n

5. Open the order Entry screen and create new order. When you insert the Item detail line and select Item from the finder set below criteria as shown below:<\/p>\n

\"3\"<\/a><\/p>\n

In the Item finder UI Go to Settings–>Columns
\n\"4\"<\/a><\/p>\n

Here you need to select the columns which you want for selection criteria. Here, you will select the optional field code that you need in the filtering criteria.<\/p>\n

\"6\"<\/a><\/p>\n

\"5\"<\/a><\/p>\n

\u00a0Set the Criteria for Item selection. Click on Set Criteria<\/p>\n

\"8\"<\/a><\/p>\n

Save the search Criteria to maintain the list of Optional field codes that were selected to filter the data based on the same search criteria for the future selection.<\/p>\n

Now you can see the records filtered based on the set criteria and you can select the item.<\/p>\n

\"9\"<\/a><\/p>\n

\n","protected":false},"excerpt":{"rendered":"

In our previous blog, on Optional field we had discussed about the feature \u2018Validate\u2019 and \u2018Allow blank\u2019. https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2014\/04\/26\/validate-optional-field-in-sage-300-erp\/ In this blog, we will discuss about ability of the finder to filter based on the optional field data. The New Stuff : Print picking slip after creation of OE Invoice in Sage 300 Sage 300 ERP\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":[968,985,1430,1805,1809,1817,2357],"class_list":["post-7553","post","type-post","status-publish","format-standard","hentry","category-sage-accpac","tag-filter-finder","tag-finder","tag-items","tag-optional-field-fitlering","tag-optional-fields","tag-order-entry","tag-sage-300-erp"],"yoast_head":"\nHow to filter finder based on optional fields - Sage 300 ERP \u2013 Tips, Tricks and Components<\/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\/2014\/05\/22\/how-to-filter-finder-based-on-optional-fields\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"How to filter finder based on optional fields - Sage 300 ERP \u2013 Tips, Tricks and Components\" \/>\n<meta property=\"og:description\" content=\"In our previous blog, on Optional field we had discussed about the feature \u2018Validate\u2019 and \u2018Allow blank\u2019. https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2014\/04\/26\/validate-optional-field-in-sage-300-erp\/ In this blog, we will discuss about ability of the finder to filter based on the optional field data. The New Stuff : Print picking slip after creation of OE Invoice in Sage 300 Sage 300 ERP\u2026 Read More »\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2014\/05\/22\/how-to-filter-finder-based-on-optional-fields\/\" \/>\n<meta property=\"og:site_name\" content=\"Sage 300 ERP \u2013 Tips, Tricks and Components\" \/>\n<meta property=\"article:published_time\" content=\"2014-05-22T11:16:06+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2022-08-24T06:31:10+00:00\" \/>\n<meta property=\"og:image\" content=\"http:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2014\/05\/1.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=\"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\/2014\/05\/22\/how-to-filter-finder-based-on-optional-fields\/\",\"url\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2014\/05\/22\/how-to-filter-finder-based-on-optional-fields\/\",\"name\":\"How to filter finder based on optional fields - Sage 300 ERP \u2013 Tips, Tricks and Components\",\"isPartOf\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2014\/05\/22\/how-to-filter-finder-based-on-optional-fields\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2014\/05\/22\/how-to-filter-finder-based-on-optional-fields\/#primaryimage\"},\"thumbnailUrl\":\"http:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2014\/05\/1.jpg\",\"datePublished\":\"2014-05-22T11:16:06+00:00\",\"dateModified\":\"2022-08-24T06:31:10+00:00\",\"author\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/#\/schema\/person\/1aced4e22c30ccf606960de27c9542f5\"},\"breadcrumb\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2014\/05\/22\/how-to-filter-finder-based-on-optional-fields\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2014\/05\/22\/how-to-filter-finder-based-on-optional-fields\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2014\/05\/22\/how-to-filter-finder-based-on-optional-fields\/#primaryimage\",\"url\":\"http:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2014\/05\/1.jpg\",\"contentUrl\":\"http:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2014\/05\/1.jpg\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2014\/05\/22\/how-to-filter-finder-based-on-optional-fields\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"How to filter finder based on optional fields\"}]},{\"@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":"How to filter finder based on optional fields - Sage 300 ERP \u2013 Tips, Tricks and Components","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\/2014\/05\/22\/how-to-filter-finder-based-on-optional-fields\/","og_locale":"en_US","og_type":"article","og_title":"How to filter finder based on optional fields - Sage 300 ERP \u2013 Tips, Tricks and Components","og_description":"In our previous blog, on Optional field we had discussed about the feature \u2018Validate\u2019 and \u2018Allow blank\u2019. https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2014\/04\/26\/validate-optional-field-in-sage-300-erp\/ In this blog, we will discuss about ability of the finder to filter based on the optional field data. The New Stuff : Print picking slip after creation of OE Invoice in Sage 300 Sage 300 ERP\u2026 Read More »","og_url":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2014\/05\/22\/how-to-filter-finder-based-on-optional-fields\/","og_site_name":"Sage 300 ERP \u2013 Tips, Tricks and Components","article_published_time":"2014-05-22T11:16:06+00:00","article_modified_time":"2022-08-24T06:31:10+00:00","og_image":[{"url":"http:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2014\/05\/1.jpg","type":"","width":"","height":""}],"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\/2014\/05\/22\/how-to-filter-finder-based-on-optional-fields\/","url":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2014\/05\/22\/how-to-filter-finder-based-on-optional-fields\/","name":"How to filter finder based on optional fields - Sage 300 ERP \u2013 Tips, Tricks and Components","isPartOf":{"@id":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2014\/05\/22\/how-to-filter-finder-based-on-optional-fields\/#primaryimage"},"image":{"@id":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2014\/05\/22\/how-to-filter-finder-based-on-optional-fields\/#primaryimage"},"thumbnailUrl":"http:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2014\/05\/1.jpg","datePublished":"2014-05-22T11:16:06+00:00","dateModified":"2022-08-24T06:31:10+00:00","author":{"@id":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/#\/schema\/person\/1aced4e22c30ccf606960de27c9542f5"},"breadcrumb":{"@id":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2014\/05\/22\/how-to-filter-finder-based-on-optional-fields\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2014\/05\/22\/how-to-filter-finder-based-on-optional-fields\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2014\/05\/22\/how-to-filter-finder-based-on-optional-fields\/#primaryimage","url":"http:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2014\/05\/1.jpg","contentUrl":"http:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2014\/05\/1.jpg"},{"@type":"BreadcrumbList","@id":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2014\/05\/22\/how-to-filter-finder-based-on-optional-fields\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/"},{"@type":"ListItem","position":2,"name":"How to filter finder based on optional fields"}]},{"@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\/7553","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=7553"}],"version-history":[{"count":1,"href":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-json\/wp\/v2\/posts\/7553\/revisions"}],"predecessor-version":[{"id":31715,"href":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-json\/wp\/v2\/posts\/7553\/revisions\/31715"}],"wp:attachment":[{"href":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-json\/wp\/v2\/media?parent=7553"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-json\/wp\/v2\/categories?post=7553"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-json\/wp\/v2\/tags?post=7553"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}