Working with Picklist Windows

A Picklist is a type of Lookup window. With a Picklist, you can select a group of items and insert them in the active window. For example, in the Payable Invoices window you can select and insert a list of parts in the grid.

In Report Printing windows, it is not necessary to create a Picklist. If you know which record numbers to include in the report, enter them in the Picklist box. Make sure to separate the record numbers with commas.

Important! If you press F8 on a criteria item that displays a Picklist check mark, such as in the 5-2-3 Compute Payroll window, no Picklist window is displayed. The F5 key, however, will display the Picklist window.

  • From the grid cell of a column that supports Picklist functionality, for example Part# or Assembly#, right-click a cell, and click Display Picklist Window.
  • A window related to that column opens with Picklist functionality indicated by the check mark button.
  • From the grid cell of a column that supports Picklist functionality, press F8.
  • From windows with text boxes that support Picklist functionality, such as 5-2-3 Compute Payroll, click the check mark button.
  1. Double-click each item you want to select.
  2. To insert the group of items into the grid, click the Insert Selected Items button.
  • In fields that contain character or alphanumeric data such as descriptions, addresses, and invoice numbers, Sage 100 Contractor sorts data by the value of the first digit. If a field is strictly numeric, then the numbers appear in numerical order. For example, 1100 would appear before 200.
  • To sort a column in ascending order, click the arrow in the column title.