Lookup Boxes

MYOB Advanced uses the following types of lookup boxes:

  • Drop-down list: The currently selected option is shown in the box. Click the arrow to see the other options.
  • Multi-select drop-down list: A type of drop-down list in which you can select one option or multiple options at once. Click the arrow to view the available options, and then select the check boxes for the options you want to select. The selected options are displayed in the box, separated by commas.
  • Lookup table: This lookup box has a selector button that is indicated with a magnifier icon. Click the selector button to open a lookup table that shows objects in the database and information about each object.

In some cases, a lookup box offers additional buttons. For example, on a variety of forms, you can click Edit () to the right of the Vendor box to open the Vendors (AP303000) form as a pop-up and create a vendor record on the fly.

The MYOB Advanced currency box is a type of lookup box that provides additional buttons for currency manipulation. For more information, see Currency Boxes.

In the screenshot below, you can see an MYOB Advanced form with the types of lookup boxes called out.

Figure 1. Lookup box


  1. Lookup box with drop-down list
  2. Lookup box with lookup table
  3. Lookup table
  4. Additional button: Edit
  5. Currency box

Using Autocomplete

When you enter values into most lookup boxes with a lookup table, you can use autocomplete: You start typing in the box, and the system displays in the lookup table the list of suggestions that include the string you have typed.
Note: You can turn off autocomplete on the User Profile (SM203010) form.

For example, suppose you wanted to find a customer whose name is Nautilus Bar SABL. In the Customer box, you might type bar, and the list of customers would be filtered down to include only the customers whose ID or name include the string you typed, as shown in the screenshot below. Now you would press the Down Arrow key two times to navigate to Nautilus Bar SABL and press Enter to select the customer.

Figure 2. Use of Autocomplete


Selecting a Value in the Lookup Box

To select a value in the lookup box, do one of the following:

  • If you know the value, type it in the box and press Enter.

    For example, on the Purchase Orders (PO301000) form, to select a purchase order with the number 100, type 100 in the Order Nbr. box.

  • Click the magnifier icon and select the value in the lookup table.
    Note: You can use filtering options to display only documents with specific properties. For more information, see Filters.
  • If the box supports autocomplete, start typing the value, and then select the value in the table.