If you are looking for to create an auto sequence of Char field. You need to follow the following steps

• Create a sequence in data directly in xml format as below:
• 
      id="sale_invoice_seq" model="ir.sequence">
          name="name">Sale Invoice Sequence
          name="code">account.move.invoice
          name="prefix">SI23-
          name="padding">6
          name="company_id" eval="False"/>
      
      id="seq_purchase_bill" model="ir.sequence">
          name="name">Purchase Bill Sequence
          name="code">account.move.bill
          name="prefix">BILL/
          name="padding">6
          name="company_id" eval="False"/>
      
  

• In above you will see I am creating 2 sequences of in same model but with different move_type

custom_invoice_number = fields.Char('Custom Invoice Number')

@api.model
def create(self, vals):
    result = super(InheritInvoice, self).create(vals)

    if result['move_type'] == 'out_invoice':
        result['custom_invoice_number'] = self.env['ir.sequence'].next_by_code(
            'account.move.invoice')
    if result['move_type'] == 'in_invoice':
        result['custom_invoice_number'] = self.env['ir.sequence'].next_by_code(
            'account.move.bill')

    return result

xml version="1.0" encoding="utf-8"?>

    id="view_invoice_company_logo_name" model="ir.ui.view">
        name="name">account.move.form
        name="model">account.move
        name="inherit_id" ref="account.view_move_form"/>
        name="arch" type="xml">
            expr="//form/sheet/div/span/field[@name='move_type']" position="after" >
                id="custom_invoice" string="Custom Invoice Seqence">
                    
                        
                            
name="custom_invoice_number" readonly="1"/>

                        
                    
                
            
        
    
    id="inherit_invoice_for_custom_field" model="ir.ui.view">
        name="name">account.move.inherit.custom.field

        name="model">account.move
        name="inherit_id" ref="account.view_account_invoice_filter" />
        name="arch" type="xml">
            name="name" position="after">
                name="custom_invoice_number"/>
            
        
    

I hope this will help you to understand the creation of sequence If the above code helps you just give me a like and let me know if you need clarification for any point

Thanks
Regards

Muhammad Ahsan Maqbool

 HI , 

You want to create auto sequence for new record so you can try below code

•  Create Sequence.xml file.

  -  Add below code in your .py file of the object in which you want to create auto sequence.

class AnalyticAccount(models.Model):

_name=” analytic.account”

                name = fields.Char(string=“Number”,default=“New”,readonly=True)

                @api.model

      def create(self, vals):

    vals['name'] = self.env['ir.sequence'].sudo().next_by_code(‘analytic.account’) or 'New'

    res = super(AnalyticAccount,self).create(vals)

       return res

• And access name field in view file like this ,

 I hope this is helpful to you.

 Thanks & Regards,

 Email: odoo@devintellecs.com

 Skype: devintelle

Hi,

You can change the create function as follows,
def create(self, vals):
    vals['name'] = self.code + self.env['ir.sequence'].next_by_code('my_sequence_code')
    return super(MyModel, self).create(vals)

Add this data file, 

<?xml version="1.0" encoding="utf-8"?>
<odoo>
  <data noupdate="1">
    <record id="my_sequence_id" model="ir.sequence">
      <field name="name">My Sequence</field>
<field name="code">my_sequence_code</field>
      <field name="prefix"></field>
      <field name="padding">5</field>
      <field name="number_next">1</field>
    </record>
  </data>
</odoo>

For more details, refer to the blog:

https://www.cybrosys.com/blog/how-to-create-sequence-numbers-in-odoo-16

Hope it helps

Hii Haris,
If you want to create auto sequence in odoo it can be achieved by 'ir.sequence' model ,
Take a look : https://geminatecs.com/blog/sales-editable-auto-sequence
I Hope this information is helpful to you
Feel Free for further assistance at contact@geminatecs.com
Thank You,
Geminate Consultancy Services,
w : www.geminatecs.com

Hi,

If you are looking for how to generate a sequential value for a field in Odoo, it can be done using the ir.sequence in Odoo.

Either it can be done from the user interface using the developer mode or from the code side.

The steps is as follows:

1. Create a sequence in ir.sequence table

2. Inherit the create method of corresponding model and assign sequential value from the created sequence.

For reference:

1. Generating Sequence from UI using sequence and automated action:  https://www.youtube.com/watch?v=Cz5eM5FDmTE

2. Generating sequence from code: https://www.youtube.com/watch?v=69pCFI8uRIw&t=470s

Thanks