Re: [Emerald] Deleting Billing Group

Josh Hillman ( (no email) )
Mon, 13 Mar 2000 17:34:01 -0500

From: Dale E. Reed Jr. <>
> 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.

Yeah, yeah, yeah... :)
I actually wrote almost word for word what you said, then wiped it out at
the last second and stuck my SQL stuff in there because I forgot that you
could do the same thing from the MBR tab (instead of Simple). Oops.
I should go back on vacation...


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

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