Has anyone experienced that the Accounting Date / Booking Date on Vendor Bills is not always adjusted automatically when the Invoice Date is from the previous month, even though the previous month is not locked?
In my tests, it seems that the behavior might be affected by whether the month number is included in the sequence. However, the correlation is not always clear, and from a functional accounting perspective this would not really make sense to me that the sequence affect the function.
V19 enterprise
Thanks in advance
I understand the frustration—it's confusing because Odoo removed the traditional 'Sequence' configuration menu entirely in recent versions.
In V19, the 'sequence' isn't a setting you check in a menu; it’s a behavior the system learns from your manual edits. The reason you’re seeing inconsistent date behavior is that Odoo 19 uses Hashed Chronology. If your sequence includes a month (e.g., /05/), Odoo technically 'binds' that bill to May. If you then try to set an April Invoice Date, Odoo blocks the Accounting Date from moving backward because it won't allow a 'May-labeled' sequence to exist in the 'April' accounting period.
To fix the 'it doesn't work without it' part:
If you want the sequence to stop resetting monthly and let your dates move freely:
Reset your latest bill to Draft.
Manually rename it to a yearly format (e.g., change BILL/2026/05/0001 to BILL/2026/0001).
Confirm it.
Once the month is gone from the sequence string, Odoo stops 'period-locking' the bill, and the Accounting Date will follow the Invoice Date much more consistently. In V19, the Bill Number itself is effectively the configuration field.
Note on Customization:
If your business workflow strictly requires both a monthly-resetting sequence and the ability to backdate accounting entries without restriction, the 'out-of-the-box' logic in V19 may be too rigid. This behavior is rooted in Odoo's sequence_mixin. If the manual adjustments above don't solve it, a small Python customization to override the _get_last_sequence method can decouple the naming convention from the posting date logic entirely.
Let me know if you need any help with implementing this or with the technical override!
Hello Arnold,
Yes, that is generally correct from a standard Odoo behavior perspective.
Keeping the month in the journal sequence is usually considered a best practice, especially when sequences reset monthly. It helps Odoo maintain chronological consistency between posting dates and journal entry numbering.
As a result, Odoo may automatically align the Accounting Date with the Invoice Date period (or the last valid date within that period) to avoid sequence inconsistencies.
And yes, the Accounting Date is important because it determines:
the financial period impact on the P&L,
the tax reporting period,
and overall accounting period recognition.
That said, the exact behavior can still depend on the journal configuration, localization modules, and sequence setup in the specific database.
Regards,
Zehntech Technologies Inc.
santosh.sekwadia@zehntech.com