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.