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,
