Need Help?
  • Application Remote Support
  • Infrastructure Remote Support
  • Sage HRMS Remote Support
  • Helpdesk
  • General Inquiry
1-800-719-3307
Net at Work Net at Work
  • Solutions & Services
    • ERP/Accounting
      Software & Vendor Selection
      ERP Implementation Services
      ERP Migration Services
      Acumatica
      NetSuite
      Sage X3
      Sage Intacct
      SDMO
      Sage 100 ERP
      Sage 300 ERP
      Sage 500 ERP
      CRM
      Strategic Advisory Services
      CRM Training Camp
      Creatio
      Sage CRM
      Employee Experience
      Sage HRMS
      Rippling
      Criterion
      Miviva
      Enterprise Content Management
      Imaging / Scanning
      Document Management
      Workflow Automation
      Solutions
      Nonprofit Solutions
      Abila by Community Brands
      NetSuite
      Sage
      Salesforce
      IT and Security Services
      Managed IT Services
      Fractional CIO Services
      Cloud Services
      Cloud at Work Sage Hosting
      DR/Business Continuity Planning
      Compliance & Security
      Storage & Recovery
      Networking
      IT Security Services
      Communications
      Web Solutions
      Services Overview
      B2B Technology Suite
      Magento eCommerce
      WordPress CMS
      Systems Integration
      Website Managed Services
      Online Marketing & SEO
      ERP eCommerce Integration
      Additional Solutions
      Enterprise Business Intelligence
      Avalara Automated Tax Solutions
      Fortis Payments
      LeaseQuery Lease Accounting
      Sage Fixed Assets
      Vertex SMB Sales and Use Tax
      Prime Foodservice Software
      Rental 360
  • Industries
    • Industries
      Chemicals
      Construction
      Discrete Manufacturing
      Field Service
      Food & Beverage
      Healthcare
      Industrial Manufacturing & Equipment
      Medical Devices
      Nonprofit
      Private Equity
      Retail
      Wholesale Distribution
  • Learning Center
    • Online Resources
      Recorded Webinars
      Whitepapers
      Ebooks
      Success Stories
      Upcoming Events
      Live Webinars
      Seminars
      Virtual Training Courses
      Training Courses
      View all available training course options
  • Company
    • Why Us
      Who We Are
      Management
      Our Partners
      Locations
      Careers
      News
      Press Releases
      Success Stories
      Net at Work Blog
      Contact Us
      1.800.719.3307
      Email Us
      Programs
      Alliance Partnership Program
      Women at Work
      Diversity and Inclusion
  • Blog
  • Contact Us
  • Contact Us

Home » Newsletters » Sage 100 Newsletter – Q2 2021 » Add a Field to Sage 100 With a Lookup Table

Sage 100

Sage 100 Newsletter – Q2 2021

Keeping You Up-To-Date With Information About Sage 100

Add a Field to Sage 100 With a Lookup Table

By: Jane Amorim, Business Analyst / Consultant

We already saw how to add fields (UDFs) to Sage in a prior newsletter.  Now, let’s learn how to add a field that allows us to select a value from our own custom lookup list.  No coding is required for this one, but it does involve 3 parts.

Part I: Creating A Table (UDT)

We will first start by creating a list of territories to choose from.

  1. Open Custom Office > Main > User Defined Field and Table Maintenance. Highlight Accounts Receivable and click on the “Add User Defined Table” button (highlighted below).
  2. Enter a table name, description, key field name (name of your new field), and make sure to give your key field length enough characters to accommodate all items on your list. Click OK when you’re done. Note: Although you can increase this field length in the future, it is cumbersome, so it’s best to get it right the first time.  However, it is not possible to reduce the size.

    FYI: In the following screen you have the ability to add more fields (columns) to this table.

  3. Now that our table has been created, let’s add a link in Sage 100 to access it which will allow us to easily maintain the territories list. Click on the “Add UDT to Desktop” button and click OK when prompted.

  4. You will need to give yourself (and other users, if you like) access to this new option in Sage. Do that via Library Master>Main>Role Maintenance.
    • Select your Role, and expand the Custom Office > Miscellaneous Tasks menu.
    • Check the box next to your new UDT and click Accept when done.
  5. Now open your table via Custom Office> UDT Maintenance.
    • Enter the selection options you’d like to make available for populating your new field. In our example, we will add our list of territories:

Part II: Add a New Field (UDF) to Sage:

    1. Return to User Defined Field and Table Maintenance and select the table to which you’ll be adding your field.
    2. Highlight the table and click the “Edit Fields” button.
    3. Click the “+” button
    4. Enter a name for your new field
    5. Keep the “Manual Entry” radio button selected and click “OK.”
    6. In the next screen, enter the same field length as you did for the UDT “Key” in step number 2 under the section “Creating A Table (UDT).” Then, click the “Validation” tab.
    7. Next, select the radio button next to “User-Defined Table.”
    8. If you made your key and UDF the same length, you should see your table available for selection. Select the table and click OK.

Click OK, then OK again (to update the database) and then Close to return to the main menu.

Part III: Add Your New Field to the Screen

  1. Open the screen where you’d like to add your new field. In our case, that will be Customer Maintenance.
    • Right click on the screen until you see a pop-up menu with the “Panel Settings” option.
    • Select “Customizer.” (Alternatively, you can open Customizer from Custom Office>Main>Customizer Selection.)Note that you will need role security permissions to access “Customizer.”
  2. From the next screen you will have the option of creating a new custom screen (aka “Panel”) or modifying an existing one (if any already have been created previously).
    Note that custom panels may be created for all users and all companies, or specific users and/or specific companies.

  3. Next, click the “Add Field” button and select your new UDF from the list that appears.

  4. Close the Customizer screen and save your changes when prompted.

And that’s it! No coding necessary. Just be sure to cover the 3 components when creating your own custom field with a lookup.

« Return to Newsletter
  • This field is for validation purposes and should be left unchanged.

In This Issue
  • From the Desk of the Sage 100 Consulting Manager, Lisa Margolies
  • Add a Field to Sage 100 With a Lookup Table
  • Public vs. Private Cloud and the Best Option for Hosting Sage 100
  • Top 3 Reasons that Now is the Time to Rethink Payments for Sage 100!
  • Driving Business Results with your HR System
  • Featured Sage 100 Consultant: Ryan Elofson, Business Analyst
  • Sage 100 Support

    Helpdesk:
    P: 888.494.9479
    E: helpdesk@netatwork.com

    Ready to Upgrade Your
    Sage 100?
    Fill out this form and get your free quote
    Request Upgrade Quote

    Request Sage 100
    Consulting Services

    Get Help From Our Sage 100 Consultants
    Request Services

    Sage 100 Live Webinars

    Getting a Grip on Your Digital Transformation: Business Technology Strategies for 2025 and Beyond
    March 26 | 2pm ET
    Register Here

    Revolutionize CRM for Smarter Growth
    April 7 | 2pm ET
    Register Here

    Is It Time to Take the Leap? Transitioning from Sage 100 or 300 to Sage Intacct
    April 10 | 2pm ET
    Register Here

    Popular Recorded Webinars

    The Case for Hosting Sage 100 in the Cloud

    Sage Business Intelligence (BI) & Reporting Overview: The Tools Available To Build Your Business

    Building Resilience Into Your IT Infrastructure – Proactive Strategies for Uninterrupted Operations

    Assessing Your HR & Payroll Systems

    Sage 100 – Live Online Training Courses

    Wide range of class topics! Browse the course calendar & register.

    Sage 100 Webinar Archive

    View our library of on-demand recorded webinars.

    Refer a friend, get a $100 Gift Card!

    Submit a Referral / Learn More!
    Do you have a friend or colleague whose company might benefit from utilizing a Net at Work service or solution? If so, refer them to us below and receive a $100 gift card or donation to your charity of choice!

    Connect With Us

    Business Applications

    • Overview
    • Software & Vendor Selection
    • ERP Implementation Services
    • ERP Migration Services
    • Cloud ERP
    • CRM
    • Employee Experience
    • ECM
    • Nonprofit Solutions

    Learning Center

    • White Papers & Guides
    • Ebooks
    • Training Courses
    • Virtual Training Courses
    • Success Stories
    • Live Webinars
    • Recorded Webinars
    • Trials

    Infrastructure Solutions

    • Managed IT Services
    • Fractional CIO & Advisory Services
    • Cloud Services
    • Cloud at Work Sage Hosting

    Support

    • Application Remote Support
    • Infrastructure Remote Support
    • Sage HRMS Remote Support
    • General Inquiry
    • Helpdesk

    Web Development

    • Services Overview
    • Magento eCommerce
    • WordPress CMS
    • Systems Integration
    • Website Managed Services
    • ERP eCommerce Integration

    Company Information

    • Why Us
    • Alliance Partnership Program
    • Women at Work
    • Diversity and Inclusion
    • Partners
    • Careers
    • News
    • Blog
    • Privacy Policy
    • Contact Us

    Additional Solutions

    • Enterprise Business Intelligence
    • Avalara Automated Tax Solutions
    • Fortis Payments
    • LeaseQuery Lease Accounting
    • Sage Fixed Assets (Sage FAS)
    • Vertex SMB Sales and Use Tax
    • Prime Foodservice Software
    • Rental 360
    • SDMO

    Industries

    • Chemicals
    • Construction
    • Discrete Manufacturing
    • Field Service
    • Food & Beverage
    • Healthcare
    • Industrial Manufacturing & Equipment
    • Medical Devices
    • Nonprofit
    • Private Equity
    • Wholesale Distribution
    Net at Work
    Net at Work (HQ)
    575 8th Ave
    New York, NY 10018

    P: (800) 719-3307
    info@netatwork.com
    Locations Across North America »
    Visit our sister companies:
    Cloud at Work - Sage Application Hosting
    Pixafy - An eCommerce Agency
    Docutrend
    WordPress Image Lightbox Plugin


    Our website uses cookies to ensure you get the best experience. Learn more.

    I Understand