Skip to Content

How to Automate Sequence Generation in Odoo and Avoid Manual Errors

Discover how to configure Odoo to automatically generate unique identifiers in your records, saving time and reducing errors.
August 5, 2025 by
How to Automate Sequence Generation in Odoo and Avoid Manual Errors
Wilfredo Fernando Pastor Avila
| No comments yet

The problem with manual identifiers

Imagine you manage a subcontracting company where each work order requires a unique identifier. Until now, you have been assigning these numbers manually, which not only consumes valuable time but has also led to errors, such as duplicates or gaps in the sequence. These errors, though they may seem minor, can cause confusion in project management and in communication with your customers.

The solution: Automatic sequences in Odoo

Odoo offers a powerful feature for generating automatic sequences, eliminating the need to enter these identifiers manually. Configuring this feature not only saves time but also guarantees the accuracy and uniqueness of each identifier.

Practical example: Setting up an annual sequence

In our case, we needed each work order to start with the prefix 'OS', followed by the year and a five-digit sequential number. Thanks to Ganemo's advice, we were able to configure Odoo so that, when creating a new order, the system automatically assigns the next number in the sequence, resetting the count each year. This not only simplified our order management process but also improved the traceability of each project.

Step-by-step implementation

To implement this solution, we followed a detailed manual that guided us through creating a sequence in Odoo, configuring a trigger for automatic number generation and customizing the field to prevent unwanted manual edits. This methodical approach ensured that the implementation was successful on the first attempt.

The result

After the configuration, each new order created in the system automatically receives its unique identifier, such as 'OS202500001'. This small change has had a significant impact on our daily operations, reducing errors and increasing efficiency. With Ganemo's support, even the most advanced customizations become simple, stress-free processes.

Related video

How to Automate Sequence Generation in Odoo and Avoid Manual Errors
Wilfredo Fernando Pastor Avila August 5, 2025
Share this post
Tags
Archive
Sign in to leave a comment
How to create a new data model in Odoo and solve business problems
Learn how to implement custom data models in Odoo to manage information specific to your company