You can search your purchase invoices from the Purchase Management page. Open the search panel to find purchases by supplier, receipt number, description, supplier reference, receipt scans, date, amount, currency, status or project tag.
You can fill in one field or several. Below is a table outlining each field and its capabilities, followed by more detail on how each one matches what you type.
The results appear under the panel, with a line showing how many purchases were found and their total amount. If nothing matches, the page shows No Items found. Click Cancel Search to clear the search and show all your purchases again.
Capital or lower-case letters make no difference in any of the text boxes.
Please note: some fields support “Enhanced Search” methods where you can apply partial matching and phrase matching.
| Field | Description | Search Type |
|---|---|---|
| Supplier Name | The business name for your supplier | Whole word match, not case sensitive. Several words must all be present in the order typed. Put * at the end of a word to match the start of it. Contact names are not searched. |
| Receipt Number | The QuickFile assigned incremental receipt number | Exact string match. Type the full number including QF. |
| Description | Searches the text in all the lines of the purchase. | Enhanced search - whole word match, use * at the end of a word for partial matching. |
| Supplier Ref | The supplier reference assigned to the purchase invoice | Exact string match. Type the whole reference. |
| Receipt scans | Does the purchase have one or more attached receipts | Tick with, without or both to include purchases that have, or have not got, a receipt attached. |
| Receipt Date | The receipt date for the purchase invoice | From, to or between supplied dates. |
| Amount Range | The total of the purchase invoice, including VAT | From, to or between the supplied amounts. |
| Currency | The currency of the purchase invoice | Choose a currency from the list. |
| Status | The current status of the purchase invoice | Select from the list of statuses. |
| Project tags | Does the purchase invoice have any project tags? | All, Untagged or Tagged. With Tagged, you can also type the name of a tag. |
Type the supplier’s business name, or part of it, in Supplier Name. The search matches whole words.
Acm* returns every supplier whose name has a word starting with Acm. An asterisk at the start of a word does not work.Supplier Name searches business names only. The words AND, OR and NOT do not work as operators here, so Acme OR Google returns nothing, and the names of supplier contacts are not searched.
Both boxes need the whole value. Part of a value does not match, and a * does not work in either box.
Description searches the text of every line of the purchase, not only the first line, and not the supplier’s name. It supports Enhanced Search methods. See Enhanced Search Fields for more about them.
boil* returns the same purchases as boiler. The asterisk must be at the end of the word.The Purchase Name column in the results shows the first line of the description, so Description finds it too.
Receipt Date and Amount Range each have a From and a To box. Fill in either box or both. The dates and amounts you enter are included in the results.
To fill in both dates from a list, click [preset range] under Receipt Date. The pop-up has the tabs Accounting Years, Months, Quarters, Calendar Years and Custom.
Choose a value from the Status list: ANY, UNPAID, PAID IN PART, PAID IN FULL, OVERDUE, VAT EXEMPT, VAT OUT OF SCOPE, CREDIT or CREDITED.
Under Project tags, choose All, Untagged or Tagged. Tagged shows a Tag name box. Leave it empty to list every tagged purchase, or type the whole name of a tag to list only purchases with that tag. The name is not case sensitive, but it must be the whole tag, so project does not find a tag called project-1.
A purchase is returned only if it matches every box you have filled in. For example, a Supplier Name of Acme with a Description of boiler returns only Acme purchases that mention a boiler, and a Receipt Number of QF00023 with a Supplier Name of Google returns nothing, because that purchase is from a different supplier.
Tip: To find one particular purchase, use its full Receipt Number on its own, or a Supplier Ref on its own.
Supplier Name, Receipt Number, Supplier Ref and Tag name need whole words or whole values, so part of a word returns nothing. To match the start of a word in Supplier Name or Description, put an asterisk at the end of it. Remember that every box you fill in must match.
The Receipt Number box needs the full number including QF, for example QF00023. To find a purchase from part of its number, use Quick Search.
Supplier Name searches business names only. Type the supplier’s business name instead.
AND, OR and NOT only work in Description, and only in capital letters. In Supplier Name, type the words you want to find in the order they appear in the name.
Several words without quote marks find purchases containing any of the words. Put a phrase in quote marks to find the words together and in order, or join words with a capital AND to require both.
Click Cancel Search to clear the search and show all your purchases again.
Find out more about searching in QuickFile.