Re: [Emerald] New Adjustment
Dale E. Reed Jr. ( (no email) )
Fri, 31 Mar 2000 12:56:28 -0800
"Robert H. Clugston" wrote:
>
> Dale,
> I removed this section:
> Select LastModifyDate, "Charge", Amount, Description, ChargeID
> From Charges
> Where CustomerID = @CustomerID
> and added your code:
> Select LastModifyDate, CASE When Amount < 0 then "Credit" ELSE "Charge"
> END, ABS(Amount) as Amount, Description, ChargeID
> From Charges
> Where CustomerID = @CustomerID
>
> Now I can't delete credit's or charge's. I'm running 2.5.329
You should still be able to delete the charges, but since it doesn't
know
what a credit is, you won't be able to delete a credit from the history
screen if you make that change.
--
Dale E. Reed Jr. Emerald and RadiusNT__________________________________________IEA Software, Inc. www.iea-software.com
For more information about this list (including removal) go to:http://www.iea-software.com/support/maillists/liststart