Sage Partners
Connect on Twitter
  • Home
  • Find a Reseller
    • By Location >
      • U.S. Partners
      • Canada Partners
    • By Sage Product >
      • Sage ERP Partners >
        • Sage 50 Partners
        • Sage 100 Partners
        • Sage 300 Partners
        • Sage 500 Partners
        • Sage X3 Partners
        • Sage Intacct Partners
      • Sage Construction Partners >
        • Sage 100 Contractor (Partners)
        • Sage 300 Construction (Partners)
      • Other >
        • Sage CRM Partners
        • Sage HRMS Partners
        • MIP Fund Accounting
  • Sage Product Info
    • Sage 50
    • Sage 100 >
      • Sage 100 Tips & Tricks
      • Sage 100 System Requirements
    • Sage 300 >
      • Sage 300 Installation Guides
    • Sage Intacct
    • Sage 500
    • Sage X3
    • Sage Construction >
      • Sage 100 Contractor
      • Sage 300 Construction
      • Sage Estimating
    • Other Sage Products >
      • Sage Fixed Assets >
        • Sage Fixed Assets User Guides
      • Sage CRM
      • Sage HRMS >
        • Sage HRMS System Requirements
  • Sage Add Ons
  • Resources
    • Blog
    • Popular Articles
    • Buying Guides >
      • Inventory Management Tips
      • ERP Implementation Failure
  • Contact Us

How to Customize Sage 100 Lookups

2/9/2023

0 Comments

 
Sage 100 Custom Lookup
Lookups are an important function in Sage 100. After all, what good is having all that data in your accounting system if you can’t easily pull it up? However, the default onscreen lookups don’t always display exactly what you're looking for or in a layout that you need.

So let’s take a look at how to create customized Sage 100 Lookup Views.

Custom Lookup Views

What is a Sage 100 Lookup View?
Anytime you click the magnifying glass icon, it launches into a lookup screen. Whether you’re searching for vendors, customers, accounts, or any other data in Sage 100, lookups are a quick and easy way to find what you need.
 
But in some cases, hundreds or even thousands of records might display by default, forcing you to spend additional time searching and scrolling. With the following instructions, you can customize the fields, filters, and search criteria to really speed things up:

Step 1
From any lookup window (after clicking the magnifying glass icon), choose the Custom button which launches the Lookup Customization Wizard.

Step 2
In the View field of the Customization Wizard, select Create New View and give it a name in the description field (or you can select an existing view to modify it).

Step 3
Click the Default View checkbox if you’d like this to be the new default lookup. Click Next.
Sage 100 Lookup Wizard
Step 4
On the next screen, you can add, remove, modify, and rearrange the order of the columns that display in the lookup. Note that the first column indicated by an asterisk (*) cannot be removed, but can be modified.
Modify Sage 100 Lookup Columns
Step 5
At this point, you can either click Finish if you’re happy with your new customized view or click Next to launch a third options screen to define additional settings to modifying the Filters and further refine the data that will display in your lookup.

Step 6
If you clicked Next in Step 5, use this third Lookup Customization Wizard page to add, delete, or modify filters. To continue defining additional settings, click Next; otherwise, click Finish.
Sage 100 Field Filter Options
Step 7
In the last Customization Wizard screen, you can make any final changes and display options and then click Finish to create your new customized lookup view.

Now when you launch your new lookup screen, you’ll notice that the title bar at the top left shows your new description along with an asterisk to indicate that this is a custom view.
customized lookup view

BONUS TIPS

Exporting Lookup Data
Did you know you can export the data in your new custom lookup to Microsoft Excel?  Just click the Excel icon in the lower right corner of your lookup window and voila! The data is exported so you can further slice, dice and analyze.
 
Modify Existing Lookup
Rather than creating an entirely new Sage 100 Lookup as we just did, you can instead modify an existing lookup. Perhaps one of the default lookup gives you 80% of what you need and with just a few tweaks, it's perfect. In that case, follow these steps:

  1. In the second Lookup Customization Wizard page, click Modify to alter the selected field in the Selected Columns list box.
  2. In the Lookup Customization Wizard - Modify window, make the desired changes and click OK.

For example, you can change the width of the key field to zero if you do not want to display it in the lookup.
Sage 100 Partners Banner
0 Comments

Your comment will be posted after it is approved.


Leave a Reply.

    ARE YOU A SAGE PARTNER?

    Get Your Business Listed Here!

    Click below if you're interested in having your business listed in this online directory of Sage Partners.
    Get Started
    Sage Warehouse Management
    Scanforce WMS for Sage
    Sage Cloud Hosting
    Picture

    Popular Articles

    Big Bang Implementation vs Phased Approach
    (Pros, Cons)

    ---
    What's New in
    Sage 100 2022

    ---
    What's New in
    Sage 300 2023

    ---
    New Release:
    Sage Intacct 2022

    ---
    What Does ERP Stand For?
    ---
    Sage 100 System Requirements and installation Guide
    ---
    Sage 300 Installation Guide
    ---
    Sage 100 Tips & Tricks

©2023 Top-Sage-Resellers.com. All rights reserved. This material and content on this website may not be reproduced, displayed, modified or distributed without the express prior written permission of the copyright holder. This website is not owned, operated, affiliated with, or endorsed by Sage Software, Inc. or Sage Intacct, Inc. Sage, Sage logos, and Sage product names mentioned herein are registered trademarks or trademarks of Sage Software, Inc. and/or its affiliates. Other product names mentioned are trademarks of their respective owners.
Privacy Policy