Share via


Variant Filter Field, Item Table

Displays the filter that filters by item variant.

If the field contains a variant code, the values in the fields that show quantities are based only on entries with the variant code that is included in the filter.

You can enter a maximum of 10 characters, both numbers and letters. There are certain rules for how these can be combined:

Meaning Sample Expression Included

Equal to

Blue

Entries with the Blue variant code

Interval

1..5

Entries with variant codes 1 through 5

Either/or

Paris|Rome

Entries with either the Paris or Rome variant code

Different than

<>AA

Entries with all variant codes, except AA

To see the variant codes in the Item Variant table, choose the field.

Tip

For more information on how to work with fields and columns, see Work with Data. For assistance in finding specific pages, see Search.

Parent Tables

Table Location
Negative Adjmt. (LCY) Field, Item Table Inventory
Item Table Inventory
Item Table Inventory

See Also

Reference

Item Card

Other Resources

How to: Set Up Items
Entering Criteria in Filters