[Emerald Digest]

emerald-digest-request@iea-software.com
Tue, 26 May 1998 00:00:10 -0700

Message 1: RE: Billing Renewals
from "Mohammed Ersan" <ersan@first.net.jo>

Message 2: Operator access
from "Michael A. Davis Jr." <mike.davis@dcsol.com>

Message 3: Re: Operator access
from "Dale E. Reed Jr." <daler@iea-software.com>

Message 4: Re: Billing Renewals
from "Dale E. Reed Jr." <daler@iea-software.com>

Message 5: Re: Billing Renewals
from "Adam Greene" <adam@webjogger.net>

Message 6: Re: Billing Renewals
from "Randy Nickle" <rnickle@kenora.com>

Message 7: SQL Commands
from "Kelly Wright" <kelly@buz.net>

Message 8: Re: SQL Commands
from "Dale E. Reed Jr." <daler@iea-software.com>

Message 9: Re: Billing Renewals
from "Dale E. Reed Jr." <daler@iea-software.com>

Message 10: Re: SQL Commands
from "Michael A. Davis Jr." <mike.davis@dcsol.com>

Message 11: Re: Operator access
from "Michael A. Davis Jr." <mike.davis@dcsol.com>

Message 12: Re: Operator access
from "Dale E. Reed Jr." <daler@iea-software.com>

Message 13: Re: SQL Commands
from "Dale E. Reed Jr." <daler@iea-software.com>

..------ ------ ------ ------ ------ ------ ------ ------ ------ ------.
| Message 1 |
'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'
Subject: RE: Billing Renewals
From: "Mohammed Ersan" <ersan@first.net.jo>
Date: Mon, 25 May 1998 16:25:32 +0300

sorry but what does this option exactly do........

ersan

At 12:53 PM 05/24/98 -0500, you wrote:

>If you are running 2.2 or later...

>

>Click on File, Preferences, Incremental Batch

>

>On Sunday, May 24, 1998 12:11 PM, Randy Nickle [SMTP:rnickle@kenora.com] wrote:

>> From everything that I have read when creating renewals we should be able

>> to enter a Date in the Future and all accounts that expire in that period

>> of time would create renewal Bills. My problem is I put the expiry date in

>> for 06/06/98 and it creates ALL renewals right to the end of June. As I

>> asked earlier I thought this would only create invoices to June 6.

>>

>> I have had this problem for a couple of months but this time made sure to

>> be extra careful. I must have to change some sort of default but where?

>>

>> _________________________________

>> Randy Nickle

>> Technet of Kenora Inc.

>> http://www.kenora.com

>> Ph 807-468-8199

>> Fx 807-468-7700

>>

>

<flushright>M. Ersan

ersan@first.net.jo

firstnet</flushright>

..------ ------ ------ ------ ------ ------ ------ ------ ------ ------.
| Message 2 |
'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'
Subject: Operator access
From: "Michael A. Davis Jr." <mike.davis@dcsol.com>
Date: Mon, 25 May 1998 12:06:50 -0400

I just set up a new operator in Emerald 2.1.11 and I only gave access to
this operator for 2 billing groups, all other groups have "no access" these
2 groups have "administrator" assigned. When I log into Emerald as the new
operator it tells me that I do not have access to any account types and I
cannot see any MBR's, not even the ones that are in the billing groups that
this operator has "administrator" access to.

If I set the access to "no access" for all billing groups, then it defaults
to the full manager access for all groups and it works, but I don't want
this operator to have access to everything.

Any ideas?

Thanks, Mike Davis
mike.davis@dcsol.com

..------ ------ ------ ------ ------ ------ ------ ------ ------ ------.
| Message 3 |
'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'
Subject: Re: Operator access
From: "Dale E. Reed Jr." <daler@iea-software.com>
Date: Mon, 25 May 1998 09:14:02 -0700

Michael A. Davis Jr. wrote:
>
> I just set up a new operator in Emerald 2.1.11 and I only gave access to
> this operator for 2 billing groups, all other groups have "no access" these
> 2 groups have "administrator" assigned. When I log into Emerald as the new
> operator it tells me that I do not have access to any account types and I
> cannot see any MBR's, not even the ones that are in the billing groups that
> this operator has "administrator" access to.
>
> If I set the access to "no access" for all billing groups, then it defaults
> to the full manager access for all groups and it works, but I don't want
> this operator to have access to everything.

This will not be available until Emerald 2.5. The operator access
in Emerald 2.2 and lower is called "remote" and is a very restrictive
access designed only to allow the operator to manage a single group
of MBRs.

-- 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

..------ ------ ------ ------ ------ ------ ------ ------ ------ ------.| Message 4 |'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'Subject: Re: Billing RenewalsFrom: "Dale E. Reed Jr." <daler@iea-software.com>Date: Mon, 25 May 1998 09:22:24 -0700

Mohammed Ersan wrote:> > sorry but what does this option exactly do........

It does what you are asking. It tell Emerald to batch up to the datethat you enter, rather than the whole month.

>> From everything that I have read when creating renewals we should be able> >> to enter a Date in the Future and all accounts that expire in that period> >> of time would create renewal Bills. My problem is I put the expiry date in> >> for 06/06/98 and it creates ALL renewals right to the end of June. As I> >> asked earlier I thought this would only create invoices to June 6.> >>> >> I have had this problem for a couple of months but this time made sure to> >> be extra careful. I must have to change some sort of default but where?

-- 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

..------ ------ ------ ------ ------ ------ ------ ------ ------ ------.| Message 5 |'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'Subject: Re: Billing RenewalsFrom: "Adam Greene" <adam@webjogger.net>Date: Mon, 25 May 1998 13:36:54 -0400

This is a multi-part message in MIME format.

------=_NextPart_000_0011_01BD87E2.2E6101F0Content-Type: text/plain; charset="iso-8859-1"Content-Transfer-Encoding: quoted-printable

>> From everything that I have read when creating renewals we should be =able>> to enter a Date in the Future and all accounts that expire in that =period>> of time would create renewal Bills. My problem is I put the expiry =datein>> for 06/06/98 and it creates ALL renewals right to the end of June. As =I>> asked earlier I thought this would only create invoices to June 6.>>>> I have had this problem for a couple of months but this time made =sure to>> be extra careful. I must have to change some sort of default but =where?

>If you are running 2.2 or later...>>Click on File, Preferences, Incremental Batch

If you select Incremental Batch mode, all accounts which expire from thefirst of the month up to the date you enter on the batch tab will beinvoiced.

(If today is 5/25 and you enter 5/30/98 in the Date field, all accountsexpiring between 5/1/98 and 5/30/98 which have not been billed will bebilled)

Be careful, because if you enter a date in the following month, onlyaccounts which expire in that month will be billed.

(i.e. if today is 5/25 and you enter 6/10/98, only accounts expiring =from6/1/98-6/10/98 will be billed)

So, if you want to bill over a two-month period, two separate batches =mustbe run.

(i.e. if today is 5/25, first enter 5/31/98 and batch, then enter =6/10/98then batch)

Adam

------=_NextPart_000_0011_01BD87E2.2E6101F0Content-Type: text/html; charset="iso-8859-1"Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD W3 HTML//EN">

>> From everything that I have read when creating renewals we =should=20be able
>> to enter a Date in the Future and all accounts that =expire=20in that period
>> of time would create renewal Bills. My =problem is I=20put the expiry date
in
>> for 06/06/98 and it creates ALL =renewals=20right to the end of June. As I
>> asked earlier I thought this =would=20only create invoices to June 6.
>>
>> I have had this =problem=20for a couple of months but this time made sure to
>> be extra =careful.=20I must have to change some sort of default but where?


>If =you are=20running 2.2 or later...
>
>Click on File, Preferences, =Incremental=20Batch

If you select Incremental Batch mode, all accounts which =expire=20from the
first of the month up to the date you enter on the batch tab =will=20be
invoiced.

(If today is 5/25 and you enter 5/30/98 in the =Date=20field, all accounts
expiring between 5/1/98 and 5/30/98 which have =not been=20billed will be
billed)

Be careful, because if you enter a date =in the=20following month, only
accounts which expire in that month will be=20billed.

(i.e. if today is 5/25 and you enter 6/10/98, only =accounts=20expiring from
6/1/98-6/10/98 will be billed)

So, if you want =to bill=20over a two-month period, two separate batches must
be =run.

(i.e. if=20today is 5/25, first enter 5/31/98 and batch, then enter 6/10/98
then =batch)

Adam
 
------=_NextPart_000_0011_01BD87E2.2E6101F0--..------ ------ ------ ------ ------ ------ ------ ------ ------ ------.| Message 6 |'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'Subject: Re: Billing RenewalsFrom: "Randy Nickle" Date: Mon, 25 May 1998 13:02:36 -0500This is a multi-part message in MIME format.------=_NextPart_000_007B_01BD87DD.63AF58C0Content-Type: text/plain; charset="iso-8859-1"Content-Transfer-Encoding: quoted-printableI can not get the Incremental Batch button to stay saved. I click it on =and then when I go back i it is unchecked again. Similarily when I check =it off and close down Emerald when I log back in it is still UNCHECKED. =Wehave 2.2.23 installed. =20 =20 >If you are running 2.2 or later... > >Click on File, Preferences, Incremental Batch =20 If you select Incremental Batch mode, all accounts which expire from =the first of the month up to the date you enter on the batch tab will be invoiced. =20 (If today is 5/25 and you enter 5/30/98 in the Date field, all =accounts expiring between 5/1/98 and 5/30/98 which have not been billed will =be billed) =20 Be careful, because if you enter a date in the following month, only accounts which expire in that month will be billed. =20 (i.e. if today is 5/25 and you enter 6/10/98, only accounts expiring =from 6/1/98-6/10/98 will be billed) =20 So, if you want to bill over a two-month period, two separate =batches must be run. =20 (i.e. if today is 5/25, first enter 5/31/98 and batch, then enter =6/10/98 then batch) =20 Adam =20 =20------=_NextPart_000_007B_01BD87DD.63AF58C0Content-Type: text/html; charset="iso-8859-1"Content-Transfer-Encoding: quoted-printable
I can not get the Incremental Batch button to stay saved. I =click it on=20 and then when I go back i it is unchecked again. Similarily when I =check it=20 off and close down Emerald when I log back in it is still UNCHECKED. =Wehave=20 2.2.23 installed.
 

>If you are running 2.2 or later...
>
>Click =on=20 File, Preferences, Incremental Batch

If you select =Incremental Batch=20 mode, all accounts which expire from the
first of the month up to =the=20 date you enter on the batch tab will be
invoiced.

(If =today is=20 5/25 and you enter 5/30/98 in the Date field, all =accounts
expiring=20 between 5/1/98 and 5/30/98 which have not been billed will=20 be
billed)

Be careful, because if you enter a date in the=20 following month, only
accounts which expire in that month will be = billed.

(i.e. if today is 5/25 and you enter 6/10/98, only =accounts=20 expiring from
6/1/98-6/10/98 will be billed)

So, if you =want to=20 bill over a two-month period, two separate batches must
be=20 run.

(i.e. if today is 5/25, first enter 5/31/98 and batch, =then=20 enter 6/10/98
then batch)

Adam
 
 
------=_NextPart_000_007B_01BD87DD.63AF58C0--..------ ------ ------ ------ ------ ------ ------ ------ ------ ------.| Message 7 |'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'Subject: SQL CommandsFrom: "Kelly Wright" Date: Mon, 25 May 1998 14:50:50 -0500This is a multi-part message in MIME format.------=_NextPart_000_00C9_01BD87EC.823CDBA0Content-Type: text/plain; charset="iso-8859-1"Content-Transfer-Encoding: quoted-printableMy data base is about 150Megs big now. I was needing the SQL scripts to =delete all call records and null calls and whatever else I can to skinny =down the amout of space that is being used up. =20Kelly Wright (kelly@buz.net)BuzNet Communications=20http://www.buz.net972-644-0440------=_NextPart_000_00C9_01BD87EC.823CDBA0Content-Type: text/html; charset="iso-8859-1"Content-Transfer-Encoding: quoted-printable
My data base is about 150Megs big =now.  I=20was needing the SQL scripts to delete all call records and null calls =and=20whatever else I can to skinny down the amout of space that is being used =up. 
 
 
Kelly Wright (kelly@buz.net)
BuzNet =Communications
http://www.buz.net
972-644-0440
=
------=_NextPart_000_00C9_01BD87EC.823CDBA0--..------ ------ ------ ------ ------ ------ ------ ------ ------ ------.| Message 8 |'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'Subject: Re: SQL CommandsFrom: "Dale E. Reed Jr." Date: Mon, 25 May 1998 13:04:57 -0700> Kelly Wright wrote:> > My data base is about 150Megs big now. I was needing the SQL scripts to> delete all call records and null calls and whatever else I can to skinny down> the amout of space that is being used up.Well, the simplest way is:Delete From CallsWhere CallDate < '2/1/98'replacing the date as needed.You can get a list of Calls records per month doing this:Select DatePart(Year, CallDate), DatePart(Month, CallDate), Count(CallDate)