Field Filtering
When a reference field offers the wrong records — too many, too few, or the wrong branch's — one of three tools is behind it, and they are easy to confuse because two of them sit next to each other in the menu with almost the same name.
| The complaint | The tool |
|---|---|
| "The lookup won't show records from another branch, legal entity or department." | Field Filtering — loosens the dimension narrowing on one field. |
| "The lookup shows records it shouldn't — service items, another supplier's items." | Field Filter With Criteria — narrows a field by a condition, switched on per term, book, group or menu entry. |
| "The same condition should apply to this field everywhere, always." | The Extra Filter grid in Fields and Entities Settings — the quick, always-on version of the one above. |
Field Filtering by DimensionLet a lookup reach records of other branches, legal entities or departments — Prevent Filter By versus Ignore Login, field by field.Field Filter with CriteriaNarrow what a lookup offers with a criteria definition or a Tempo condition — with worked examples such as offering only items in stock.