Subsequence Generator for Sequences
Automate date range generation with Smart Numbering & Overlap Detection!
Managing multiple date ranges for sequences in Odoo (such as in Invoices, Sales Orders, or Journals) can be a tedious and manual task, especially when you need to create ranges for every month or week.
This module provides a powerful Subsequence Generator Wizard to create dozens of ranges instantly. It features a Smart Numbering logic that ensures your current period continues from the existing number while future/past periods start fresh from 1.
It also includes an Overlap Detection system that warns you if any date ranges conflict with each otherâpreventing sequence numbering issues before they happen.
Current Period: Continues Sequence
Future/Past Periods: Starts at 1
Safety Check:
"Real-time overlap conflict detection"
Key Features
Bulk & Smart Generation
Generate subsequences for a whole year. Smart numbering automatically handles current vs future periods.
Overlap Detector
Sophisticated logic to detect if any date ranges partially or fully overlap within the same sequence.
Visual Indicator
Overlapping ranges are highlighted in Red in the list view, with a header alert in the form view.
How to use
1. Go to Settings > Technical > Sequences & Identifiers > Sequences.
2. Open a sequence that has the "Use subsequences per date_range" option checked.
3. Click the "Generate Subsequences" button in the header.
4. Set your Start/End dates and Interval, then click Generate.
5. The system will handle the Next Number automatically based on today's date.
Support & Contact
Need help or custom features? Reach out to us!
Visit Developer Website
Please log in to comment on this module