Not Exists Query

Dynamics AX offers practical functions to search for and filter data. With the possibility to link additional tables in the filter form, the tool allows almost unlimited possibilities to search for data. There are, however, some limitations: if tables in the filter form are linked, a corresponding record in the table attached is required (exists join).
With the "Not Exists Query" add-on, records for which there are no records in the table attached can be found quickly in a very simple way (not exists join).

Features

* Easy to use: The tool is integrated into the standard filter mask. For any linked table, the mode can be changed from „exists join" to „not exists join".
* The "not exists join" setting is saved, just as all other filter settings.
* Access rights: It is possible to restrict the access to the tool to certain users.

Examples of use

* Find clients for which no contact person has been entered into the system (see illustration).
* Search for items without record in the bar code table.
* View sales orders without positions.
* Find suppliers from whom nothing has ever been ordered.

Localisation info

Available in English and German

Info url

http://www.dynamics-ax-addons.com/en/dynamics_ax_add_ons/not_exists_query.html