Improved Lookup features in the new SQL Version of Sage 100

Nov 15, 2016
Sage 100 Lookup Column Options

Magnifying Glass
Ever wish you could rearrange columns in the Lookup Windows within Sage 100 Contractor?

Well, now you can with the newest version of Sage 100 Contractor that runs on Microsoft SQL Server!  AND you can select which columns you want to see – or don’t.

Here’s how it works.

How to Rearrange Lookup Columns

Right-click anywhere in the Header within any Lookup Window (highlighted in Yellow below) and click on “Select Columns to Show”. When the Lookup Columns window appears, select or deselect the checkbox next to the columns you would like to see or hide using the scroll bar (circled in Red) to see all available columns.

Sage 100 Lookup Column Options

You can then drag the selected columns (using each Column Headers, as highlighted in Yellow) to have them appear in the order you would like.  See below.

sage 100 column headers

More Resources

Acumatica 2026 Release 1 Highlights

Acumatica 2026 Release 1 Highlights

The highly anticipated Acumatica 2026 R1 reached general availability at the end of March 2026. This release included several exciting features and new offerings. Here are some of the most impactful...

read more

Get In Touch with Our Product Experts

Seeking more information on our solutions? Fill out the form, providing a few details about what you are looking for, and we will be in touch shortly.