Take control of your sequence numbers without touching the database

Safely edit sequence numbers on sales orders, purchase orders, invoices, bills and warehouse transfers — with full permission control, duplicate and gap detection, and a complete audit trail.

The problem

Once a sales order, purchase order, invoice, bill or transfer is confirmed or posted, Odoo locks its sequence number. Correcting a typo, aligning with a legacy system after migration, closing a gap left by a cancelled document, or reserving a number range means risky database edits or paid consulting. New online stores also start numbering at 1, so early orders and invoices display embarrassingly low numbers right when building customer trust matters most.

The solution

Edit Sequence Number gives permission-gated users a guided way to change the number on any of the five core documents, singly or in bulk, with live preview, duplicate and gap checks, and an immutable audit trail of every change. Configure per-warehouse formats and starting numbers, and show customers a separate, presentable reference number on their orders and invoices.

Capabilities

Everything you need to manage numbering safely

Every capability below is implemented in the module.

01

Edit locked numbers on five document types

Change the sequence number on confirmed sales orders, purchase orders, posted customer invoices, vendor bills and warehouse transfers — one module covering every core document.

02

Role-based permission control

Dedicated User and Manager groups decide who may edit numbering. Every document shows a clear authorization banner before anyone attempts an edit — no silent failures.

03

Complete change audit trail

Every edit records who made it, when, and the old and new value in an immutable log — so accountants can explain and defend any change during review or audit.

04

Duplicate-number validation

Any edit that would assign a number already in use is blocked automatically, protecting the integrity of your numbering.

05

Gapless numbering & compliance warnings

Optionally enforce uninterrupted numbering per company, and see a plain-language warning the moment an edit would create a gap — surfaced before you save, not discovered at audit.

06

Bulk re-numbering with preview

Select several documents from any list view and re-number them in one guided operation, with the full before-and-after result shown before you commit.

07

Customer-facing number, separate from internal

Keep an internal tracking number while showing customers a distinct, presentable reference on Sales Order and Invoice PDFs.

08

Format & starting-number configurator

Set prefix, suffix, zero-padding and starting number per document type and per warehouse operation, with a live preview of how the number will render — no coding required.

09

Searchable change history log

Browse every sequence edit grouped by document type, with filters for single edits, bulk operations, format changes and today's activity.

Workflow

How it works

1

Open the document

Open any sales order, purchase order, invoice, bill or transfer and see an instant authorization and status indicator.

2

Launch the guided wizard

Click Edit Sequence Number, or select several records and use the bulk action, to open the current-to-new preview.

3

Validate and confirm

The wizard checks for duplicates and gaps, shows a compliance warning if needed, and asks for a reason before saving.

4

Review the audit trail

The change is recorded immediately in the searchable Change History log for future review or audit.

Questions

Frequently asked

No sales fog. If your question isn't here, email us and we'll answer it the same way.

Sales orders, purchase orders, customer invoices, vendor bills and warehouse transfers — the five core documents most back offices need to renumber.

Get the app

Buy it on the Odoo App Store

Purchase, download and install directly from the official Odoo Apps Store — you'll always get the latest supported build.

Sales, Purchase, Warehouse & Accounting — Edit Sequence Number

Correct locked numbers on sales, purchase, invoice, bill and transfer documents with role-based permissions, duplicate and gap checks, bulk re-numbering with preview and a searchable audit trail.

Buy on Odoo App Store