Friends,
How to edit the "next number" field in a sequence from,
Settings > Technical > Sequence & Identifiers > Sequence
Now i cant edit & save it..
Thanks
Odoo is the world's easiest all-in-one management software.
It includes hundreds of business apps:
- CRM
- e-Commerce
- Účetnictví
- Sklad
- PoS
- Project
- MRP
This question has been flagged
1
Odpovědět
6918
Zobrazení
I don't know if it the official solution but you can try this:
- Access database with something like psql or pgadmin3
- Find the sequence you want to reset
- 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
If this helped you, please mark the answer as correct.
Enjoying the discussion? Don't just read, join in!
Create an account today to enjoy exclusive features and engage with our awesome community!
Přihlásit se| Related Posts | Odpovědi | Zobrazení | Aktivita | |
|---|---|---|---|---|
|
0
úno 23
|
5116 | ||
|
0
led 23
|
94 | ||
|
1
říj 22
|
4347 | ||
|
0
dub 22
|
2897 | ||
|
2
bře 25
|
2969 |
No 1 Know It
Everyone know that
Shut up u Juan