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
> 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.
For more information about this list (including removal) go to:
http://www.iea-software.com/support/maillists/liststart