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

관련 게시물	답글	화면
How to change string value Using Odoo studio In Odoo 17 Studio odoo17	1 5월 24	1550
Odoo 16 - Use Studio instead of Odoo.sh customisation customization Studio	1 2월 23	3236
How to subtract two dates in an Automated Action ? 해결 완료 customization Studio	1 9월 21	3683
Need Help Implementing Custom Date Function from Odoo 18 in Odoo 17 – Urgent Assistance Required customization ganttview odoo17	0 10월 24	1010
Add boxes to odoo reports code customization odoo17	1 11월 24	1481

신고된 질문입니다

토론이 재미있으신가요? 직접 참여해보세요!