How to customize and create look-ups in Sage 100 -Part 1

By | March 28, 2014

Most of the data entry screens in Sage 100 ERP contain a lookup option for various fields which can be identified by a magnifying-glass. If we select the magnifying-glass lookup icon, we will be able to scroll through a listing of all our records and data. For example, Customer Maintenance contains a lookup for the customer number, customer name, zip code and phone number etc.

While creating a lookup view, we can define the view as default, add, remove, or modify fields in the lookup, add or remove filters, as well as define several other settings. If we need something that we don’t see in the list, it can be created as new fields using simple arithmetic functions. This can even be reset, modified or deleted at any time.

Procedures for creating custom lookups

For customizing our Lookup panel, we would require following few simple steps. They are as mentioned as below. While in the lookup window we click Custom button and navigate to the Lookup Customization Wizard page.

On the Lookup Customization Wizard page, at the View field, we select Create a new view and enter a description for the new view. If we want to customize a previous look up created, we select the existing view to modify it. As soon as a view is entered or selected, NEXT button gets enabled. We shall process it to navigate to the second screen.

In the second Lookup Customization Wizard page, we get an option to add, remove, modify, or reorganize the fields for the lookup view in the Selected Columns list box. We can move them to the Selected Column portion of the screen by double clicking or by highlighting and clicking the arrow which points to the right. We can also change the order that the columns display by selecting the icon at the bottom of the screen (near the Modify button) to move an item up or down in the list. It should be noted that the first column Highlighted in red and indicated by an asterisk (*) in the Selected Columns list box cannot be removed; however, it can be modified. Linked files from modules that are not activated also appear in the Available Fields field but you may not have access to them.

In our next blog Part-2, we will see how to add Sage 100 fields in above-created custom view and use on Sage 100 master screens.

For more information, contact us at

About Us

Greytrix is one stop solution provider for Sage ERP and Sage CRM needs. We provide complete end-to-end assistance for your technical consultations, product customizations, data migration, system integrations, third party add-on development and implementation expertise.

Greytrix have some unique solutions of Sage 100 integration with Sage CRM, and  along with Sage 100 Migration from Sage 50 US, QuickBooks, 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.

For more details on Sage 100 Services, please contact us at We will be glad to assist you.