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

Related Posts	Replies	डेटा देखने का तरीका
How to change string value Using Odoo studio In Odoo 17 Studio odoo17	1 मई 24	3038
Odoo 16 - Use Studio instead of Odoo.sh customisation customization Studio	1 फ़र॰ 23	5157
How to subtract two dates in an Automated Action ? Solved customization Studio	1 सित॰ 21	5318
Need Help Implementing Custom Date Function from Odoo 18 in Odoo 17 – Urgent Assistance Required customization ganttview odoo17	0 अक्तू॰ 24	2363
Add boxes to odoo reports code customization odoo17	1 नव॰ 24	3014

This question has been flagged

Enjoying the discussion? Don't just read, join in!