When modifying the Priveledges or select for the particular Billing Group
in the right Operator Group... after selecting delete...and save.... or
remove.... we don't seem to find a way to be able to delete it (it = the
customer and/or billing group)
Steven Deaton
BuzNet Communications
Phone: (972) 644-0440 x1008
Fax: (520) 441-4080
steven@buz.net
----- Original Message -----
From: "Dale E. Reed Jr." <daler@iea-software.com>
To: <emerald@iea-software.com>
Sent: Monday, March 13, 2000 1:23 PM
Subject: Re: [Emerald] Deleting Billing Group
> Josh Hillman wrote:
> >
> > From: Kelly Wright <kelly@buz.net>
> > > How do you remove a billing group from Emerald. The EmerAdmin won't
let
> > me
> > > remove it. All MBRs have been deleted with this Billing group.
> >
> > You may have a couple serviceless MBRs that are still in this group.
> > You can't remove a billing group unless there are no MBRs with that
group
> > set.
> >
> > Run the following script (changing "other" to whatever the groupname is
that
> > you're having a problem with):
> >
> > select customerid
> > from masteraccounts ma, groups g
> > where ma.groupid = g.groupid
> > and g.groupname = 'other'
> >
> > Then go into the accounts and change the billing group to some other
group.
> > Once this is done, you should be able to delete the billing group.
>
> Sometimes we need to get Josh to not use so much SQL. :)
>
> Just go to the MBR tab on the accounts search (not simple or service)
> and select the Group, with no search criteria. It will show you all
> MBRs in that group, to which you can delete/move them.
>
>
> --
>
> 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
For more information about this list (including removal) go to:
http://www.iea-software.com/support/maillists/liststart