• Search
  • Home /
  • Triumph eNews /
  • January 2017
  • /How to use Lookup Filters

News and Offers

Triumph ERP supports thriving WA business despite troubled economy


Western Australian owned and operated business, Kirby Marine, is traversing the challenging economic climate and is currently experiencing a boom, contrary to many other businesses in WA.

Read more ...

Now is the Time to Finance Your ERP Software Investment!


Here are 8 reasons why finance is a great option for your investment in new ERP software!

Read more ...

Triumph ERP Connecting Businesses Around the Globe

2e1ax timeless entry Steel

Triumph ERP has a reputation of being an advanced and versatile software solution for modern businesses. Triumph Client EastWest Steel Trading and Distribution is an excellent example of this.

Read more ...


Lookup Filters

Lookup Filters allow you to quickly and easily hone in on the information you're looking for. Being able to filter your results to narrow down a search is invaluable.

The filter button can be found in the top left corner whenever a lookup is called, be it a Debtor Account Lookup, a Creditor Account Lookup or a Master Stock Lookup etc. 

  1. If you click the plus plus symbol, you will be able to "Add Filter".
  2. Select a column to filter, then an operator such as 'Equals' or 'Contains' etc, then the value you're looking for.
  3. You can add multiple filters by clicking the plus symbol again,
  4. or remove one by clicking minus symbol.
  5. When ready click the apply button to narrow your search.
  6. Click removeall to clear all filters.
  7. Note that when you have multiple filters they are always 'and'ed together, e.g. Group Equals 01 AND Currency Equals USD.
  8. The most convenient way to add a filter is by right mouse clicking on the value you're looking for in the grid, and then clicking the quickfilter button. This will automatically create a filter to find everything equal to the value you selected.
  9. Add multiple Quick Filters as required.
  10. Intelligent and context sensitive filter type based on column, a date is Equal, a name is Contains etc.