Re: [Emerald] Deleting Billing Group

Dale E. Reed Jr. ( (no email) )
Mon, 13 Mar 2000 11:23:47 -0800

Josh Hillman wrote:
> From: Kelly Wright <>
> > 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.

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