Sequence Date Offset & Advanced Placeholders | Dynamic Sequence Rules Engine | Advanced Sequence Automation | Sequence Enhancement: Flexible Date Offsets
by TechUltra Solutions Private Limited https://www.techultrasolutions.com/$ 14.90
| Availability |
Odoo Online
Odoo.sh
On Premise
|
| Lines of code | 117 |
| Technical Name |
sequence_date_offset |
| License | OPL-1 |
| Website | https://www.techultrasolutions.com/ |
| Versions | 16.0 17.0 18.0 19.0 |
| Availability |
Odoo Online
Odoo.sh
On Premise
|
| Lines of code | 117 |
| Technical Name |
sequence_date_offset |
| License | OPL-1 |
| Website | https://www.techultrasolutions.com/ |
| Versions | 16.0 17.0 18.0 19.0 |
Sequence Date Offset & Advanced Placeholders | Dynamic Sequence Rules Engine | Advanced Sequence Automation | Sequence Enhancement: Flexible Date Offsets
This module extends the default sequence functionality by introducing date-aware numbering logic and flexible configuration options. It allows users to define custom prefixes, suffixes, and offsets for document sequences. The system helps maintain structured and meaningful numbering across business documents. It integrates seamlessly with existing workflows to improve consistency and reduce manual effort. Ideal for businesses requiring more control over their numbering formats.
A flexible sequence management tool that generates dynamic document numbers using date-based logic and configurable rules. It enhances standard numbering with customizable prefixes, suffixes, and offsets.
https://wa.me/message/VENRAJRHMSWEB1
OR
1. Configure Prefix and Suffix in Sequences
After installing and activating the module, navigate to Settings > Technical > Sequences & Identifiers > Sequences and open Sales Order (you can choose any sequence as needed). In the Sequence section, you can define custom prefix and suffix values based on your requirements, as illustrated in the attached screenshots.
2. Sequence Generation in Sales Order
After that, create a Sales Order. You will see that the sequence is generated automatically based on the configuration you set earlier.
3. Updated Prefix with Incremented Date Values
Here, we updated the prefix by incrementing the year, month, and day values in the sequence configuration. As shown in the screenshot, the generated sequence reflects these updated date values accordingly.
4. Prefix with Decremented Date Values
Here, we configured another prefix by decreasing the year, month, and day values by one. As shown in the screenshot, the generated sequence correctly reflects the updated configuration.
5. Prefix and Suffix Configuration Result
Here, both prefix and suffix are configured as shown in the screenshot. The generated sequence matches the configuration perfectly, reflecting the defined format in the final result.
6. Prefix with Custom Date Offset Format
Here, the prefix is configured as INV/%(year+10)s/%(month+24)s/%(day+30)s/. As shown in the screenshot, the generated sequence correctly reflects the applied year, month, and day offsets in the final result.
- Dynamic sequence generation based on date components
- Support for custom date offsets (increase or decrease values)
- Flexible prefix and suffix configuration
- Ability to use expressions like %(year+X)s, %(month+X)s, %(day+X)s
- Easy configuration from sequence settings (no coding required)
- User-friendly and minimal configuration setup
- We provide 90 days bug-free support related to our module.
- We provide 5 hours of free configuration support. Additional configuration or customization is billable.
- The support team is available from Monday to Friday 10:00 AM to 07:00 PM (IST).
- To create a ticket, send an email to support@techultra.in.
Yes, you can define your own prefix and suffix using placeholders like year, month, and day.
Yes, you can apply both positive and negative offsets (e.g., %(year+1)s or %(month-1)s) to modify date values.
Yes, it extends the default sequence behavior without breaking existing features.
Related Products
Odoo Proprietary License v1.0 This software and associated files (the "Software") may only be used (executed, modified, executed after modifications) if you have purchased a valid license from the authors, typically via Odoo Apps, or if you have received a written agreement from the authors of the Software (see the COPYRIGHT file). You may develop Odoo modules that use the Software as a library (typically by depending on it, importing it and using its resources), but without copying any source code or material from the Software. You may distribute those modules under the license of your choice, provided that this license is compatible with the terms of the Odoo Proprietary License (For example: LGPL, MIT, or proprietary licenses similar to this one). It is forbidden to publish, distribute, sublicense, or sell copies of the Software or modified copies of the Software. The above copyright notice and this permission notice must be included in all copies or substantial portions of the Software. THE SOFTWARE IS PROVIDED "AS IS", WITHOUT WARRANTY OF ANY KIND, EXPRESS OR IMPLIED, INCLUDING BUT NOT LIMITED TO THE WARRANTIES OF MERCHANTABILITY, FITNESS FOR A PARTICULAR PURPOSE AND NONINFRINGEMENT. IN NO EVENT SHALL THE AUTHORS OR COPYRIGHT HOLDERS BE LIABLE FOR ANY CLAIM, DAMAGES OR OTHER LIABILITY, WHETHER IN AN ACTION OF CONTRACT, TORT OR OTHERWISE, ARISING FROM, OUT OF OR IN CONNECTION WITH THE SOFTWARE OR THE USE OR OTHER DEALINGS IN THE SOFTWARE.
Screenshots
Features
Support
FAQs
Please log in to comment on this module