Re: [Emerald] Closed Accounts

Network Operation Centre ( (no email) )
Tue, 27 Jul 1999 10:40:09 +0930

Yes I would like that also, but I'd like to go one further and void all
invoices in Emerald cause we have not been using it and now I want to use
the invoice part.

>I would like to take this senario one step futher.....
>
>I would like to have a script that would change all MBR's that are over 30
>days expired, including Temporary Extend and Permanent Extend, to Active =
>0, and also void any outstanding invoices for that account.
>
>> > Any ideas of how others are handling this would be helpful.
>>
>> Hmmm lets see:
>>
>> Update MasterAccounts
>> Set Active = 0
>> Where PayMethod = 'Other'
>> and BilledThru < GetDate()
>>
>>
>> You could just schedule that with SQL Executive/Agent say once a week or
>> once a night.
>
>
>For more information about this list (including removal) go to:
>http://www.iea-software.com/support/maillists/liststart

For more information about this list (including removal) go to:
http://www.iea-software.com/support/maillists/liststart