Sign in
Try it free

Odoo Help
Help
Ask a Question
1

Change Next number in Sequence

sequence
By
aci aisha
on 1/29/15, 3:43 AM • 898 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 - 21South

--Ludo - 21South--
2437
| 2 2 5
Zwijndrecht, Netherlands
--Ludo - 21South--

Developer
Ludo - 21South
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.

21south, Ludo - 21South
on 1/30/15, 3:57 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.

Register

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

2 follower(s)

Stats

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