Invoice Table - where is ps_invoice

[wgeppert]

Hi folks,

 

I am surprised - but where is ps_invoice in the database? Why is that important table missing?

 

my regards

[tuk66]

What is your version and is it really missing?

[wgeppert]

Hi,

 

it is version 1.6.0.9 and I am working on raw database.

Yes ps_invoice and ps_invoice_detail are missing. You find ps_order_invoice, which will be my missing ps_invoice for sure. But if so it is missing ps_order_invoice_details. It means if you alter the order between customers order and creating invoice you will loose this information of alteration. This is not correct. It works only if order becomes invoice without changes.

[tuk66]

OK. I asked, because this table is not in older versions. On the other side, I'm not sure if PrestaShop can work without fatal error if this table is missing.

[wgeppert]

I don't know if it is fatal. Think about a customer order was changed at the packing station, since a product was not available. You have to change order to print the invoice. Now the statistic gets wrong, since this product disappears in order. Or the customer makes a complain about that. How will the customer service see that this product was original in the order?

Up to now I didn't search the PHP business logic. I thought I could avoid and would get an answer here.

[bellini13]

PREFIX_invoice and PREFIX_invoice_detail are not valid tables for Prestashop.  i checked in v1.5, 1.6 and 1.7

[wgeppert]

of course they are not - I know - this what I said - they are missing! For my opinion they are a 'Must Have' consequence of accounting good practice.

[bellini13]

you realize they might be in the database under a different name, right?