Remitur Posted July 31, 2017 Share Posted July 31, 2017 In setup => general settings => invoices, you can set up the number of next invoice to be issued (last row, "Enter to set the next invoice number, must be greater than last #### (Blank for no change)" ) Well. But this information where is it stored? I looked almost everywhere in the db, but I couldn't find where to get it... 0 Quote Link to comment Share on other sites More sharing options...
brian! Posted July 31, 2017 Share Posted July 31, 2017 usually #### is just the last invoice id value in tblinvoices. 0 Quote Link to comment Share on other sites More sharing options...
Remitur Posted July 31, 2017 Author Share Posted July 31, 2017 usually #### is just the last invoice id value in tblinvoices. No. Or, better: that function is made to lake possible to change it. i.e.: I've not issued any invoice in WHMCS, so the first one would be 1... but (suppose) I need to start with 137: I specify 137 in that field and, few days later, when WHMCS will issue the first invoice, it will have # 137 An so, meanwhile... where did WHMCS stored this info?! 0 Quote Link to comment Share on other sites More sharing options...
brian! Posted July 31, 2017 Share Posted July 31, 2017 tblinvoices - it's just the auto increment value... which can be set/modified by SQL... https://forum.whmcs.com/showthread.php?130474-How-to-safely-set-new-custom-quote-number-to-begin-with-higher-numbers&p=521458#post521458 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.