Re: Expiration date

Dale E. Reed Jr. ( (no email) )
Wed, 10 Jun 1998 09:18:29 -0700

Alan D. Criado wrote:
>
> I hope you can help me with the following questions:
>
> (I'm using Emerald 2.2.31 and RadiusNT 2.5)
>
> 1. Is there a way to change the expiration dates in Emerald for ALL the
> customers at the same time? If so, how?

Open up isql_w, connect to your SQL Server, change the database to Emerald
and Execute this statement:

Update MasterAccounts Set maExpireDate = '7/1/98'

> 2. We've populated our Emerald database with all of our customers; however,
> we won't be using Emerald to charge our customers until the beginning of
> July. How do we keep Emerald from charging them from the date they were
> entered?

Change their ExpireDate as notes above.

> For example: John Doe was entered May 15. '98 and Emerald shows this as his
> start date. Come July 1, '98 I would like to charge John Doe 19.95 for
> the first time for the month of July and I want Emerald to forget that he
> even existed prior to July 1, '98.
>
> 3. Is there a beta version of Emerald that has a working BatchIn process?

For what CC Type?

-- Dale E. Reed Jr.  (daler@iea-software.com)_________________________________________________________________       IEA Software, Inc.      |  RadiusNT, Emerald, and NT FAQs Internet Solutions for Today  |   http://www.iea-software.com