Re: [Emerald] Closed Accounts
Dale E. Reed Jr. ( (no email) )
Thu, 22 Jul 1999 18:18:50 -0700
Jason Powell wrote:
>
> What is the best way to handle closed accounts? When an account closes, we
> have to make a list and close and delete them at the end of the month...or
> we change their account to other. Other will not create an invoice and will
> not make the user inactive. It would be nice if there was a "closed"
> feature which would automatically not create an invoice and make them
> inactive at the end of the month....then, they could be marked for deletion.
> 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.
--
Dale E. Reed Jr. Emerald and RadiusNT__________________________________________IEA Software, Inc. www.iea-software.com
For more information about this list (including removal) go to:http://www.iea-software.com/support/maillists/liststart