Auto Increment Odoo 17 Studio Fields

Question

Hello,
How can I create a field using Odoo 17 Studio that auto increases with every new purchase order?
For instance, a purchase order #P0001 can have tracking number *TN0001*, then the next purchase order *TN0002*, and so forth. I also need the numbers to be auto generated and to be unique without duplicates.

Lars Aam · Accepted Answer

First go to Settings -> Technical->Sequences.  Create a new sequence.  It is quite straight forward, well explained in the interface.
The go to Settings->Technical->Automation Rules. Create a new rule. Set the model to Purchase and the trigger = On creation.  Action: Execute Python code.
Python code would look something like this:
for record in records:
record['your field name'] = env['ir.sequence'].next_by_code('your sequence')

Anaghan Heri · Answer

Hi, you can follow these steps, but before proceeding with the code, you need to create a sequence record.
Go to *Settings* -> *Technical* -> *Sequences* to create the sequence record before implementing the code.
To automate sequence generation for the Purchase model, follow these steps:
*Go to* Settings -> Technical -> Automation Rules. *Create a new rule*. Set the *Model* to Purchase Order. Set *Trigger* to On Creation. *Action*: Choose Execute Python Code.  In the Python code block, use the

Publications associées	Réponses	Vues
How to change string value Using Odoo studio In Odoo 17 Studio odoo17	1 mai 24	2099
Odoo 16 - Use Studio instead of Odoo.sh customisation customization Studio	1 févr. 23	3931
How to subtract two dates in an Automated Action ? Résolu customization Studio	1 sept. 21	4302
Need Help Implementing Custom Date Function from Odoo 18 in Odoo 17 – Urgent Assistance Required customization ganttview odoo17	0 oct. 24	1513
Add boxes to odoo reports code customization odoo17	1 nov. 24	1984

Cette question a été signalée

Vous appréciez la discussion ? Ne vous contentez pas de lire, rejoignez-nous !