Odoo Help

Welcome!

This community 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.

0

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

By
Rita
on 9/19/14, 7:52 AM 1,985 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

0
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.

0
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

Rita
on 9/19/14, 11:58 AM

Your Answer

Please try to give a substantial answer. If you wanted to comment on the question or answer, just use the commenting tool. Please remember that you can always revise your answers - no need to answer the same question twice. Also, please don't forget to vote - it really helps to select the best questions and answers!

About This Community

This community is for professionals and enthusiasts of our products and services. Read Guidelines

Question tools

1 follower(s)

Stats

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