Query by Example for Cycle Counts

Use the Query by Example search option during cycle count subinventory selection to easily search for subinventories to include or remove from your cycle counts.

Here's how to perform a query by example for cycle count subinventories:

  1. From the Inventory Management work area, select the Create Cycle Count task.

  2. On the Create Cycle Count: Enter Primary Details page, click the Query by Example icon in the toolbar to enable the Query by Example search framework.

    Separate, blank rows appear immediately above the search results table for the Subinventory and Include in Count search attributes.

  3. Enter a value in one or more of the search fields.

    • Subinventory: You can enter all or part of a subinventory name.

    • Include in Count: Select either Yes or No for the Include in Cycle Count search. Yes indicates that the subinventory is included in the count and No indicates that the subinventory isn't included in the count.

    Items in the table matching the values you entered display.

  4. To return to the regular view, click the Query by Example icon again.

This functionality is available on both the Create Cycle Count: Enter Primary Details and Edit Cycle Count: Enter Primary Details pages.

Note: If you enter values in both fields, only the results that match both search values display.