Serverius Posted November 12, 2010 Share Posted November 12, 2010 Hi, When I'm creating a cron job to create invoices WHMCS is skipping numbers. He makes a run like #7 #10 #13 etc.etc. When I make them manualy that doesn't appear. Anybody has the same problem? Thanks! 0 Quote Link to comment Share on other sites More sharing options...
WHMCS CEO Matt Posted November 12, 2010 WHMCS CEO Share Posted November 12, 2010 Maybe you've set the "Invoice # Incrementation" to 3 in General Settings > Invoices ? Matt 0 Quote Link to comment Share on other sites More sharing options...
Serverius Posted November 12, 2010 Author Share Posted November 12, 2010 Nope, this value is set to "1". 0 Quote Link to comment Share on other sites More sharing options...
Serverius Posted November 12, 2010 Author Share Posted November 12, 2010 With phpmyadmin I checkt the mysql value, also there it is set to '1". 0 Quote Link to comment Share on other sites More sharing options...
Serverius Posted November 13, 2010 Author Share Posted November 13, 2010 Just for testing, I changed "nvoice # Incrementation" to 10. After a test with a new cron, the invoice numbering is working fine, invoice numbers are 10, 20, 30... When I change it back to 1, new invoices numbering are 1,3,5.. What can I do more? Probably I miss some settings or something. 0 Quote Link to comment Share on other sites More sharing options...
Serverius Posted November 15, 2010 Author Share Posted November 15, 2010 does anyone have a solutions for this problem? 0 Quote Link to comment Share on other sites More sharing options...
Austdata Posted November 15, 2010 Share Posted November 15, 2010 (edited) It may be worth raising a support ticket given what Matt said in the earlier post. Edited November 15, 2010 by Austdata Better English 0 Quote Link to comment Share on other sites More sharing options...
Serverius Posted November 16, 2010 Author Share Posted November 16, 2010 I found the solution. Every time we run the cron job, a item of a non existing customer (customerId 2, so probably a default user or something) was generated before the item we added. So 2 invoices were generated in a cron run. I fixed it via phpMyAdmin, deleting all als items in the “tblbillableitems” table. After this, I deleted the fake customer. Now everything works fine, all invoices are generated like it should be. 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.