Skip to Content
Menu
This question has been flagged
3 Replies
12296 Views

Hi, i want to create two different sequence in form for the same object like

 field 1 : xxx/2018

field 2 : zz/C/0005

 How i can achieve This please Help . 

Avatar
Discard
Best Answer

Hi,

You can create multiple sequences for a model.

What you have to do is that,

In the XML file,

<record id="seq_student_application1" model="ir.sequence">
<field name="name">Student Application1</field>
<field name="code">education_application1</field>
<field name="prefix">SA1</field>
<field name="padding">3</field>
<field name="company_id" eval="False"/>
</record>

<record id="seq_student_application2" model="ir.sequence">
<field name="name">Student Application2</field>
<field name="code">education_application2</field>
<field name="prefix">SA2</field>
<field name="padding">3</field>
<field name="company_id" eval="False"/>
</record>


Then in the model, you can super the create method and assign the values for the field,

@api.model
def create(self, vals):
vals['application_no1'] = self.env['ir.sequence'].next_by_code('education_application1') or _('New')
vals['application_no2'] = self.env['ir.sequence'].next_by_code('education_application2') or _('New')
res = super(StudentApplication, self).create(vals)
return res


Fields added in the model,

application_no1 = fields.Char(string='Application  No', required=True, copy=False, readonly=True,
index=True, default=lambda self: _('New'))
application_no2 = fields.Char(string='Application No2', required=True, copy=False, readonly=True,
index=True, default=lambda self: _('New'))


Thanks

Avatar
Discard

Can i change invoice number sequence with the same approach?

Best Answer

Hello,

Can we create an auto increasing field using studio on Odoo 17?

Avatar
Discard
Best Answer

how we make a serial numeber in purchase order

Avatar
Discard
Related Posts Replies Views Activity
1
Mar 23
1017
0
Dec 21
2060
0
Jun 24
430
2
Mar 23
1714
1
Jan 17
7571