istox Posted June 25, 2011 Share Posted June 25, 2011 Hello to all!Have a problem in 1.4.3 Trying to change invoice number in Admin>Orders>Invoice> Invoice IDAnd nothing happened just error and this sign Invalid invoice number (must be > 21092016)The presta have gave me its own number. Please help resolve the problem guys. Link to comment Share on other sites More sharing options...
bellini13 Posted June 25, 2011 Share Posted June 25, 2011 what number did you enter? do you have any existing orders? Link to comment Share on other sites More sharing options...
istox Posted June 25, 2011 Author Share Posted June 25, 2011 I entered any number. But the system gives me only the shop own number 21092016 and ascending when making new test orders. Link to comment Share on other sites More sharing options...
bellini13 Posted June 25, 2011 Share Posted June 25, 2011 i tried and it's working ok for me. i would suggest you open a bug report in svn Link to comment Share on other sites More sharing options...
bellini13 Posted June 25, 2011 Share Posted June 25, 2011 i tried and it's working ok for me. what number did you enter? I assume it is larger than 21092016 Link to comment Share on other sites More sharing options...
istox Posted June 25, 2011 Author Share Posted June 25, 2011 This long INVOICE ID digits 20100916 it is my first orders in Prestashop. But I changed them a long time ago. And now I have order 000445. But I can't change it from BO menu. The system shows error. Something wrong with DB Link to comment Share on other sites More sharing options...
bellini13 Posted June 25, 2011 Share Posted June 25, 2011 run this query from phpmyadmin and tell me the number it gives you SELECT MAX( `invoice_number` ) AS `invoice_number` FROM ps_orders Link to comment Share on other sites More sharing options...
istox Posted June 25, 2011 Author Share Posted June 25, 2011 invoice_number21092018But I changed it a long time ago. And for 8 months succesfully used 0001 - 000444 untill I updated 1.3.1 version to presta 1.4.3 And now I can't use this option in BO to change invoice number Link to comment Share on other sites More sharing options...
istox Posted June 25, 2011 Author Share Posted June 25, 2011 And I tried to change PS_INVOICE_START_NUMBER in PS_PONFIGURAIONIt help for 1 order. But on next order I have to set manually invoice ID again from phpmyadmin because PS_INVOICE_START_NUMBER value is became empty.PS_INVOICE_NUMBER is set for 444 ID but it not helps Link to comment Share on other sites More sharing options...
bellini13 Posted June 25, 2011 Share Posted June 25, 2011 this means you have an order with an invoice number 21092018 in your database, you would have to change it Link to comment Share on other sites More sharing options...
istox Posted June 25, 2011 Author Share Posted June 25, 2011 this means you have an order with an invoice number 21092018 in your database, you would have to change it And I tried to change PS_INVOICE_START_NUMBER in PS_PONFIGURAIONIt help for 1 order. But on next order I have to set manually invoice ID again from phpmyadmin because PS_INVOICE_START_NUMBER value is became empty.PS_INVOICE_NUMBER is set for 444 ID but it not helps Link to comment Share on other sites More sharing options...
istox Posted June 25, 2011 Author Share Posted June 25, 2011 Where I have to change this value? I see that it is serious error. Invalid invoice number (must be > 21092018) in BO 21092018 is keeping somewhere in DB I can't find it where...ANd next invoice will 21092019... Link to comment Share on other sites More sharing options...
istox Posted June 25, 2011 Author Share Posted June 25, 2011 I manualy changed it in PS_ORDERSto value 445TEST ORDER and Invoice ID again 21092018not 446 Link to comment Share on other sites More sharing options...
bellini13 Posted June 25, 2011 Share Posted June 25, 2011 are you changing the order number or the invoice number in ps_orders? Link to comment Share on other sites More sharing options...
istox Posted June 25, 2011 Author Share Posted June 25, 2011 Got it!!!I replaced all long digit orders in ps_order with last order ID (Invoice ID of the last order)And system starts to understand )))Great! Thank you !Please can you see my last thread for my update from 1.3.1 http://www.prestashop.com/forums/viewthread/116596/configuring___using_prestashop/edit_pdf_in_1_dot_4_dot_3/ 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