I created a sequence for a class. This is the xml structure that create it: Report Review management.reports_review Report Review management.reports_review %(year)s\ 3

Odoo is the world's easiest all-in-one management software.
It includes hundreds of business apps:

CRM
e-Commerce
Knjigovodstvo
Zaloga
PoS
Projekt
MRP

All apps

All Posts People Badges

Ključne besede (View all)

odoo accounting v14 pos v15

About this forum

Pomoč

Where are the sequences?

v7 sequence

2 Odgovori

13241 Prikazi

Francesco OpenCode

I created a sequence for a class. This is the xml structure that create it:

    <record id="seq_type_report_review" model="ir.sequence.type">
        <field name="name">Report Review</field>
        <field name="code">management.reports_review</field>
    </record>

    <record id="seq_report_review" model="ir.sequence">
        <field name="name">Report Review</field>
        <field name="code">management.reports_review</field>
        <field name="prefix">%(year)s\</field>
        <field name="padding">3</field>
        <field name="company_id" eval="False"/>
    </record>

And this is the system I use to call the sequence in the class:

def create(self, cr, uid, vals, context=None):
    vals['review_number'] = self.pool.get('ir.sequence').get(cr, uid, 'management.reports_review') or ''
    return super(management_reports_review, self).create(cr, uid, vals, context)

If I create a new voice, the sequence increse by 1. It's ok for me but if I go in the Configuration section the next number voice is always on 1! Why? I would change it but if I change it the sequence go on with is old number.

Brett Lehrer

Best Answer

Depends if you're using standard or no-gap sequence implementation. Check out this function in openerp/addons/base/ir/ir_sequence.py:

def _get_number_next_actual(self, cr, user, ids, field_name, arg, context=None):
    '''Return number from ir_sequence row when no_gap implementation,
    and number from postgres sequence when standard implementation.'''
    res = dict.fromkeys(ids)
    for element in self.browse(cr, user, ids, context=context):
        if  element.implementation != 'standard':
            res[element.id] = element.number_next
        else:
            # get number from postgres sequence. Cannot use
            # currval, because that might give an error when
            # not having used nextval before.
            statement = (
                "SELECT last_value, increment_by, is_called"
                " FROM ir_sequence_%03d"
                % element.id)
            cr.execute(statement)
            (last_value, increment_by, is_called) = cr.fetchone()
            if is_called:
                res[element.id] = last_value + increment_by
            else:
                res[element.id] = last_value
    return res

Using no-gap implementation, the current sequence should be listed directly in the table in ir_sequence. Otherwise, using something like pgAdmin, you can just look directly at the sequence value under "Sequences" -> "ir_sequence_<sequence id="">". Or, referring to that function, a SQL query like:

select last_value from ir_sequence_041;

Why you aren't seeing the updated number on the configuration page is odd. Something else must be going wrong there, but I don't know what. Using updated server source code?

Rachid

   odoo 8: 
modify the file odoo/openerp/addons/base/ir/ir_sequence.py as bellow
 

`
def _predict_nextval(self, cr, seq_id):
    """Predict next value for PostgreSQL sequence without consuming it"""
    # Cannot use currval() as it requires prior call to nextval()
    query = """SELECT last_value,
                      (SELECT increment_by
                       FROM pg_sequences
                       WHERE sequencename = 'ir_sequence_%(seq_id)s'),
                      is_called
               FROM ir_sequence_%(seq_id)s"""
    if cr._cnx.server_version < 100000:
        query = "SELECT last_value, increment_by, is_called FROM ir_sequence_%(seq_id)s"
    cr.execute(query % {'seq_id': seq_id})
    (last_value, increment_by, is_called) = cr.fetchone()
    if is_called:
        return last_value + increment_by
    # sequence has just been RESTARTed to return last_value next time
    return last_value


class ir_sequence(openerp.osv.osv.osv):

 def _get_number_next_actual(self, cr, user, ids, field_name, arg, context=None):
    '''Return number from ir_sequence row when no_gap implementation,
    and number from postgres sequence when standard implementation.'''
    res = dict.fromkeys(ids)
    for element in self.browse(cr, user, ids, context=context):
        if element.implementation != 'standard':
            res[element.id] = element.number_next
        else:
            # get number from postgres sequence. Cannot use
            # currval, because that might give an error when
            # not having used nextval 
            
            seq_id = "%03d" % element.id
            res[element.id] = _predict_nextval(self, cr, seq_id)
    return res
`

Enjoying the discussion? Don't just read, join in!

Create an account today to enjoy exclusive features and engage with our awesome community!

Prijavi

Related Posts	Odgovori	Prikazi
Problem initializing a field with a sequence v7 sequence	0 mar. 15	6058
How to initialize the invoice sequence number every month ? v7 sequence account.invoice	3 dec. 23	8222
Different sequence number of Quotations and sales order? Solved sales v7 sequence	1 mar. 15	8302
Auto-increment Ref# in Journal Voucher development v7 sequence	0 mar. 15	4946
Different sequence number of RFQ and Purchase Order? Solved purchase v7 sequence	1 mar. 15	7244

This question has been flagged

Enjoying the discussion? Don't just read, join in!