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.

For more information about this list (including removal) go to: