{"id":11,"date":"2014-03-28T08:17:00","date_gmt":"2014-03-28T08:17:00","guid":{"rendered":"http:\/\/www.greytrix.com\/blogs\/sagemas\/?p=11"},"modified":"2025-04-28T10:31:35","modified_gmt":"2025-04-28T10:31:35","slug":"how-to-customize-and-create-look-ups-in-sage-100-part-2","status":"publish","type":"post","link":"https:\/\/www.greytrix.com\/blogs\/sagemas\/2014\/03\/28\/how-to-customize-and-create-look-ups-in-sage-100-part-2\/","title":{"rendered":"How to customize and create look-ups in Sage 100 -Part 2"},"content":{"rendered":"
\n
\"Sage<\/a><\/figure><\/div>\n\n\n

In our previous blog, we discussed about creating a custom view in Sage 100.Now let\u2019s see how to add fields in custom lookup and use them on Sage 100 master’s screens.<\/p>\n\n\n

\n
\"Calculated<\/a><\/figure><\/div>\n\n
\n
\"Lookup<\/a><\/figure><\/div>\n\n
\n
\"Lookup<\/a><\/figure><\/div>\n\n
\n
\"customization<\/a><\/figure><\/div>\n\n\n

This screen also gives us an option to create a custom field by processing the New Field Button and adding desired field. We can use existing fields to calculate data for the new field if desired. For example, we could add a field that shows the past duet amount for the customer. For this we would click on the New Field button and give this new field a name. Then with the help of the Calculated Field Builder we can select the fields and operators to be included in the calculation.
At this point we may Click Next to define additional settings, or click Finish if customizing the view is done.
Using the third Lookup Customization Wizard page, we add, delete, or modify filters.
For example, we could select to see only customers that have Email Id, Name or Customer Number as defined in the filter.
In the final Lookup Customization Wizard page, we make all final changes to the Lookup view. If we require loading data in the lookup at run time, Initial Display needs to be checked. Using the Default Search Column field, we select a default field to appear at the Search field in the lookup window.
Once the customization is finished, we can see the Customized lookup by selecting the new View.  The screen provides an option to print the lookup listing by selecting the printer icon in the lower right corner and to export the lookup listing to Excel by press the Excel icon in the lower right corner.
For more information, contact us at erpmig@greytrix.com<\/a><\/p>\n\n\n\n

Greytrix<\/a> – a globally recognized and one of the oldest Sage Development Partners is a one-stop solution provider for Sage ERP and Sage CRM organizational needs. Being acknowledged and rewarded for multi-man years of experience and expertise, we bring complete end-to-end assistance for your technical consultations, product customizations, data migration, system integrations, third-party add-on development, and implementation competence.<\/p>\n\n\n\n

The unique GUMU™<\/a> integration solutions provided by Greytrix for Sage 100 include Sage 100 integration with Sage CRM<\/a>,\u00a0and\u00a0Salesforce.com<\/a>,\u00a0Dynamics 365 CRM<\/a>, the migration solutions include Sage 100 Migration from Sage 50 US<\/a>,\u00a0Sage Intacct<\/a>,\u00a0QuickBooks, Sage Business Vision and Sage Business Works. We also offer best-in-class\u00a0Sage 100 customization and development services\u00a0<\/a>to Sage business partners, end users, and Sage PSG worldwide. Sage 100 product listings by Greytrix include Salesforce \u2013 Sage ERP integration<\/a> available on Salesforce Appexchange<\/a>, Dynamics 365 CRM \u2013 Sage ERP integration<\/a> available on Microsoft Appsource (Free Trial)<\/a>.<\/p>\n\n\n\n

The GUMU™ Cloud framework by Greytrix forms the backbone of cloud integrations that are managed in real-time for processing and execution of application programs at the click of a button. <\/p>\n\n\n\n

For more details on Sage 100 Services, please contact us at sage@greytrix.com<\/a>. We will like to hear from you.<\/p>\n","protected":false},"excerpt":{"rendered":"

In our previous blog, we discussed about creating a custom view in Sage 100.Now let\u2019s see how to add fields in custom lookup and use them on Sage 100 master’s screens. This screen also gives us an option to create a custom field by processing the New Field Button and adding desired field. We can\u2026 Read More »<\/a><\/span><\/p>\n","protected":false},"author":1,"featured_media":173,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[47,50,74,175],"tags":[],"class_list":["post-11","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-custom-lookup","category-custom-view","category-erpmig","category-sage-100"],"yoast_head":"\nPart 2: Customizing and Creating Look-Ups in Sage 100<\/title>\n<meta name=\"description\" content=\"How to use and add fields to a custom lookup on the screens of the Sage 100 master.\" \/>\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\/sagemas\/2014\/03\/28\/how-to-customize-and-create-look-ups-in-sage-100-part-2\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Part 2: Customizing and Creating Look-Ups in Sage 100\" \/>\n<meta property=\"og:description\" content=\"How to use and add fields to a custom lookup on the screens of the Sage 100 master.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.greytrix.com\/blogs\/sagemas\/2014\/03\/28\/how-to-customize-and-create-look-ups-in-sage-100-part-2\/\" \/>\n<meta property=\"og:site_name\" content=\"GUMU\u2122 Integrations \u2013 Tips, Tricks and Components\" \/>\n<meta property=\"article:published_time\" content=\"2014-03-28T08:17:00+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2025-04-28T10:31:35+00:00\" \/>\n<meta name=\"author\" content=\"greysagemas\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"greysagemas\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"4 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagemas\/2014\/03\/28\/how-to-customize-and-create-look-ups-in-sage-100-part-2\/\",\"url\":\"https:\/\/www.greytrix.com\/blogs\/sagemas\/2014\/03\/28\/how-to-customize-and-create-look-ups-in-sage-100-part-2\/\",\"name\":\"Part 2: Customizing and Creating Look-Ups in Sage 100\",\"isPartOf\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagemas\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagemas\/2014\/03\/28\/how-to-customize-and-create-look-ups-in-sage-100-part-2\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagemas\/2014\/03\/28\/how-to-customize-and-create-look-ups-in-sage-100-part-2\/#primaryimage\"},\"thumbnailUrl\":\"\",\"datePublished\":\"2014-03-28T08:17:00+00:00\",\"dateModified\":\"2025-04-28T10:31:35+00:00\",\"author\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagemas\/#\/schema\/person\/b57e6e3564a12ef62967850ae0416728\"},\"description\":\"How to use and add fields to a custom lookup on the screens of the Sage 100 master.\",\"breadcrumb\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagemas\/2014\/03\/28\/how-to-customize-and-create-look-ups-in-sage-100-part-2\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.greytrix.com\/blogs\/sagemas\/2014\/03\/28\/how-to-customize-and-create-look-ups-in-sage-100-part-2\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagemas\/2014\/03\/28\/how-to-customize-and-create-look-ups-in-sage-100-part-2\/#primaryimage\",\"url\":\"\",\"contentUrl\":\"\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagemas\/2014\/03\/28\/how-to-customize-and-create-look-ups-in-sage-100-part-2\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.greytrix.com\/blogs\/sagemas\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"How to customize and create look-ups in Sage 100 -Part 2\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagemas\/#website\",\"url\":\"https:\/\/www.greytrix.com\/blogs\/sagemas\/\",\"name\":\"GUMU\u2122 Integrations \u2013 Tips, Tricks and Components\",\"description\":\"Welcome to the GUMU\u2122 blog, your one-stop source to gain all the insights on seamless integration solutions for ERP and CRM systems. Developed by Greytrix, GUMU\u2122 is a powerful integration platform that bridges the gap between your business applications. Whether you\u2019re looking to integrate a CRM (Salesforce, Dynamics 365 CRM, and Sage CRM) or an ERP (Sage ERP, Acumatica) with each other or any other third-party application, GUMU\u2122 is a robust and reliable integrator tailored to your unique needs. Join us as we explore the abilities of GUMU\u2122 and learn how it transforms your integration experience. \",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.greytrix.com\/blogs\/sagemas\/?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\/sagemas\/#\/schema\/person\/b57e6e3564a12ef62967850ae0416728\",\"name\":\"greysagemas\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagemas\/#\/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\":\"greysagemas\"},\"url\":\"https:\/\/www.greytrix.com\/blogs\/sagemas\/author\/greysagemas\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Part 2: Customizing and Creating Look-Ups in Sage 100","description":"How to use and add fields to a custom lookup on the screens of the Sage 100 master.","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\/sagemas\/2014\/03\/28\/how-to-customize-and-create-look-ups-in-sage-100-part-2\/","og_locale":"en_US","og_type":"article","og_title":"Part 2: Customizing and Creating Look-Ups in Sage 100","og_description":"How to use and add fields to a custom lookup on the screens of the Sage 100 master.","og_url":"https:\/\/www.greytrix.com\/blogs\/sagemas\/2014\/03\/28\/how-to-customize-and-create-look-ups-in-sage-100-part-2\/","og_site_name":"GUMU\u2122 Integrations \u2013 Tips, Tricks and Components","article_published_time":"2014-03-28T08:17:00+00:00","article_modified_time":"2025-04-28T10:31:35+00:00","author":"greysagemas","twitter_card":"summary_large_image","twitter_misc":{"Written by":"greysagemas","Est. reading time":"4 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.greytrix.com\/blogs\/sagemas\/2014\/03\/28\/how-to-customize-and-create-look-ups-in-sage-100-part-2\/","url":"https:\/\/www.greytrix.com\/blogs\/sagemas\/2014\/03\/28\/how-to-customize-and-create-look-ups-in-sage-100-part-2\/","name":"Part 2: Customizing and Creating Look-Ups in Sage 100","isPartOf":{"@id":"https:\/\/www.greytrix.com\/blogs\/sagemas\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.greytrix.com\/blogs\/sagemas\/2014\/03\/28\/how-to-customize-and-create-look-ups-in-sage-100-part-2\/#primaryimage"},"image":{"@id":"https:\/\/www.greytrix.com\/blogs\/sagemas\/2014\/03\/28\/how-to-customize-and-create-look-ups-in-sage-100-part-2\/#primaryimage"},"thumbnailUrl":"","datePublished":"2014-03-28T08:17:00+00:00","dateModified":"2025-04-28T10:31:35+00:00","author":{"@id":"https:\/\/www.greytrix.com\/blogs\/sagemas\/#\/schema\/person\/b57e6e3564a12ef62967850ae0416728"},"description":"How to use and add fields to a custom lookup on the screens of the Sage 100 master.","breadcrumb":{"@id":"https:\/\/www.greytrix.com\/blogs\/sagemas\/2014\/03\/28\/how-to-customize-and-create-look-ups-in-sage-100-part-2\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.greytrix.com\/blogs\/sagemas\/2014\/03\/28\/how-to-customize-and-create-look-ups-in-sage-100-part-2\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.greytrix.com\/blogs\/sagemas\/2014\/03\/28\/how-to-customize-and-create-look-ups-in-sage-100-part-2\/#primaryimage","url":"","contentUrl":""},{"@type":"BreadcrumbList","@id":"https:\/\/www.greytrix.com\/blogs\/sagemas\/2014\/03\/28\/how-to-customize-and-create-look-ups-in-sage-100-part-2\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.greytrix.com\/blogs\/sagemas\/"},{"@type":"ListItem","position":2,"name":"How to customize and create look-ups in Sage 100 -Part 2"}]},{"@type":"WebSite","@id":"https:\/\/www.greytrix.com\/blogs\/sagemas\/#website","url":"https:\/\/www.greytrix.com\/blogs\/sagemas\/","name":"GUMU\u2122 Integrations \u2013 Tips, Tricks and Components","description":"Welcome to the GUMU\u2122 blog, your one-stop source to gain all the insights on seamless integration solutions for ERP and CRM systems. Developed by Greytrix, GUMU\u2122 is a powerful integration platform that bridges the gap between your business applications. Whether you\u2019re looking to integrate a CRM (Salesforce, Dynamics 365 CRM, and Sage CRM) or an ERP (Sage ERP, Acumatica) with each other or any other third-party application, GUMU\u2122 is a robust and reliable integrator tailored to your unique needs. Join us as we explore the abilities of GUMU\u2122 and learn how it transforms your integration experience. ","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.greytrix.com\/blogs\/sagemas\/?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\/sagemas\/#\/schema\/person\/b57e6e3564a12ef62967850ae0416728","name":"greysagemas","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.greytrix.com\/blogs\/sagemas\/#\/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":"greysagemas"},"url":"https:\/\/www.greytrix.com\/blogs\/sagemas\/author\/greysagemas\/"}]}},"_links":{"self":[{"href":"https:\/\/www.greytrix.com\/blogs\/sagemas\/wp-json\/wp\/v2\/posts\/11","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.greytrix.com\/blogs\/sagemas\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.greytrix.com\/blogs\/sagemas\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sagemas\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sagemas\/wp-json\/wp\/v2\/comments?post=11"}],"version-history":[{"count":12,"href":"https:\/\/www.greytrix.com\/blogs\/sagemas\/wp-json\/wp\/v2\/posts\/11\/revisions"}],"predecessor-version":[{"id":6295,"href":"https:\/\/www.greytrix.com\/blogs\/sagemas\/wp-json\/wp\/v2\/posts\/11\/revisions\/6295"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sagemas\/wp-json\/"}],"wp:attachment":[{"href":"https:\/\/www.greytrix.com\/blogs\/sagemas\/wp-json\/wp\/v2\/media?parent=11"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sagemas\/wp-json\/wp\/v2\/categories?post=11"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sagemas\/wp-json\/wp\/v2\/tags?post=11"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}