Configuration

Set the following fields via the Journal Advanced Settings:

• Starting Sequence
• Refund Starting Sequence
• Sequence Override Regex

This is a regex that can include all the following capture groups: prefix1, year, prefix2, month, prefix3, seq, suffix.

The prefix* groups are the separators between the year, month and the actual increasing sequence number (seq).

e.g:

- Starting Sequence : INV2101000
- Refund Starting Sequence : RINV2101000
- Sequence Override Regex : (?P<prefix1>[A-Z]{1,})(?P<year>\d{2})(?P<month>\d{2})(?P<seq>\d{3,})

This expressions defines the following invoice numbering scheme : INVYYMMSSS whereby SSS will restart at 001 on a monthly basis.

This will result in the following invoice number for e.g. the third invoice of Februari 2021 : INV2102003

The following regex will be used if you do not set the Sequence Override Regex:

^(?P<prefix1>.*?)(?P<year>((?<=\D)|(?<=^))(\d{4}|(\d{2}(?=\D))))(?P<prefix2>\D*?)(?P<month>\d{2})(?P<prefix3>\D+?)(?P<seq>\d*)(?P<suffix>\D*?)$

Known issues / Roadmap

• auto-removal of Journal sequence_override_regex field.

The standard Odoo account module may set the sequence_override_regex field to Null in case of a non-matching regex. cf. https://github.com/odoo/odoo/blob/deb6a8877aeb4d6774a4632b470557ef87acdc3f/addons/account/models/account_move.py#L2250 This is a rather strange and confusing behaviour. We consider to change this behaviour and replace it by a clear error message so that the configuration can be corrected manually.

Credits