Location Filter Field, Item Substitution 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. For example:
| 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 |
|---|---|
| Item Substitution Table | Inventory |
| Item Substitution Table | Sales and Receivables |