SYSPRO Advanced Browse

The SYSPRO Advanced Browse feature consolidates SYSPRO's traditional browse look-ups into a single program, making it easier to administer and customize. The traditional browse look-up programs are typically accessed from the browse icon, or by pressing F9.

Exploring

From SYSPRO 8 2021 R2, all new programs that require browses default to using the new advanced browse facility which is available for valid key fields on a toolbar, grid or form.

For the traditional browse look-up programs (accessed from the browse icon, or by pressing F9) you will need to enable the Enable advanced browse option (Setup Options > System Setup > System-Wide Personalization) to take advantage of the new advanced browse features.

Things you can do using this feature includes:

  • Browse records associated with the field from which you loaded the program.

  • Indicate the criteria according to which you want to browse records.

  • Filter records according to specific text contained in the first column, or all columns.

  • Specify the number of records that you want to display on a single page.

  • Reset any filters applied to your listview.

  • View current page number.

Setup programs

Search Configuration

Starting

The following configuration options in SYSPRO may affect processing within this program or feature, including whether certain fields and options are accessible.

The Setup Options program lets you configure how SYSPRO behaves across all modules. These settings can affect processing within this program.

Setup Options > System Setup > System-Wide Personalization

  • Enable advanced browse

  • The advanced browse feature doesn't apply to browse programs launched standalone from the Program List. It's only applicable to key fields associated with your setup, query and report programs (e.g. accessed from the browse icon, or by pressing F9).

  • The advanced browse feature doesn't cater for multiple part keys (e.g. when browsing on stock codes for a warehouse).

  • Because the advanced browse feature caters for extensive configuration and customization capabilities from within the Search Configuration program, some functions from the legacy browse programs are no longer applicable or required (e.g. adding or removing columns using the Field Chooser function or being able to re-arrange columns in the browse program).

Solving


From SYSPRO 8 2021 R2, all new programs that require browses default to using the new advanced browse facility which is available for valid key fields on a toolbar, grid or form.

For the traditional browse look-up programs (accessed from the browse icon, or by pressing F9) you will need to enable the Enable advanced browse option (Setup Options > System Setup > System-Wide Personalization) to take advantage of the new advanced browse features.

The following explains how to define the details and sequence in which you want to display information for each of your specific browses:

  1. Open the Search Configuration program (Program List > Administration).

  2. Expand the SYSPRO folder displayed in the Configured Searches pane.

    This folder contains all the various browse and search fields that are configurable for this feature.

  3. Select the field against which you want to configure its associated browse.

    This loads the Search Details pane, as well as the Search Criteria listview which applies to the Predictive Search feature.

    The Layout preview of the Search Details pane indicates the columns currently displayed in the browse that are associated with the field (this is purely informational and can't be edited).

  4. Within the Search parameters section, select the hyperlink against Fields to return to indicate all the columns that you want to display in the Results listview associated with the browse.

    This loads the Fields To Return window:

    1. Use the checkboxes within the Include column to indicate all the fields that you want to include as columns in the browse associated with the field.

      Fields with a icon are primary fields and can't be deselected if the checkbox is disabled.

    2. Select the Apply function.

  5. Select the Save function of the Search Details pane.

    This launches the Save Search window:

    1. From the Search level option, indicate the level at which you want to save the search (e.g. system-wide, by company, by role or by operator).

    2. Depending on your selected level, indicate the associated code within the Search company, Search role or Search operator fields.

    3. Ensure that the Default option is enabled against the Product field.

    4. Select the Save function.

      The Configured Searches pane is updated with the new customized configuration.

  6. Optional

    From the Search Details pane, select the Order by fields hyperlink to specify the particular order in which you want to display your columns.

    This loads the Order By Fields window:

    1. Drag the fields associated with the columns (to be displayed in the browse) in the order of relevance that you require.

      These columns are displayed from left to right of the browse Results listview.

      Use the Move Up and Move Down functions in the toolbar to re-sequence records in the listview.

    2. Select the Apply function.

  7. At the Number of rows to return field, indicate the default number of rows that you want to display in the Results listview.

  8. Select the Save function.

  9. Exit the program.

You can now load the browse against the customized field. The fields that you selected and reordered should now be displayed as columns when using the SYSPRO Advanced Browse feature.