waca2015 Posted February 22, 2017 Share Posted February 22, 2017 I need to generate Quotes with an incrementation of 125 not 1. I don’t see a way to change that in the backed. (Ex: #125, #250, #400, #525… and so on) Any recommendations? Thank you. 0 Quote Link to comment Share on other sites More sharing options...
brian! Posted February 22, 2017 Share Posted February 22, 2017 I need to generate Quotes with an incrementation of 125 not 1. I don’t see a way to change that in the backed. (Ex: #125, #250, #400, #525… and so on) Any recommendations? Thank you. i'm tempted to ask why - but I think I can guess the answer. depending on your version of MySQL, you might be able to modify the auto_increment value in the table - but i'd definitely suggest that you backup the database before even attempting anything like that... or ideally, get someone experienced to do it for you. alternatively, and the less evasive way, would just be the alter your templates to change the Quote # shown... e.g it's stored as a number, so you would just need to multiply it by 125 (perhaps directly in Smarty or in PHP in the pdf template) - the only potential downside I can foresee, would be that you couldn't change the link id value... e.g viewquote.php?id=3 (where the id=3, but the quote number will be shown as 375)... but i'm not sure that really matters as you can have invoices # that bear no relation to their id value. 0 Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.