delete the invoice from an order

[Jaguaro]

Hi,

 

 

Usually we don't create invoices with orders (because we already have a fiscal ticket)

Sometimes we select the a payment method which creates the Invoice

Some other times we create invoices by mistake, and this messes up the invoice numbering.

 

We would need to find a way to delete invoices created by mistake without deleting the order.

 

I already found a way to solve the numbering problem, by changing the number in the ps_order_invoice table, but this solutions does not seem elegant, also because the invoice appears as done.

 

Thank you in advance,

 

C

[tuk66]

It is a module for it, I hope. Otherwise, you can delete several records in the database by hand.

[Jaguaro]

I don't have a module for that, do you know which records should I delete?

[tuk66]

Some thoughts are at http://www.prestashop.com/forums/topic/204995-ps-15-how-to-reset-delete-orders-and-invoices/, but be carefull and backup the database first.

[Tung at RockPOS.com]

Look at the table "order_invoice". 

 

Hope this helps!

Tung

[tuk66]

There are also tables

 

ps_order_invoice_payment

ps_order_invoice_tax

ps_order_detail_tax

 

and invoice_number and invoice_date fields in ps_orders table.