Automatic invoice number

An invoice number...

• must be unique and should be sequential,

• can consist of numbers and letters,

• is used to uniquely identify an invoice and associate it with the corresponding incoming payment.

Below are two basic scripts. Both scripts can be used together if needed:

1. #assignment-of-a-unique-invoice-number

2. #subsequent-assignment-of-a-unique-invoice-number

Requirements

• a table Invoices

• in the Invoices table: a number field called Invoice number

Assign a unique invoice number

The easiest way is to store an invoice number right when creating a new invoice (when creating a new record).

How it works

Add the following script in the table settings under Trigger on new record:

'Invoice no.' := max((select Invoices).'Invoice no.') + 1 

To view

Tip: Lock field

Subsequently assign a unique invoice number

To assign a unique invoice number to existing records, the best way is to use a button. With one click, all missing invoice numbers will be added.

How it works

1. In the table settings, add a button from the layout fields.

2. In the button's field settings, copy the script to the On Click field.

3. Add the missing numbers by clicking the button.

let myInvoices := (select Invoices);
let maxID := max(myInvoices.'Invoice no.');
for invoice in myInvoices do
	if not invoice.'Invoice no.' then
		maxID := maxID + 1;
		invoice.('Invoice no.' := maxID)
	end
end

To view

Our template

Want to learn more about invoices? Then we recommend you download our Invoices template and browse through it a bit.

In the Invoices template you will find another script that also ensures unique assignment of invoice numbers.