Message-ID: <003401c31675$b6c319d0$0501a8c0@HPNOTE> From: "Tommy Cheng" <tommycheng@pcmagic.net> Subject: Re: [Emerald] How do I delete a ServiceType? Date: Fri, 9 May 2003 14:55:32 -0700
In other words, go to InvoiceItems and RadATConfigs table and change
AccountTypeID value as well.
Tommy
----- Original Message -----
From: "Dale E. Reed Jr." <daler@iea-software.com>
To: <emerald@iea-software.com>
Sent: Friday, May 09, 2003 2:38 PM
Subject: RE: [Emerald] How do I delete a ServiceType?
> > I changed all of the SubAccounts that were using this particular
> > ServiceType
> > to an other ServiceType:
> > [UPDATE SubAccounts SET AccountTypeID=21 WHERE
> > (SubAccounts.AccountTypeID=14)]
> >
> > But I still cannot delete it.
>
> AccountTypeID is used in other places as well. The InvoiceItems
> RadATConfigs, and so forth reference it as well. If you set
> the sortorder to either 255 (pre 4.5.4) or negative (4.5.4 or
> higher), it will no be displayed.
>
> Dale