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)
Phone: (972) 644-0440 x1008
Fax: (520) 441-4080
----- Original Message -----
From: "Dale E. Reed Jr." <email@example.com>
Sent: Monday, March 13, 2000 1:23 PM
Subject: Re: [Emerald] Deleting Billing Group
> Josh Hillman wrote:
> > From: Kelly Wright <firstname.lastname@example.org>
> > > How do you remove a billing group from Emerald. The EmerAdmin won't
> > 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
> > set.
> > Run the following script (changing "other" to whatever the groupname is
> > 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
> > 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:
For more information about this list (including removal) go to: