Re: [Emerald] needed change in Emerald

Dale E. Reed Jr. ( (no email) )
Thu, 27 Jan 2000 10:56:33 -0800

Josh Hillman wrote:
>
> Emerald 2.5.322 fails to disassociate charges with voided invoices when the
> Charges table doesn't allow nulls in the ItemID column (old databases have
> this set to not allow nulls). If the voiding process set this to zero
> instead of null, it'd fix the problem. Also, the Balance field isn't
> adjusted in these cases even though the invoice is voided.
> SQL 6.5 SP5a

Upgrade to SQL 7.0, and you can change the NULL-ability of the field. :)

The next update will address not changing the balance when that error
comes up, and I think it might also fix the ItemID problem (I'll check
on it).

-- 

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