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	Views
How to change string value Using Odoo studio In Odoo 17 Studio odoo17	1 May 24	224
Odoo 16 - Use Studio instead of Odoo.sh customisation customization Studio	1 Feb 23	1540
How to subtract two dates in an Automated Action ? Solved customization Studio	1 Sep 21	1985
Add boxes to odoo reports code customization odoo17	0 Sep 24	48
Validation Error: When adding other groups to 'Receive Products' button. purchase Studio odoo17	0 Jul 24	106

This question has been flagged

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