I come from Oracle Application (eBusiness Suite) world and I see a missing feature when creating a sales invoice.
To avoid numbering holes Oracle Ebusiness Suite provide a temprorary sequence number as invoice number until this invoice is submitted, then it takes the final invoice number with the right sequence.
I think we can use this workflow :
- When creating a new sales invoice : set a temporary sequence number which can contain holes
- When Sales invoice is submitted : replace the temporary invoice number with the right sequence number
With this, when we delete a draft invoice we don’t have any holes in the numbering sequence.
Do you see any issue to implement this workflow ?