atechstl Posted February 11, 2011 Share Posted February 11, 2011 I used a script back in November to transfer all my customers from AWBS into WHMCS. I have ran into a few bugs in which I believe to be from this import but my biggest problem is about half my customers aren't being invoiced. Some accounts are being billed automatically while some are not. This causes huge frustration to both me and my clients. Invoices are sent out 14 days prior to due date. Continues Invoice Generation is Selected. Generate Due Invoices even fails. 0 Quote Link to comment Share on other sites More sharing options...
WHMCS Support Manager WHMCS John Posted February 11, 2011 WHMCS Support Manager Share Posted February 11, 2011 Pleas ensure your cron is completing successfully each day; indicated by a "Cron Job: Completed" entry in Utilities > Activity Log. 0 Quote Link to comment Share on other sites More sharing options...
atechstl Posted February 11, 2011 Author Share Posted February 11, 2011 Here is the CRON LOG 02/11/2011 06:30 - Enom Domain Sync Run 02/11/2011 06:01 - Cron Job: Completed 02/11/2011 06:00 - Cron Job: Running Usage Stats Update 02/11/2011 06:00 - Cron Job: Closing Inactive Support Tickets 02/11/2011 06:00 - Cron Job: Sending Domain Renewal Notices 02/11/2011 06:00 - Cron Job: Sending Invoice Reminders 02/11/2011 06:00 - Credit Card Payments Processed (0 Captured, 0 Failed) 02/11/2011 06:00 - Cron Job: Credit Card Processing 02/11/2011 06:00 - Cron Job: Adding Late Fees 02/11/2011 06:00 - Cron Job: Generating Invoices 02/11/2011 06:00 - Cron Job: Updating Currency Exchange Rates 02/11/2011 06:00 - Cron Job: Starting 0 Quote Link to comment Share on other sites More sharing options...
railto Posted February 11, 2011 Share Posted February 11, 2011 you need to make sure that all the next due dates are correct, else it wont work 0 Quote Link to comment Share on other sites More sharing options...
atechstl Posted February 16, 2011 Author Share Posted February 16, 2011 The next due date is correct but it still doesn't work. Like I said some of them work and most don't. I have to manually send out invoices. It's a headache. 0 Quote Link to comment Share on other sites More sharing options...
othellotech Posted February 17, 2011 Share Posted February 17, 2011 query your db, tblhosting, is the nextduedate and nextinvoicedate correctly set ? 0 Quote Link to comment Share on other sites More sharing options...
atechstl Posted February 24, 2011 Author Share Posted February 24, 2011 Thinks for the advice. That was actually very good input but after looking in the database it looks correct. The issue still exists and I have to manually send out invoices on some customers while others work fine. This is a nasty bug. I can only assume this is a bug from my import script I used. 0 Quote Link to comment Share on other sites More sharing options...
sohouk Posted February 24, 2011 Share Posted February 24, 2011 Sad to say its the shortcomings of the AWBS import script We did a massive import from AWBS to WHMCS and it took us weeks of manual labour to sort it out. The invoice thing was one of the major problems we had and it cost us bad! For some reason clients hosting accounts were being suspended because of overdue payments - even though no invoice had been generated! The first thing to do is to check if there are any invoices coming up by using PhpMyAdmin and querying the Sql table directly. This SQL command simply shows all accounts where the next invoice date is before the 27 Feb 2011 (which could be a lot). If nothing is returned then WHMCS can't recognise what’s in the ‘nextinvoicedate’ field and won’t invoice. SELECT * FROM `tblhosting` WHERE nextinvoicedate < '2011-02-27' If nothing is returned then check that the ‘tblhosting’ field ‘nextinvoicedate’ is correct and in the right format (no spaces or odd characters) . If that doesn’t work, then you do need to chat to WHMCS and get their help (we did) In relation to invoices, one major glitch is that AWBS →WHMCS does not import the details of any invoices – it only imports the product description. So domain renewals would simply be shown as ‘Domain’ on an imported invoice, when in AWBS it showed as maybe ‘Domain renewal for xxx.com’ In addition, it does not import any subscription details, so if a client has a PayPal subscription, then it won’t get recorded in WHMCS. You have to get the client to cancel it and sign up again. Finally – Passwords. WHMCS does not import AWBS passwords. I’m not too surprised at that, but it is an issue that should be mentioned. I don’t know how many AWBS clients you are importing, but in our case it was many thousands, so we had a long haul ahead of us! Trevor 0 Quote Link to comment Share on other sites More sharing options...
atechstl Posted February 24, 2011 Author Share Posted February 24, 2011 Thank you Trevor for your help! I will be looking more in depth at this tonight! We have also experienced the same issues you described with accounts being suspended. We had to disable accounts being suspended in fear of losing more customers. I can't blaim WHMCS for the problems because I am sure the software would work just as intended if I had not needed to use the import script. 0 Quote Link to comment Share on other sites More sharing options...
sohouk Posted February 25, 2011 Share Posted February 25, 2011 Out of the box, WHMCS seems OK and all works well if you start from scratch. It is probable we would never have made the change had we know in advance of the problems that it caused which resulted in a lot of lost revenue. 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.