How to daily reset a sequence (ir.sequence object) in Odoo 12?

Question

I have a custom module in Odoo 12 and I need to create sequences for model records every day so, I need to reset it daily at 00:00 pm. I tried to use scheduler but I can not find which field should I override or reset the sequence I want. As I reviewed the ir_sequence table structure in the database, no values of this table fields are stored in the database, so how we can reset this sequence?

Here is the code I used as scheduler:

<odoo>
    <data noupdate="1">
        <record id="ir_cron_token_no_sequence_daily_restart_scheduler" model="ir.cron">
            <field name="name">Token Nummber Sequence Daily Restart Scheduler</field>
            <field name="user_id" ref="base.user_root"/>
            <field name="model_id" ref="acs_hms.model_hms_appointment"/>
            <field name="interval_number">1</field>
            <field name="interval_type">days</field>
            <field name="numbercall">-1</field>
            <field name="doall" eval="False"/>
            <field name="code">model._reset_token_number_sequences()</field>
            <field name="state">code</field>
        </record>
    </data>
</odoo>

This is my _reset_token_number_sequences() method:

def _reset_token_number_sequences(self):
        sequences = self.env['ir.sequence'].search([('name', '=like', '%nl_department_%')])
        for sequence in sequences:
            print('Sequence is : ', sequence)
            sequence.write({
                'number_next' : 1,
            })

But it's not working in my case, please help me on which field should I override it from here instead of number_next.

Is the method called? do you see print's when you the cron ran? — Charif DZ, Sep 08 '19 at 12:01
Yes, the scheduler works fine and I only don't know which fields of the ir.sequence should I reset to 1. — Ibrahim Rahimi, Sep 08 '19 at 12:04
I think you should really take a look on how the next_by_code work to understand this. — Charif DZ, Sep 08 '19 at 12:25

score 3 · Accepted Answer · edited Sep 08 '19 at 20:09

3

The field which holds next number value in odoo v12 is number_next_actual. So you will have to update number_next_actual field value through cron. Your python code should look like:

    def _reset_token_number_sequences(self):
        # just use write directly on the result this will execute one update query
        sequences = self.env['ir.sequence'].search([('name', '=like', '%nl_department_%')])
        sequences.write({'number_next_actual': 1})

Hope this code help you.

edited Sep 08 '19 at 20:09

Charif DZ

14,415
3
21
40

answered Sep 08 '19 at 14:19

Younis Mahsud

437
5
15

Yes, this solved my problem and I just did add a loop overs all sequences resulted by using self.env[''].search. – Ibrahim Rahimi Sep 08 '19 at 19:17
why did you use loop?!! you will execute update query for every sequence? just call write on the result returned by search – Charif DZ Sep 08 '19 at 20:09
Because in my case there are more than one sequence objects as the result of the search. – Ibrahim Rahimi Sep 09 '19 at 08:47

How to daily reset a sequence (ir.sequence object) in Odoo 12?

1 Answers1