[SOLVED] Reset invoice number

[felix7]

Hello,

I have tried to change the number from backend, in 'Invoices' page, but I got an error 'Invoice number not valid'. So I look up for other way, so I found out that I could change it from my database, in 'ps_configuration' table, but I don't have a row callled 'ps_invoice_number'. Any idea?

Thanks in advance!

Edited April 8, 2019 by felix7 (see edit history)

[Rodrigo B Laurindo]

Go to Orders > Invoices. You will be able to set the invoice number there.

Edited April 7, 2019 by Rodrigo B Laurindo (see edit history)

[felix7]

En 7/4/2019 a las 2:18 AM, Rodrigo B Laurindo dijo:

Go to Orders > Invoices. You will be able to set the invoice number there.

"I have tried to change the number from backend, in 'Invoices' page, but I got an error 'Invoice number not valid'." I wrote this in my first post. Thanks anyway.

[ecommerce16]

max numbers is 9, maybe thats the problem?

[felix7]

hace 8 minutos, Curious dijo:

max numbers is 9, maybe thats the problem?

No, I just wanted to reset at 1. But I found a solution right now! I don't know why I'm getting that error, but I have been able to change the number from database. In 'ps_order_invoice', it looks like prestashop take last invoice number and plus one, so I have change that field and it's solved!

[MrGubu]

I have reset the invoice orders creating an empty table copying from 'ps_order_invoice' and replacing the old one.