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

Powiązane posty	Odpowiedzi	Widoki
How to change string value Using Odoo studio In Odoo 17 Studio odoo17	1 maj 24	2081
Odoo 16 - Use Studio instead of Odoo.sh customisation customization Studio	1 lut 23	3909
How to subtract two dates in an Automated Action ? Rozwiązane customization Studio	1 wrz 21	4279
Need Help Implementing Custom Date Function from Odoo 18 in Odoo 17 – Urgent Assistance Required customization ganttview odoo17	0 paź 24	1500
Add boxes to odoo reports code customization odoo17	1 lis 24	1975

To pytanie dostało ostrzeżenie

Podoba Ci się ta dyskusja? Dołącz do niej!