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
- Akuntansi
- Inventaris
- PoS
- Project
- MRP
Pertanyaan ini telah diberikan tanda
1
Balas
6763
Tampilan
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.
Menikmati diskusi? Jangan hanya membaca, ikuti!
Buat akun sekarang untuk menikmati fitur eksklufi dan agar terlibat dengan komunitas kami!
Daftar| Post Terkait | Replies | Tampilan | Aktivitas | |
|---|---|---|---|---|
|
0
Feb 23
|
4795 | ||
|
0
Jan 23
|
94 | ||
|
1
Okt 22
|
4144 | ||
|
0
Apr 22
|
2716 | ||
|
Set an increment for customer reference
Diselesaikan
|
|
2
Mar 25
|
2770 |
No 1 Know It
Everyone know that
Shut up u Juan