This question has been flagged
1 Reply
863 Views
codemultiplesequenceprefixodoo16
Avatar
Asmaa

How can i make multi sequence based on another field

for example i have field named prefix and field named sequence 
the user can write any thing in prefix field
for example if the user write xx in prefix , then the sequence will be xx0001 
if he enter xx again then the sequence will be xx0002 , if he enter ff then the sequence will be ff0001......
the user can write any thing in prefix field , this field isn't selection it is Char field
any idea to make this?

Avatar
Discard
Avatar
Niyas Raphy (Walnut IT)
Best Answer

Hi,

This can be achieved by inheriting the write method of your model and concatenating this two field values. 

def write(self, vals):
    if vals.get('prefix'):
        sequence = self.env['ir.sequence'].next_by_code('sale.order') or _('New')
        vals['sequence'] = vals['prefix'] + sequence   
    return super().write(vals)

Thanks

Avatar
Discard
Asmaa
Author

but this will make one sequence
xx001
ff002

Asmaa
Author

i need xx001
ff001
xx002
hh001
hh002
ff002