Modify Existing Lookup in Sage 100 ERP

By | August 23, 2013
Sage 100 ERP is one of the popular ERP systems in mid-level businesses. It provides several small, but useful features that come handy for Customer’s specific needs. In this blog, we will discuss one of such feature i.e. customizing standard Sage 100 look-up screens. Before we go ahead, let’s take a look at some useful information about it;
  • Users can create up to 99 unique lookup views based on company code and user code.
  • While creating lookup view, User can define view as default in which they can add, remove, or modify fields in lookup, add or remove filters, as well as define several other settings.
  • After creating a lookup view, users can modify or delete view at any time.

View Sage 100 Lookup In GUMU for Sage CRM – Sage 100 ERP Integration 

To illustrate it better, let’s take an example by customizing a standard look-up screen of Item look-up.
  • Open the Item list Look-up from the Item Maintenance Screen .
  • Click on the “Custom…” button, below screen would appear
  • Click on Next and select the list of columns that you want to show
  • Then, click on “Finish” button, you will get the newly created look-up as per your requirement.

Users can use these customized look-ups to process the records a little faster which in turn help them increase their efficiency. You can customize almost all the standard look-up that is available in Sage 100 and customize them as per your requirement.

About Us

Greytrix – a globally recognized and one of the oldest Sage Gold Development Partner 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.

The unique GUMU™ integration solutions provided by Greytrix for Sage 100 include Sage 100 integration with Sage CRM, and Salesforce.comDynamics 365 CRM, the migration solutions include Sage 100 Migration from Sage 50 USSage IntacctQuickBooks, Sage Business Vision and Sage Business Works. We also offer best-in-class Sage 100 customization and development services to Sage business partners, end users, and Sage PSG worldwide. Sage 100 product listings by Greytrix include Salesforce – Sage ERP integration available on Salesforce Appexchange, Dynamics 365 CRM – Sage ERP integration available on Microsoft Appsource (Free Trial).

For more details on Sage 100 Services, please contact us at We will like to hear from you.