wgeppert Posted December 6, 2016 Share Posted December 6, 2016 Hi folks, I am surprised - but where is ps_invoice in the database? Why is that important table missing? my regards Link to comment Share on other sites More sharing options...
tuk66 Posted December 7, 2016 Share Posted December 7, 2016 What is your version and is it really missing? Link to comment Share on other sites More sharing options...
wgeppert Posted December 7, 2016 Author Share Posted December 7, 2016 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. Link to comment Share on other sites More sharing options...
tuk66 Posted December 8, 2016 Share Posted December 8, 2016 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. Link to comment Share on other sites More sharing options...
wgeppert Posted December 9, 2016 Author Share Posted December 9, 2016 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. Link to comment Share on other sites More sharing options...
bellini13 Posted December 9, 2016 Share Posted December 9, 2016 PREFIX_invoice and PREFIX_invoice_detail are not valid tables for Prestashop. i checked in v1.5, 1.6 and 1.7 Link to comment Share on other sites More sharing options...
wgeppert Posted December 10, 2016 Author Share Posted December 10, 2016 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. Link to comment Share on other sites More sharing options...
bellini13 Posted December 10, 2016 Share Posted December 10, 2016 you realize they might be in the database under a different name, right? Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now