cmedeiros

Hello, We´re facing this issue, our customer pay his monthly bill, but his addon don´t get it´s next due date updated, making his main product been suspended after a month (because of non payment of addon). Anyone already faced this problem? thanks

I don´t get if you want to merge one to another or replace it, so here is what would do on both cases: If you plan to merge it: Open your database on phpmyadmin, select export and choose "data only", after it you will have the SQL´s necessary to store it on another database. The issue here is if you have matching keys on both databases, I would avoid this approach if possible. If you plan to replace: First, you have to upload the /install folder back. Export your data, and clean up the destiny database, just load your exported data to the destiny database. This will work as a new install, and you will have to open your /install folder again, to accept the terms of use, after it, remove the install folder again. I never have any problem replacing the database. Hope this help. regards,

I really miss this kind of control on WHMCS, I will try do add a hook in some steps to try capture this info and store it in an custom field or table. Thanks for your explanation.

I looked there, but it is empty... so I thought it was filled in somewhere else. How a customer has "Cancelled" in his status, if he haven´t request it? Do you know wich other way it can be cancelled? thanks

Hello Everybody, How do I get the cancellation date? I got the suspension and terminate date from tblactivitylog, but can´t find a place to get the cancellation date. Isn´t it stored? thanks.

I have another issue related to this subject. The main product is paid annually and the addon monthly. The main product is in day with it´s payments, the addon also it´s in day (had some overdue in the past, but now it´s ok), but whmcs keeps suspending the main product, saying that the addon is overdue. any ideas why whmcs is doing that?

Hi, I have requested a trial for nicbr by e-mail and by the contact form in your website. Is it still possible to trial it? thanks

Hi, thanks for your reply. I also use PayPal, but my big problem is to match the sum of all values received/generated by plan. If I don´t detail it into plans, I get the correct value, when I try to pull the data by plan, it always mismatch.

Hello, I´m building some custom reports to measure the total income, but i´m not understanding the relation between tblinvoiceis and tblaccount. Could someone please explain to me the amountin and amountout of tblaccount and why the sum of tblinvoices.total not always match the sum of tblaccount.amountin? thanks

Hello Fellows, Sometimes, a customers that is suspended for overdue invoice, call us and send his payment receipt to we re-enable his service. So we click on unsuspend, wich re-actives his service, but keeps his invoice as unpaid. My question is, if for any reason his payment is not returned to us, he will be re-suspended after a while? Or he will keep with his service active until next month, and then be suspended again? thanks,

Hey fellows, anyone has as database model diagram? It would really help me build new reports. thanks