This is an old revision of the document!
This is a quick reference guide for search paramters in SnapBill. The search box is located at the top left of your system interface. To use any of the searches simply type the suggested query directly into the search box.
Account State | Search Query |
---|---|
All inactive clients | state:new |
All active clients | state:active |
All suspended clients | state:suspended |
All deleted clients | state:deleted ; is:dead ; is:deleted |
All clients with past due invoices | Go to Billing > Past Due Warnings. Set “Unpaid invoice due date” > Find Clients. |
Although still stored on the system, it is important to note that deleted clients do not appear in regular client searches or reports unless specified. If you want to search for deleted clients always append your search with the search query provided above.
Invoice State | Search Query |
---|---|
Invoices in draft state | invoice:draft |
Invoices in unpaid state | invoice:unpaid |
Invoices in paid state | invoice:paid |
Invoices in pending state | invoice:pending |
Invoices in cancelled state | invoice:cancelled |
This search will give you a list of all clients who have invoices in “state” requested present on their account.
Quote State | Search Query |
---|---|
Quotes in a draft state | quote:draft |
Quotes in quote state | quote:quote |
Quotes in accepted state | quote:accepted |
Quotes in rejected state | quote:rejected |
This search will give you a list of all clients who have quotes in the requested state present on their account. Th “quote:quote” search will find the clients with quotes that have been issued, but have neither been accepted or rejected yet.
Credit Note State | Search Query |
---|---|
Credit notes in a draft state | credit:draft |
Credit notes in a credit state | credit:credit |
This search will give you a list of all clients who have credit notes in the requested state present on their account. The “credit:credit” search will give you a list of all clients who have an active credit note on their account.
Client Details | Search Query | Example |
---|---|---|
First name | Partial or full client name | John |
Surname | Partial or full surname | Smith |
Name and Surname | Both name and surname | John Smith |
Company Name | Partial or full company name | ACME Inc. |
Telephone Number | Full telephone number | 082 111 1111 |
Email Address | Full email address | john@smith.com |
Client Number | “number:” followed by a number | number:1421 |
Invoice Number | Full invoice number | 1234/0001 |
City | Only the name of the city | Cape Town |
Province/State | Only the name of the province | Western Cape |
Country | Only the name of the country | South Africa |
Postal Code | Only the postal code | 7000 |
These searches will return all clients with the request in both teh desired field and all others. For example a search for “Johannesburg” will return clients with “Johannesburg” in the city field, but also include clients with “Johannesburg” in the name, surname, company name and email address fields.
Special Client Fields | Search Query | Example |
---|---|---|
Created by import | import:number | import:013 |
Not created by import | !import:number | !import:013 |
With coupon code | coupon:code | coupon:BZ1234FR |
Not with coupon code | !coupon:code | !coupon:DISCOUNT |
Captured on day | created:yyyy-mm-dd | created:2012-08-04 |
Not captured on day | !created:yyyy-mm-dd | !created:2012-08-04 |
Captured before day | created<:yyyy-mm-dd | created<:2012-08-04 |
Captured before and on day | created⇐:yyyy-mm-dd | created⇐:2012-08-04 |
Captured after day | created>:yyyy-mm-dd | created>:2014-06-08 |
Captured after and on day | created>=:yyyy-mm-dd | created>=:2013-03-13 |
Captured on day only | created=:yyyy-mm-dd | created=:2013-09-10 |