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.

1

Change Next number in Sequence

By
aci aisha
on 1/29/15, 3:43 AM 546 views

Friends,

How to edit the "next number" field in a sequence from,

Settings > Technical > Sequence & Identifiers > Sequence

Now i cant edit & save it..

Thanks

No 1 Know It

aci aisha
on 1/29/15, 5:08 AM

Everyone know that

Juan José Scarafía
on 1/29/15, 11:35 AM

Shut up u Juan

aci aisha
on 1/30/15, 12:14 AM
0

Ludo - Neobis

--Ludo - Neobis--
2387
| 2 2 5
Hoogvliet, Netherlands
--Ludo - Neobis--

Developer

Ludo - Neobis
On 1/29/15, 7:49 AM

I don't know if it the official solution but you can try this:

  1. Access database with something like psql or pgadmin3
  2. Find the sequence you want to reset
  3. enter query "ALTER SEQUENCE $yoursequence RESTART"

Now it should be reset to 1.

 

More information:

http://www.postgresql.org/docs/9.1/static/sql-altersequence.html

thanks

aci aisha
on 1/30/15, 12:14 AM

If this helped you, please mark the answer as correct.

Ludo - Neobis
on 1/30/15, 3:57 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

2 follower(s)

Stats

Asked: 1/29/15, 3:43 AM
Seen: 546 times
Last updated: 3/16/15, 8:10 AM