This would be a bit of a complex script to write since you need to take into account settings on the Customer Account that stop manual suspension based on Credit Limit or Date.
You would also need to pull settings for grace periods (I know there is one in the main settings, not sure about a per plan grace period in v5.4). The key tables are the PlansBillState, CreditMovements, DebitMovements, Customers and Plans tables. It is feasible to write an SQL Stored Procedure to produce a recordset containing the fields you want. You could then create an SQL Job to have this e-mailed to you or write a web interface to it. Regards, Suneel. -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of GlobalNet, LLC Sent: Thursday, May 05, 2005 2:44 PM To: [email protected] Subject: [Rodopi] Telling who is going to lock for non payment Any ideas to this question? -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Global Net, LLC Noc Sent: Tuesday, May 03, 2005 3:34 PM To: [email protected] Subject: [Rodopi] Telling who is going to lock for non payment I have a question. Does anyone have a way in Rodopi 5.4 to be able to tell who is going to lock for non payment ? Say the next day(s) for example? Jeff --------------------- To Leave the Rodopi mail list send a message to [EMAIL PROTECTED] with the word LEAVE as the message body. Please also visit the Rodopi FAQ at http://www.rodopi-faq.com --------------------- --------------------- To Leave the Rodopi mail list send a message to [EMAIL PROTECTED] with the word LEAVE as the message body. Please also visit the Rodopi FAQ at http://www.rodopi-faq.com --------------------- --------------------- To Leave the Rodopi mail list send a message to [EMAIL PROTECTED] with the word LEAVE as the message body. Please also visit the Rodopi FAQ at http://www.rodopi-faq.com ---------------------
