Bin Filter Field, Stockkeeping Unit Table
Displays the filter that filters by bin code.
If the field contains a bin code, the values in the fields that show quantities are based only on entries with the bin 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 |
A41 |
Entries from bin A41 |
Interval |
1..5 |
Entries from bins 1 through 5 |
Either/or |
B22|C22 |
Entries that are from either bin B22 or bin C22 |
Different than |
<>1 |
Entries from all bins except bin 1 |
To see the bin codes in the Bin 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 |
|---|---|
| Stockkeeping Unit Table | Inventory |
| Stockkeeping Unit Table | Inventory |
See Also
Other Resources
How to: Set Up Stockkeeping Units
Entering Criteria in Filters