Skip to Content
Odoo Menu
  • Sign in
  • Try it free
  • Apps
    Finance
    • Accounting
    • Invoicing
    • Expenses
    • Spreadsheet (BI)
    • Documents
    • Sign
    Sales
    • CRM
    • Sales
    • POS Shop
    • POS Restaurant
    • Subscriptions
    • Rental
    Websites
    • Website Builder
    • eCommerce
    • Blog
    • Forum
    • Live Chat
    • eLearning
    Supply Chain
    • Inventory
    • Manufacturing
    • PLM
    • Purchase
    • Maintenance
    • Quality
    Human Resources
    • Employees
    • Recruitment
    • Time Off
    • Appraisals
    • Referrals
    • Fleet
    Marketing
    • Social Marketing
    • Email Marketing
    • SMS Marketing
    • Events
    • Marketing Automation
    • Surveys
    Services
    • Project
    • Timesheets
    • Field Service
    • Helpdesk
    • Planning
    • Appointments
    Productivity
    • Discuss
    • Approvals
    • IoT
    • VoIP
    • Knowledge
    • WhatsApp
    Third party apps Odoo Studio Odoo Cloud Platform
  • Industries
    Retail
    • Book Store
    • Clothing Store
    • Furniture Store
    • Grocery Store
    • Hardware Store
    • Toy Store
    Food & Hospitality
    • Bar and Pub
    • Restaurant
    • Fast Food
    • Guest House
    • Beverage Distributor
    • Hotel
    Real Estate
    • Real Estate Agency
    • Architecture Firm
    • Construction
    • Property Management
    • Gardening
    • Property Owner Association
    Consulting
    • Accounting Firm
    • Odoo Partner
    • Marketing Agency
    • Law firm
    • Talent Acquisition
    • Audit & Certification
    Manufacturing
    • Textile
    • Metal
    • Furnitures
    • Food
    • Brewery
    • Corporate Gifts
    Health & Fitness
    • Sports Club
    • Eyewear Store
    • Fitness Center
    • Wellness Practitioners
    • Pharmacy
    • Hair Salon
    Trades
    • Handyman
    • IT Hardware & Support
    • Solar Energy Systems
    • Shoe Maker
    • Cleaning Services
    • HVAC Services
    Others
    • Nonprofit Organization
    • Environmental Agency
    • Billboard Rental
    • Photography
    • Bike Leasing
    • Software Reseller
    Browse all Industries
  • Community
    Learn
    • Tutorials
    • Documentation
    • Certifications
    • Training
    • Blog
    • Podcast
    Empower Education
    • Education Program
    • Scale Up! Business Game
    • Visit Odoo
    Get the Software
    • Download
    • Compare Editions
    • Releases
    Collaborate
    • Github
    • Forum
    • Events
    • Translations
    • Become a Partner
    • Services for Partners
    • Register your Accounting Firm
    Get Services
    • Find a Partner
    • Find an Accountant
      • Get a Tailored Demo
    • Implementation Services
    • Customer References
    • Support
    • Upgrades
    Github Youtube Twitter Linkedin Instagram Facebook Spotify
    +32 2 290 34 90
    • Get a Tailored Demo
  • Pricing
  • Help
  1. APPS
  2. Technical
  3. Sequence Date Offset & Advanced Placeholders | Dynamic Sequence Rules Engine | Advanced Sequence Automation | Sequence Enhancement: Flexible Date Offsets v 17.0
  4. Sales Conditions FAQ

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/
Odoo

$ 14.90

v 17.0 Third Party
Apps purchases are linked to your Odoo account, please sign in or sign up first.
Availability
Odoo Online
Odoo.sh
On Premise
Lines of code 117
Technical Name sequence_date_offset
LicenseOPL-1
Websitehttps://www.techultrasolutions.com/
Versions 16.0 17.0 18.0 19.0
You bought this module and need support? Click here!
Availability
Odoo Online
Odoo.sh
On Premise
Lines of code 117
Technical Name sequence_date_offset
LicenseOPL-1
Websitehttps://www.techultrasolutions.com/
Versions 16.0 17.0 18.0 19.0
  • Description
  • License

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
Email Us Skype Us

▶  Watch Module Demo

See how Sequence Date Offset & Advanced Placeholders | Dynamic Sequence Rules Engine | Advanced Sequence Automation | Sequence Enhancement: Flexible Date Offsets works

Watch Module Demo on YouTube
▶  Watch on YouTube
  • Screenshots
  • Features
  • Support
  • FAQs

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.

Can I customize the sequence format?

Yes, you can define your own prefix and suffix using placeholders like year, month, and day.

Can I increase or decrease date values in the sequence?

Yes, you can apply both positive and negative offsets (e.g., %(year+1)s or %(month-1)s) to modify date values.

Is this module compatible with standard sequence functionality?

Yes, it extends the default sequence behavior without breaking existing features.

Does it impact system performance?

No, the module is lightweight and designed to work efficiently with standard sequence generation.



Related Products


HDFC Vendor Payment Integration
Odoo Product Personalizer | Web-to-Print Studio | Product Editor, Designer & Customizer | Web2Print
RingCentral Integration
Odoo Direct Print via Printnode
Face Recognition Attendance System
Portal User Chatter
LinkedIn Integration
AI Inventory Forecast | Odoo V19 Enterprise & Community
Face Capture On Attendance System
Data Offload / External Archive Manager
ODOO JSON RPC
Discuss Search
Show Hide Send Message Button
Stock Inventory Counting
Odoo Pos Select Product Location
List Column Reorder (Per User)
Web Select All Companies
Show Optional Columns
Add Bulk Products in SaleOrder
Advanced Employee Image Exporter
Advanced Many2Many Binary Upload
Product Image Import
Portal User Edit QTY and Delete Lines on Quotations
Restrict chatter Edit and Delete
Odoo Meta WhatsApp Base
Odoo Facebook Instagram Messenger
Odoo Meta WhatsApp Discuss
Odoo Meta WhatsApp Marketing
Odoo Meta WhatsApp CRM
All In One Odoo WhatsApp Integration
Odoo Meta WhatsApp Sale
Odoo WhatsApp Invoice
Field Service Multi Worksheet
Manual Currency Rate for Sale Order, Purchase Order, Invoice, Bill & Payment
POS Close Session From Backend
Email Cc
Export Partner Ledger Report
Odoo Split View
PDF Split and Merge
Outgoing Mail by Multi Company or User
Our Apps
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.

Please log in to comment on this module

  • The author can leave a single reply to each comment.
  • This section is meant to ask simple questions or leave a rating. Every report of a problem experienced while using the module should be addressed to the author directly (refer to the following point).
  • If you want to start a discussion with the author or have a question related to your purchase, please use the support page.
Community
  • Tutorials
  • Documentation
  • Forum
Open Source
  • Download
  • Github
  • Runbot
  • Translations
Services
  • Odoo.sh Hosting
  • Support
  • Upgrade
  • Custom Developments
  • Education
  • Find an Accountant
  • Find a Partner
  • Become a Partner
About us
  • Our company
  • Brand Assets
  • Contact us
  • Jobs
  • Events
  • Podcast
  • Blog
  • Customers
  • Legal • Privacy
  • Security

Odoo is a suite of open source business apps that cover all your company needs: CRM, eCommerce, accounting, inventory, point of sale, project management, etc.

Odoo's unique value proposition is to be at the same time very easy to use and fully integrated.

Website made with