Skip to content

Quote and invoice fields

Quotes, invoices and credit notes have their own set of custom fields, separate from the client's and the contact's. There are two kinds:

  • Document fields hold one answer for the whole document: a purchase order number, the sales rep who made the sale, the job site.
  • Line fields hold one answer on each line: the date the work was done, a serial number, whether the line is billable. A line field can be printed as a column of the document's lines.

Every document has the same set, and each field can be limited to the kinds of document it belongs on.

Who can do this

Filling them in: anyone who can make or edit quotes and invoices, within their Custom Field View Level and Custom Field Edit Level. Adding, changing and deleting the fields: Manage Custom Fields.

Add and manage the fields

Open Settings › Quote & Invoice Fields.

  • Add Field: give it a name and a type, and the lowest access level that sees and edits it. A new field goes to the top of the list.
  • Which documents it's on: tick Quotes, Invoices and Credit Notes as needed. A PO number might be on invoices only; a sales rep on all three. A field shows, prints and is filled in only on the documents it is on.
  • Drag a field to move it. The order here is the order on the quote and invoice form.
  • Edit a field to rename it, change its level, its options and their colours, or which documents it's on.
  • Delete a field to remove it and its value from every document. This can't be undone. If any quote, invoice, line, recurring line or standard line item has a value in it, BaseCloud tells you how many first and asks you to confirm. Deleting one of a choice field's options empties it on the lines that had it.

The page has a Document fields list and a Line fields list, each with its own Add Field.

A document field's types are text, long text, number, amount (with a currency), date, time, checkbox, single and multiple choice, user (one of your team, such as a sales rep) and location, plus headings, spacing and lines to lay the form out. A line field fits in a cell of the line, so it is text, date, time, number, checkbox or single choice. Files, buttons and client references are for client fields only.

A line field has one more setting: Include on the printed document — see Print them on the document.

Sort your lines for reports

To sort lines for reporting — by department, region, job type or income type — add a single choice line field with an option for each. Add as many as you need. Your reports and books reports can split lines by any of them and filter by any field.

These used to be called tracking categories, on their own page in Settings, with at most two. Each one was moved into a single choice line field of the same name, with the same options, and every line, recurring line and standard line item kept its answer. Workflows that read them keep working.

A document field can wait on another field of the same document, and only show once that one is answered a certain way — see Show a field only when another is answered.

Fill them in

When you make a quote or invoice, the document fields are under the date, due date and reference, and each line field is a column of the lines, after the account. Fill in what you need and save as usual. Only the fields on the kind of document you save are kept: save as a quote, and an invoice-only field is left out.

A client's recurring lines have the line fields that are on invoices too: each invoice the recurring billing makes starts its lines with their recurring line's answers. Its document fields start empty.

A standard line item can hold line field answers too, set on the Standard Line Items page in Settings. A line you pick the item for starts with them, and you can change them on the line.

Open a saved quote or invoice and its fields are all there: the document fields above its lines, each with its answer or Not set, and each line field as a column of the lines table. Click an answer to change it, the way you change a client's custom fields: type or pick, then click away or press Enter, and it saves. A Yes/No field is a tick box that saves as you tick it. You can also change them all at once with Edit, which opens the lines.

The fields of a paid, part-paid or reconciled invoice, and of a credit note, can still be changed this way, though their lines can't. Only a void document can't be changed at all. Your books reports read a line's fields as they are now, so a change shows in them straight away.

To set a field on many documents at once, select them on the Accounting page and use Bulk edit. A line field is set on every line of each one.

Duplicate copies the fields you're allowed to change, with the lines. Turning a quote into an invoice keeps them all — it is the same document. A credit note made from an invoice takes the invoice's answers in the fields that are on credit notes, and each line it credits takes that line's.

Changing a field is written to the client's notes like any other edit — which field, from what to what, and who changed it — and starts the account's Quote / Invoice Edited automations, on a paid invoice too. A field above Level 1 is the exception: the note says a field was changed, without its name or what it holds, because everyone who can see the client can read the note.

If someone else changed the document after you opened it, your save isn't made: BaseCloud asks you to reload it and make your change again.

Each field has a placeholder, {{invoice_field_<id>}}, that you put in a layout where it should print. Settings › Invoice Layout lists your fields with their placeholders. A choice prints its option's name, a user their name, a checkbox Yes or No, and a date as the document prints its dates. A field that is empty, or not on that kind of document, prints nothing.

A line field marked Include on the printed document gets its own column in the document's lines, after the description, headed by the field's name — on the PDF, and under each line on the online payment page. Like the Discount column, it appears only on a document where at least one line has an answer in it. A line field not marked is for you only: it never appears on the PDF or the payment page.

A field above someone's Custom Field View Level prints blank on the copy they open, as client fields do.

Find documents by them

On the Accounting page, filter the list by a document field: a choice by its options, a checkbox ticked or not, a date by the same list of ranges the page's own date filters use (Today, This Month, Last 7 Days and so on, with Custom for your own From and To), a time or number between two values, text containing what you type. A range such as This Month is worked out each time the list loads, so a filter you save keeps meaning the current month. Selecting all and acting on them, or Export, uses the same filter. The export file has a column for each document field you can see.

To see a document field in the list, add it as a column: someone with Manage Users clicks ⋮ on a column's name and picks Add Column Left or Add Column Right. Click the column's name to sort by it. See Choose the columns.

On a Sales report card, filter the lines by a line field as you would by an item code.

Use them in automations

Every Quote / Invoice trigger and the BaseCloud Accounting task give each field on the document as two outputs: quote_invoice_field_<id> reads as a person would (an option's name, a user's name, Yes or No), and quote_invoice_field_<id>_value as it is stored (an option's ID, a user's ID, 1 or 0). An empty field is empty.

Each line field is quote_invoice_line_field_<id> (and _value): one answer per line, in the lines' order, joined with | like the other line outputs. A line with no answer leaves its place empty.

An automation can fill them in, too. The BaseCloud Accounting task's Create Quote and Create Invoice take an answer for each field, and Edit Quote / Invoice changes them, on a paid invoice too. A line field takes one answer per line separated by | (Service||Sales), or one answer for every line. See Filling in quote and invoice fields.

With an AI app

A connected AI app can add and change these fields (create_custom_field and update_custom_field with the entity invoice for a document field or invoice_line for a line field, which documents a field is on, and whether a line field is printed), and fill them in when it makes a quote or invoice (custom_fields on create_quote, create_invoice and create_invoices, and on each of their lines, by name). It can fill them in or change them later with update_invoice, also on a paid invoice or a credit note, whose lines and amounts stay as they are. A blank answer clears a field. get_client_context shows each document's and recurring line's answers. It never deletes a field.

Importing old documents takes them the same way: custom_fields on an invoice row and on each of its lines.