Skip to content

Setting up numbering series

What is a series and what is it for?

A series is a counter of document numbers. When you issue an invoice, you don’t choose the number: it comes from the series, consecutive and with no gaps.

Series are for separating numberings that the law or your organisation require to be kept apart. The usual cases are opening one series per year, so that the numbering starts again in each financial year, and keeping corrective invoices in their own series, because a credit note can’t share numbering with the invoices it corrects.

They are set up in Settings → Document series.

Why do I see the same series ‘A’ repeated in the list?

Because it isn’t the same one. What sets it apart is the Document type: each one has its own numbering, even if the series code is written the same. That is why the list is grouped by that field and each group shows its series.

Series ‘A’ for invoices and series ‘A’ for delivery notes are two different counters, and each one goes at its own pace: invoice A being at 340 has nothing to do with where delivery note A is. You can see it in Counters, which shows where each one is.

And if you work with several companies, each company has its own series and its own counters: the screen shows those of the active company, and what one company invoices doesn’t move the numbering of another.

When you want to change something, look at the group first: it is what tells you which counter you are talking about.

Why don’t all the series appear?

Because the list sets aside two kinds of series you don’t usually need to touch:

Below the search box, the Also show internal and unused series box shows them all and tells you how many are set aside. A new series appears in the list as soon as it numbers its first document.

Where do I choose the series for corrective invoices?

At the top of the screen, in Corrective invoice series. Type the code and click Save, the blue button next to the field (it is only enabled if you change the series). By default it is ‘R’.

In Spain every correction of an invoice already issued is a corrective invoice: a credit note, a return of goods on a separate invoice and the invoice that replaces another. The law requires them to be numbered in a series different from that of the invoices. That is why:

The series appears in the list, in the Sales credit note group, marked as default.

How do I create a new series?

Click New series, choose the document type, type the series code and save.

The code is always saved in capitals and with your company’s series length: ‘a’, ‘A’ and ‘A0’ are the same series. That way you don’t end up with two counters because of a difference you can’t see when typing.

As you type the code you will see the prefix, the number length and the suffix fill in on their own with the format your company uses: the series first and the remaining digits up to the total length of the document number. With series Z and the factory values, the first document will be Z00001. It is the same format series get when they are created on their own as you issue, so that they all number alike wherever they come from. If you change it by hand, yours wins and nothing else is suggested.

How many characters does a series have?

As many as Characters taken by the series says, in Settings › Codes. By default there are two, as in the Desktop ERP.

Mind what that setting measures: it is how much the series takes inside the number, not the whole number. The complete number is set by the one next to it, Total length of the document number: with series 2 and total 6, the third document in series ‘A’ is ‘A00003’.

If you type a shorter series, it is padded with zeros on the right: with length 2, series ‘A’ is ‘A0’. The two don’t exist at the same time. A series longer than the length isn’t accepted: the program doesn’t cut it down on its own, it tells you it doesn’t fit.

What is printed on the document doesn’t change because of this. The number comes out with the series prefix: a series ‘A0’ with prefix ‘A’ still prints A000001.

Change the series length only before you start issuing. With documents already issued, their series would keep the earlier length.

How do I change series when making a document?

In the Document field in the header, type just the series and press Enter. The document moves to that series and suggests its next number, as in the Desktop ERP.

If the series doesn’t exist for that document type, the program warns you and the document stays in the one it had: a typo doesn’t open a new counter. Create it first on this screen. If you prefer a new series to be created on its own when you type it, turn it on in Settings › Codes with Create the series when typed in the document.

On an invoice that is still a draft you can also change the series. It is numbered in the series it has when you issue it.

A new series starts at zero: the first document you issue with it will be number 1.

If it is the first series for that document type, it is marked as default automatically. If it weren’t, that type wouldn’t have any series to suggest when creating a document.

How do I change the number format?

In the series detail you have three fields that decide how the number looks, and a preview that shows you the result before saving.

The three together give FV000042/26. The Will look like preview shows you exactly that, with the series’ real next number.

Changing the format doesn’t change documents already issued: it only affects the ones issued from now on.

Why can’t I change the last number?

Because Last issued is the record of what has already been issued, and changing it by hand breaks the numbering.

If you lowered it, the next invoice would repeat a number that is already on an issued invoice. That is exactly what consecutive numbering must prevent, so the field is shown but can’t be edited: the program keeps it up to date each time it issues a document. What you can see next to it is the Next number, which is where it will carry on from.

If the number isn’t the one you expected, it is almost always because you are in another series or in another financial year.

Can I change a series’ code?

Only while it hasn’t numbered any document. As soon as a series issues its first document, its Series code is fixed.

The reason is the same as for the last number: that code is stamped on the documents already issued, and on the number the customer has printed. Renaming the series doesn’t renumber them; all it achieves is that what was issued refers to a code that no longer exists.

If you try, the program rejects it and tells you how many documents that series has numbered. To start numbering with another code, create a new series and mark it as default. The earlier one keeps its history.

The rest of the series —prefix, length, suffix, active or not— can always be changed.

What is the default series?

It is the one the program suggests when creating a document of that type.

There can only be one per document type. When you mark one, the one that was default stops being so: it is done in the same step, so that no type is left without one.

To change it, select the series you want and click Mark as default, at the top right. A deactivated series can’t be the default.

What is ‘Show with VAT’ for?

For a series for selling to the public (counter, shop). Documents made in a series with this box ticked start with prices including VAT: they are typed and shown with VAT and the base is worked out backwards. It takes priority over the customer record and over your company’s setting.

Changing series on a document already started also applies it, and each line keeps its total. It is explained in full in How do I sell with prices including VAT?.

Why doesn’t my new series start at 1?

Almost always for the same reason: one of your series has no prefix, so its numbers are printed the same as another’s.

If series A has already issued 000001 and your new series is also going to issue 000001, they would be two different invoices with the same printed number. That can’t happen, so the program moves on to the first free one. That is why you see jumps like 000009 in a newly created series.

The solution is for every series to carry a prefix, on its record: with A00001 and C00001 there can be no clash and each series starts at its number 1. That is what the prefix is for: so that the number says which series it belongs to.

New series are already born with theirs, so this will only happen with older ones or with those whose prefix you removed by hand.

The Next you see on each series card already takes this into account: it is the number that is going to be issued, not the next one on the counter.

‘This series is going to repeat numbers’: what it means and how to fix it

That the series counter has fallen behind the documents it already has. It happens when documents come in without going through the program’s numbering: imported history, or data loaded by hand. The series thinks it is at 7 and in fact already has a document with 42, so the next invoices would repeat numbers that already exist.

You fix it with the Adjust the counter button on that same card: it puts the counter above the highest number it already has. It only goes up, never down.

Two things worth knowing:

What does ‘N issued’ count on a series card?

The documents actually issued with that series. Drafts don’t count: they have the series set, but their number is still provisional.

Watch out for something that can be confusing: that number doesn’t have to look anything like the ‘Next’. A series without a prefix that starts at the first free number starts higher up — it can have one document issued and the next one be 000010, because 1 to 9 were already used by other series.

The number the screen suggests when creating the document already takes this into account, so it is the one that is going to be saved.

What about the ‘Default series’ in Settings → Codes?

They are the fallback, not the ones that take priority. As long as a document type has a series marked as default here, that is the one used and the one in Codes plays no part. The ones in Codes only come into play for the types that don’t yet have any series marked.

And there are three, one per scope, because the counters are kept separate:

Field in CodesWhich documents it affects
Default series (sales)Customer quotes, sales orders, delivery notes and invoices
Default series (purchases)Supplier orders, goods receipts and invoices
Default series (production reports)Production reports

If you change the sales one and your purchase orders stay the same, it isn’t a fault: each scope reads its own.

Put the other way round, which is how it is usually asked: if you change the series in Codes and your invoices keep coming out in the usual one, it isn’t a fault — those invoices already have their series here. Change it here.

How do I stop using a series?

It is deactivated, not deleted: untick Active series on its record and it changes from Active to Inactive in the list.

An inactive series is no longer offered when issuing new documents, but it keeps its counter and its history. It is what you do when closing the year with a series per financial year. The Active count at the top only includes the ones that are offered.

Series are never deleted, and on purpose: the counter is the proof of which numbers have been issued. If it were deleted, the numbering would start again and repeat numbers that are already on real documents.

For the same reason you can’t deactivate the series that is marked as default: it would leave that document type suggesting a series that is no longer offered. First mark another one as the default.

What is on the Rules tab?

Each series record has two tabs: Numbering, with its fields, and Rules, which can’t be edited. There, one line each, are the five rules that govern the numbering and explain why the program lets you do some things and not others:

It is the place to look when the program rejects something and you don’t know why.

What happens if I don’t set up any series?

Nothing happens: when the company is created you already have a default series for each document type that needs one. And the first time you issue a document of a type, if its default series didn’t yet have a counter, the program creates it and starts at number 1.

This screen is for what the automatic setup can’t decide for you: which prefix your invoices have, how many digits you want, or which of your series should be suggested by default.

More about Invoicing