Odoo is the world's easiest all-in-one management software.
It includes hundreds of business apps:
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.
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')
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:
In the Python code block, use the following:
for record in records:
record['field_name'] = env['ir.sequence'].next_by_code('purchase.order.tn')
Replace 'field_name' with the appropriate field where you want to store the sequence.
Crea un account oggi per scoprire funzionalità esclusive ed entrare a far parte della nostra fantastica community!
Registrati| Post correlati | Risposte | Visualizzazioni | Attività | |
|---|---|---|---|---|
|
1
mag 24
|
2122 | ||
|
1
feb 23
|
3981 | ||
|
1
set 21
|
4317 | ||
|
0
ott 24
|
1524 | ||
|
1
nov 24
|
2000 |
1. Use the live chat to ask your questions.
2. The operator answers within a few minutes.
See: https://www.youtube.com/watch?v=OCLGODE6lU0