Power search box for invoices

If you use Microsoft Outlook, you may have noticed that you can use keywords when searching for emails to narrow down the results. An example can be seen below:

Kompass uses similar keywords for more specific searches. You can use them on the Invoices page. For example, the search below returns all invoices with a net amount of $2,000 or less.

Keywords can be combined in one search. For example, posted-notes:migration client-ids:12,34 amount:<2000 returns invoices whose posted notes contain the word "migration", for the two clients with those IDs, with a net amount of $2,000 or less.

Some general rules for using those keywords:

  • Add the keyword followed by a colon ":" and then the search word.
  • Use a space to separate your search keywords.
  • The range fields are the ones that can be used like this "[range_field]:[from]-[to]". For example, "amount:500-1000". For an open-ended range, put "<" or ">" in front of the value: "amount:<1000" will show all invoices with a net amount up to and including 1000 and "amount:>1000" will show all invoices with a net amount of 1000 or more.
  • Write exact dates as YYYYMMDD or YYYY-MM-DD, for example "date:20230101" or "date:2023-01-01" for a single day, and "date:20230101-20231231" or "date:2023-01-01-2023-12-31" for all invoices issued in 2023.
  • There is also an extra feature for dates that always returns a specific period of time. Instead of a date as seen above, use a number of days, weeks, months or years counted from today: a minus sign means the past ("-10d" is 10 days ago) and no sign means the future ("14d" is two weeks from today). Some examples below:
    • date:>-10d (returns all invoices issued on or after the date 10 days ago.)
    • due:>-2w (returns all invoices due on or after the date 2 weeks ago.)
    • posted:>-3m (returns all invoices posted on or after the date 3 months ago.)
    • same for years (y)
  • When you are searching for text and it contains spaces, put it in quotes. For example: notes:"Brief:Topographical Survey".
  • You can exclude items from your search by adding a minus symbol "-". For example, "-name:almonte" will exclude any results with "almonte" in the name or "-tags:field,caution" will exclude all invoices with these tags.
  • When you have to provide a list of IDs, separate them with a comma. You can find the IDs of the items in the Kompass frontend (for projects, organizations and users) or in Kompass Admin (for client and project categories).

A list of all available keywords, with further details, is in the table below:

SINGLE VALUE FIELDS
FIELD DETAILS
submitted-notes notes left when user submitted the invoice
approved-notes notes left when user approved the invoice
posted-notes notes left when user posted the invoice
rejected-notes notes left when user rejected the invoice
voided-notes notes left when user voided the invoice
sent-notes notes left when user sent the invoice
details invoice details
name invoice name
reference invoice reference
notes internal notes on the invoice
tags invoice tags
ID BASED FIELDS
FIELD DETAILS
client-ids open each organization you want to filter and use the numeric ID in its URL. If more than one, separate them with a comma (,).
client-category-ids ask your Kompass administrator for the client category IDs you need. These can only be found in Kompass Admin.
project-ids open each project you want to filter and use the numeric ID in its URL, not the reference shown in the list. If more than one, separate them with a comma (,).
project-category-ids ask your Kompass administrator for the project category IDs you need. These can only be found in Kompass Admin.
project-manager-ids these need user IDs. Open each employee's record and use the numeric ID in its URL. If more than one, separate them with a comma (,).
created-by-ids
submitted-by-ids
approved-by-ids
posted-by-ids
rejected-by-ids
voided-by-ids
sent-by-ids
RANGE FIELDS
Range by date
FIELD DETAILS
date invoice date
due due date
start billing and timesheets start date
end billing and timesheets end date
created date each of the following steps was recorded
submitted
approved
posted
rejected
voided
sent
Range by amount
amount invoice net amount
payment amount paid against the invoice

You can save the other filters in the filter dialog as a filter set. The power search text itself is not saved with the set. See how to create a filter set here.

Did this answer your question? Thanks for the feedback There was a problem submitting your feedback. Please try again later.

Still need help? Contact Us Contact Us