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 <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.
For more information about this list (including removal) go to: