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

Next Sequence Number Cannot Update

By
aci aisha
on 2/19/15, 5:16 AM 871 views

Friends,

I created a sequence with prefix TM..

I created some files and it generates the following sequences,

   TM001

   TM002

   TM003

Then i delete them all..

So now i want to create files with seq TM001

So i go to settings>Technical>Sequences&Identifiers>Sequences

       Next Number : 1

But when i save it till remain as 4(Not Updated)

Can u help me

Thanks

0

Ludo - Neobis

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

Developer

Ludo - Neobis
On 2/19/15, 5:32 AM

You need to reset the counter in postgres for this.

ALTER SEQUENCE $yoursequence RESTART

should do the trick.

ddnt get..can u plz xplain some more

aci aisha
on 2/19/15, 5:34 AM

Is it q query?After this can i edit it through Settings?

aci aisha
on 2/19/15, 5:34 AM

It's a query. Run it on your db.

Ludo - Neobis
on 2/19/15, 5:38 AM

what i put in the place of $..I put my sequence name ..but it cause the following error,,ERROR: syntax error at or near "$"

aci aisha
on 2/19/15, 5:39 AM

Your sequence should be there, something like ir_sequence_0035 or so. You will have to figure out which one it is for yourself.

Ludo - Neobis
on 2/19/15, 5:41 AM

I tried this,ALTER SEQUENCE ir_sequence_TM:0001 RESTART ..but the same error

aci aisha
on 2/19/15, 6:16 AM

Perhaps it would be best for you to first read the postgres documentation to see what went wrong.

Ludo - Neobis
on 2/19/15, 6:24 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: 2/19/15, 5:16 AM
Seen: 871 times
Last updated: 3/16/15, 8:10 AM