snake Posted December 23, 2012 Share Posted December 23, 2012 We just had an issue yesterday that a customer was suspended for non payment, but there were no overdue invoices on his account. After contacting support, I was told that suspensions are based on the "next due date" of products not on invoices. So was caused by the fact that a products next due date had not been updated when the last invoice was paid (another issue we are having). Maybe it's just me, but this just seems totally wrong, surely the suspension for overdue invoices should actually be based on overdue invoices ? Otherwise this exact issue is going to occur, suspending users for no reason. 0 Quote Link to comment Share on other sites More sharing options...
Kian Posted December 24, 2012 Share Posted December 24, 2012 There's nothing wrong to me. You can't pretend WHMCS to find the connection between a random invoice and a service. I suppose that for some reason you made a manual invoice for your customer and that invoice was, just in your mind, for service X renewal. When your customer pays the invoice WHMCS will never update the next due date because there's no relation (relid) invoice <---> service. You should now manually update the next due date and let WHMCS to automatically create invoices with the right relid. When you plan to "overwrite" invoice system always use "Generate due invoices" to preserve relids. 0 Quote Link to comment Share on other sites More sharing options...
snake Posted December 24, 2012 Author Share Posted December 24, 2012 Not sure what you mean by pretending whmcs has a link between random invoice and service, surely WHMCS knows what service it generated an invoice for ? And why would it be random ? these are meant to occur based on product due dates etc not randomness. There is no manual invoices involved here, invoices are supposed to be generated automatically by WHMCS each month when due. If you had to make them manually each month and update next due dates, what would be the point in an automated system that is not automated ? Also your wrong when you say "WHMCS will never update the next due date " because WHMCS does update the next due date most of the time, so it obviously is supposed to work this way, but it is just randomly it doesn't do it sometimes, so if YOUR system NEVER does this and you have to always manually update your next due dates, it seems you also have a problem with your whmcs system too. Surely when customer gets an email saying they have been suspended for non payment, but there is no invoice or payment due, how do we explain this? it makes no sense to the customer, or to us. 0 Quote Link to comment Share on other sites More sharing options...
Kian Posted December 24, 2012 Share Posted December 24, 2012 There's nothing wrong to me. You can't pretend WHMCS to find the connection between a random invoice and a service. I suppose that for some reason you made a manual invoice for your customer and that invoice was, just in your mind, for service X renewal. When your customer pays the invoice WHMCS will never update the next due date because there's no relation (relid) invoice <---> service. You should now manually update the next due date and let WHMCS to automatically create invoices with the right relid. When you plan to "overwrite" invoice system always use "Generate due invoices" to preserve relids. Damn i never do and i never will manual invoices. WHMCS works really good with automatic invoice and i never had problem with it. I'm just saying that your problem most of time occurs when you make something "manual" to the invoice which breaks the relation with its related service id so that, even when customer pays, next due date will stay equal. 0 Quote Link to comment Share on other sites More sharing options...
snake Posted December 24, 2012 Author Share Posted December 24, 2012 these are not manual invoices. the explanation the suspensions are not based on invoices even though they are unpaid invoices came directly from Liam @ whmcs 0 Quote Link to comment Share on other sites More sharing options...
Kian Posted December 24, 2012 Share Posted December 24, 2012 (edited) We all know that services, addons and domains are based on next due date. The entire system is based on this. What i'm trying to say is a totally different thing. Now again, for the 3rd and last time, i repete that i'm talking about relid. It's a database cloumn of tblinvoiceitems table which contains the ID of the its related service(s). Example: there's client (client id 50) with service id 1500 (an expiring hosting package). WHMCS automatically creates an "Unpaid" invoice with: id 700 invoiceid 250 userid 50 type Hosting relid 1500 As soon as he pays WHMCS will run an hook to update the next due date of an Hosting package of client 50 with service id 1500. You understand that if relid is missing WHMCS will normally set the invoice as "Paid" but will do nothing with next due date because it can't find out the hosting without an id. Now back on your problem probably your relid field was missing for some reason and usually it happens when you "play" with the invoice editing, deleting, updating or removing items from invoice or just the invoice or if you have some messy custom-made hook. If's not your case then submit a bug report since there's noting more to say. Edited December 24, 2012 by Kian 0 Quote Link to comment Share on other sites More sharing options...
snake Posted December 24, 2012 Author Share Posted December 24, 2012 You are completely missing the point or not understanding the issue at all. End customers have no idea about how the WHMCS database works, or hooks nor should they need to know this, it is irrelevant to them. Also as a WHMCS user it is also not my job to know how the code works or about RELID's and have to fix them constantly if they do not get created. All a customer knows is that their account has been suspended for non payment, if they login to their account then they do not have any overdue invoices, so they of course want to know why the hell they have been suspended when no money is owed and no invoice is due. THAT IS THE POINT. AGAIN I repeat for 3rd time (take note), no invoices have been added manually, updated, deleted, edited or played with in any way. A ticket has been submitted to WHMCS, had you read the post properly you would have noticed that, but again that was not the point of the post. 0 Quote Link to comment Share on other sites More sharing options...
WHMCS Liam Posted December 24, 2012 Share Posted December 24, 2012 You are completely missing the point or not understanding the issue at all. End customers have no idea about how the WHMCS database works, or hooks nor should they need to know this, it is irrelevant to them. Also as a WHMCS user it is also not my job to know how the code works or about RELID's and have to fix them constantly if they do not get created. All a customer knows is that their account has been suspended for non payment, if they login to their account then they do not have any overdue invoices, so they of course want to know why the hell they have been suspended when no money is owed and no invoice is due. THAT IS THE POINT. AGAIN I repeat for 3rd time (take note), no invoices have been added manually, updated, deleted, edited or played with in any way. A ticket has been submitted to WHMCS, had you read the post properly you would have noticed that, but again that was not the point of the post. Hi Do you have the ticket ID of this and i can take a look at this for you? Cheers Liam 0 Quote Link to comment Share on other sites More sharing options...
snake Posted December 24, 2012 Author Share Posted December 24, 2012 You know what ticket this refers to Liam, you have been replying to it. 0 Quote Link to comment Share on other sites More sharing options...
easyhosting Posted December 24, 2012 Share Posted December 24, 2012 You know what ticket this refers to Liam, you have been replying to it. do you think you are the only ticket they have replied too. give the ticket number and it makes it easier for them to find the ticket in their list. 0 Quote Link to comment Share on other sites More sharing options...
snake Posted December 24, 2012 Author Share Posted December 24, 2012 To what end? By their own admission, this is the intended behaviour of WHMCS, so what are you expecting, they certainly wont rewrite the way whmcs handles suspensions on my request. 0 Quote Link to comment Share on other sites More sharing options...
Kian Posted December 25, 2012 Share Posted December 25, 2012 You don't want to listen, you don't accept our help, you don't even want support. So to what end have you opened this thread? I just know that WHMCS automatic suspensions, unsuspensions, activations and terminations work perfectly for me and hundreds of users. If it's not working with you there are 2 possible options: You are doing someting wrong but it's hard to say since you don't want to listen and collaborate You have a bug (i don't think so anyway) but again you don't want to listen and collaborate so it's impossible to fix it I won't write in this thread anymore since it's pointless with your attitude so merry christmas and good luck and sorry if we tryed to help you. 0 Quote Link to comment Share on other sites More sharing options...
snake Posted December 25, 2012 Author Share Posted December 25, 2012 I'm sorry You nothing better to on Christmas than start arguments and be rude to people on forums, that is quite sad. Unfortunately to have completely failed to read and understand the issue and are just reply with angry Obnoxious Responses that having nothing whatsoever to do with the issue, I suggest you calm down down and start again and read from the start again calmly and slowly and stop being rude, there is nothing clever about being a jerk to people at Christmas. Merry Christmas anyway, and I hope you find something to cheer you up today and xhange your horrible attitude.. 0 Quote Link to comment Share on other sites More sharing options...
blackwing Posted January 11, 2013 Share Posted January 11, 2013 Makes perfect sense to me, not sure why Kian doesn't it?, I also agree he was pretty rude. This is definitely pretty daft functionality and quite frankly unacceptable that a customer would be suspended for non payment of a non existent invoice. As a customer I would be really annoyed about that. 0 Quote Link to comment Share on other sites More sharing options...
easyhosting Posted January 11, 2013 Share Posted January 11, 2013 Makes perfect sense to me, not sure why Kian doesn't it?, I also agree he was pretty rude.This is definitely pretty daft functionality and quite frankly unacceptable that a customer would be suspended for non payment of a non existent invoice. As a customer I would be really annoyed about that. No matter any suspensions work on due date and not invoices. your telephone, gas, elec companies all work the same. and i agree that Kian was rude in his response. 0 Quote Link to comment Share on other sites More sharing options...
Kian Posted January 12, 2013 Share Posted January 12, 2013 (edited) and i agree that Kian was rude in his response. I agree. Yup even me. I was thinking about this thread a couple of time. I don't know why I didn't get the point the first time i replied and i can't explain why i've been so rude. Sorry guys, sorry snake Edited January 12, 2013 by Kian 0 Quote Link to comment Share on other sites More sharing options...
anthonyfox63 Posted January 24, 2013 Share Posted January 24, 2013 I hope this thread is still open. We have a similar problem with new orders. an order is placed.. is paid (though we have the same issue if setting the price to 'Free') new site fails to be created though product is set to create the site after payment we manually accept order which then sets up the site the next day the site is suspended even though we have suspension set for 5 days past due After checking the 'Next Due Date' is still the date of purchase. Some process is failing to run... I have no idea what process but 3 days going back and forth with support and they still aren't listening to the problem. 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.