Skip to Content
Menu
This question has been flagged
2 Replies
10107 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
  Rita

Avatar
Discard
Best Answer

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.

Avatar
Discard
Best Answer

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.

Avatar
Discard
Author

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

Related Posts Replies Views Activity
2
Dec 22
3594
1
Feb 21
2109
0
Mar 15
2471
2
May 24
6535
1
Mar 24
839