Location Filter Field, Item Table

Displays the filter that filters by location.

If the field contains a location code, the values in the fields that contain quantities are based only on entries with the location 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

Oslo

Entries from the Oslo location

Interval

1..5

Entries from Locations 1 through 5

Either/or

Oslo|Vienna

Entries that are from either Oslo or Vienna

Different from

<>1

Entries from all locations except Location 1

To see the location codes in the Location 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