18.How To Generate Sequential Value For Field In Odoo || Sequence in Odoo

How to generate sequential value for a field in Odoo. Sequence in Odoo. How to define new sequence in Odoo for the models. Show how to define the new sequence and override the create method and assign the sequence value to the field.
Playlist: • 2. How To Create Modul...
Module: apps.odoo.com/...
Website: www.odoomates....
Github: github.com/odo...
Email : [e-mail]
Facebook: / odoomate
Twitter: / odoomates
Support Us in Ko Fi : ko-fi.com/odoo...

[@GianmarcoContreras]

This is the best video of sequence in odoo 😎🤓

[@OdooMates]

happy to hear it

[@wilmerrodriguezs9306]

In Colombia, "HP" is used as an abbreviation for something rude 🤣. Your videos are great, they help me a lot. Greetings.

[@OdooMates]

not sure what is stands for HP in colombia :p anyway glad to know that videos are helpfull

[@raphaelhuetdefroberville6452]

Hello, Your videos are great ! It's great to show everything step by step and to show us the errors that we could have. On this course, in the model you write : vals['reference'] = self.env['ir.sequence'].next_by_code('hospital.patient') or _('New') I don't understand the utility of " or _('New')" at the end of the line.

[@valentinacolautti367]

Hi, i think because self.env['ir.sequ..] ecc is inside vals.get('reference') condition .... so it works after (when the code has taken the value).. after you have clicked the create button. The declaration of the default value in the table is general... it is applied before the 'get' so it is useful to show the title 'New' at the beginning of the creation

[@OdooMates]

just to add along with @valentina, or _('New') will return the value as New or its translation(according to the language) when the sequence is not returning value from it, either you can give it or not, it depends on the coder

[@maria.2506]

hi there and greetings, Great video on the topic. Query: can we create a sequence depending on another field, e.g. gender, separate sequence for male, female & others. if yes please guide us in doing so. Lots of thanks for yr good work, plz keep it up. Regards

[@ramamadeit5280]

Hello, i have typed the code according to the example in your video, but i got an error : TypeError: create() missing 1 required positional argument: 'vals' (if I click the create button , that error will appear) can you help me ? Thank you.

[@OdooMates]

can you share us the written code

[@ramamadeit5280]

@@OdooMates my code : # -*- coding: utf-8 -*- from odoo import api, fields, models class TambahanEN(models.Model): _name = "tambahanen" _inherit = ['mail.thread', 'mail.activity.mixin'] _description = "Tambahan Eastech Nusantara" nomerseq = fields.Char(string='Nomer Sequence', required=True, copy=False, readonly=True, default=lambda self: _('New')) name = fields.Char(string='Name', tracking=True) note = fields.Text(string='Description', tracking=True) state = fields.Selection([('draft', 'Draft'), ('confirm', 'Confirmed'), ('done', 'Done'), ('cancel', 'Cancelled')], default='draft', string="Status", tracking=True) contohmanytoone_id = fields.Many2one('res.partner', string="Contoh Many to One") def action_draft(self): self.state = 'draft' def action_confirm(self): self.state = 'confirm' def action_done(self): self.state = 'done' def action_cancel(self): self.state = 'cancel' def create(self,vals): res = super(TambahanEN, self).create(vals) return res @api.model def create(self, vals): if not vals.get('note'): vals['note'] = 'Kosong' if vals.get('nomerseq', _('New')) == _('New'): vals['nomerseq'] = self.env['ir.sequence'].next_by_code('coba.sequences') or _('New') res = super(TambahanEN, self).create(vals) return res

[@renaacer]

When you receipt the purchase you can write custom lot/serial numbers. Can i add sequential value in a table(one2many lines)?

[@OdooMates]

possible to achieve, something like auto lot generation ?

[@renaacer]

@@OdooMates You must put the sequence every time you click to add line

[@OdooMates]

@@renaacer yes possible

[@renaacer]

@@OdooMates If i'll see you video "45. how to add one2many field" can i?

[@OdooMates]

@@renaacer kzbin.info/www/bejne/eauYloBre6mgiqc

[@rishalchand6935]

Hello. Can you tell how this can be achieved on a existing custom field which is in CRM. I want to make my existing custom field to auto generate sequence.

[@OdooMates]

by inheriting the corresponding model and follow the same steps

[@walidsehil9637]

@@OdooMates if no existing model to inherit ?? !

[@hoangvunhat3600]

Hi, thank you so much for the video. I have a question. I created several patients before watching this video. So how can I re-count or set the sequential value from the first patient that I created?

[@OdooMates]

either you can delete and create again or run a script to update existing record

[@hoangvunhat3600]

@@OdooMates Hi thanks, do you have any video that guide to update the records?

[@OdooMates]

@@hoangvunhat3600 using a server action that runs python code, you can update using the write orm method or direcly update sequence from db, may i know how many records you have ? this is test db right ?

[@hoangvunhat3600]

@@OdooMates Yes this is my test db. I have only few records (about 10) and it's easy to delete and create again. But I just want to know if there is a method to update the sequential values without deleting records. Just in case for example, we don't add the sequential values at the beginning of the project.

[@hoangvunhat3600]

@@OdooMates sorry I'm quite new to Odoo so it might be hard for me to catch up your ideas. Do you have any tutorials in your playlist talking about this?

[@javaidkhan7410]

good work

[@OdooMates]

❤️❤️❤️

[@engineerasmaa4658]

Your videos are great 👌👏

[@OdooMates]

Thanks dear

[@captainleonard123]

can we still achieve this without coding?

[@OdooMates]

yes possible. see: kzbin.info/www/bejne/eauYloBre6mgiqc

[@indeveloperid6061]

Is this important to add noupdate="1" ?

[@OdooMates]

yes it has to add, we have missed it to specify it during its creation, we have created a separate video on no update attribute: kzbin.info/www/bejne/eGqxmpahbKihhKM shceduled it for may 17

[@souravpanda3335]

I don't have a data folder in side my om_hospitail what to do

[@OdooMates]

apps.odoo.com/apps/modules/14.0/om_hospital/

[@OdooMates]

github.com/odoomates/odooapps/tree/14.0/om_hospital/data

[@waleedahmed396]

can't I just Add Auto increment column in the database and connect it to the code?

[@OdooMates]

current approach seems more easy and user friendly right ?

[@arsamjunaid318]

not getting sequence

[@OdooMates]

can you check the db and see whether the sequence record get added in the db or not

[@farseenpk9793]

How to reset this sequence daily??

[@OdooMates]

but using code, it will be possible, then there will be a duplicated sequence number right ?

[@farseenpk9793]

@@OdooMates no .but..is there any chance to give scheduled action for 'next_number'

[@OdooMates]

@@farseenpk9793 yes inside scheduled action you can execute python code, and using orm method, search for the sequence, and then using write method update the next number

[@farseenpk9793]

@@OdooMates thank u sir

[@OdooMates]

@@farseenpk9793 welcome

[@VonFixxxer]

Hello again, master! My teacher is asking for a similar thing, but in this case he also wants that each code number can be reused if the user (the patient in your case) is deleted. What would be your approach to this?

[@OdooMates]

using sequence it will be hard to resuse the deleted sequence number, if you are forced to do it, using python code, you can find missing sequence and set it to newly creating records