* Table Filter
* Filter
The Table Filter is simple to understand: it filters on information found in any one given table. A Table Filter can be used, for example,to limit the customers shown in the Customer Card to include only those customers located in
Both the Field Filter and Table Filter tools can be used to define a Table Filter, the difference is that the Field Filter shows only a part of the filtering process—that is, a single field at a time.
* It is highly recommended by the authors that you use the Table Filter as opposed to the Field Filter. If you use the Table Filter you will see all of the filters that are set on a table simultaneously. On the contrary, the Field Filter will show you one field at a time—the field which your cursor is presently on. Not knowing which filters are acting on a table at any one time can produce incorrect results and undesirable mysteries.
The second type of filter, the Flow Filter is more complex than the Table Filter. Flow Filters control the evaluation of calculated fields in Microsoft Navision. These filters limit the set of information taken from a foreign table to be evaluated and then entered into a calculated field. In Microsoft Navision these special calculated fields, Flow Fields, are influenced by Flow Filters. Examples of Flow Fields include: Inventory, Net Change and Balance. The values of such fields are always current, always subject to change and can differ based on what Flow Filters have been set on them. Examples of Flow Filters that you can use to determine these Flow Fields are: Date Filter, Department Filter, Project Filter, Budget Filter and the Dimension Flow Filters.
Posts
