Odoo Help


how to restart the sequence number of sales orders every fiscal year

on 9/19/14, 7:52 AM 3,094 views

Good morning,
  from about twenty days I started studyng OpenERP 7 because my job company has intentions of starting it to use.
  I need help to understand how to restart the sequence number of sales orders every fiscal year.
  Can anyone help me?

  Thanks in advance

Stéphane Bidoul
On 1/15/15, 9:31 AM

The easiest is to use module account_auto_fy_sequence available on apps.odoo.com and in the github OCA repository account-financial-tools. a 7.0 and 8.0 versions exist.

With this module, you can use %(fy)s as a placeholder in sequence prefix and the creation of fiscal year sub-sequences will then be fully automatic.

Michael St-Georges
On 9/19/14, 8:10 AM

It could either be done on a cron via Settings->Technical->Schedulers and finding the right methods to call to set the sequence numbering (A little more research needed, I can find out if that's the way you want to go). Or manually as part of year end processes via Settings->Technical->Sequences->Sales Order and then edit the next number to be 0.

Thanks for the fast answer. To restart the sequence number of invoice, we have created a sequence father (es. "invoice") e 3 sequences daughters (es. "invoice 2013", "invoice 2014" and "invoice 2015") In the tab "Fiscal Years" of father sequence we have assigned for each fiscal year its sequence. In this way, the sequence of invoice contains the year of invoice date correctly. We have done the same thing for sales order, but for this doesn't work, because for every order date the sequence refers always the year 2013. Why does it happen? best regards, Rita

on 9/19/14, 11:58 AM

About This Community

This platform is for beginners and experts willing to share their Odoo knowledge. It's not a forum to discuss ideas, but a knowledge base of questions and their answers.


Odoo Training Center

Access to our E-learning platform and experience all Odoo Apps through learning videos, exercises and Quizz.

Test it now

Question tools

1 follower(s)


Asked: 9/19/14, 7:52 AM
Seen: 3094 times
Last updated: 4/25/16, 11:16 PM