hello,
I want to share an issue I am facing with Odoo regarding automatic draft Delivery Notes for Sales Orders, which can cause serious problems in sequence numbering and audit compliance.
Issue: Draft Delivery Notes and sequence gaps
*When a Sales Order is created, Odoo automatically generates a draft Delivery Note.
*A sequence number is assigned immediately, even though the Delivery Note is not validated.
*If this draft Delivery Note is later cancelled, the sequence number is consumed and cannot be reused, even if the BL never existed in reality.
*This can create gaps in the sequence and incoherence between BL numbers and actual delivery dates.
Example of the problem:
DL001 – validated on 10/03/2025
DL002 – draft created on 10/02/2025, then cancelled
DL003 – validated on 05/03/2025
Problems observed:
Sequence gap: BL002 never existed officially, but the number is consumed
Date mismatch: BL003 has a validation date earlier than the draft BL002
From a fiscal and audit perspective, this is risky because Delivery Note numbers must be continuous and chronological.
Question: Is there a way in Odoo to:
*Prevent draft Delivery Notes from consuming sequence numbers prematurely
*Ensure sequence numbers are assigned only when the Delivery Note is validated
Thnaks lot,
Hello,
It is not possible by Odoo standard way because delivery Notes are treated as operational documents, not fiscal ones, so the sequence number is assigned at creation - even in draft.
For audit purposes, cancelled and draft documents remain fully traceable and can be documented to explain sequence gaps.
Hope it helps
Thanks
You might be able to copy and adapt this approach (for separate sequence numbers for Quotations and Sales Orders): https://odootricks.tips/different-sequence-numbering-for-quotations/