[Emerald] Emerald SQL and Negative Balances...
Eric ( email@example.com )
Thu, 07 Oct 1999 13:31:48 -0400
I know this was discussed on the list before, but I cannot seem to find the
fix for it...
For some reason after a payment is made to an account, Emerald adds an
extra penny (in some cases more) which in turn makes the balance a
negative. When we first in countered this problem, we figured a simple work
around would be to set every ones balance to $0.00 before billing. This
works, except when a customer pays an account after the balance is set to
$0, then it figures the payment is a pre-payment (which it should) then we
end up with a negative balance. So now I have the problem of some customers
were supposed to be billed $150.00 and were instead credited $150.00
:-( [not very good for business]
If I remember correctly, this is not a short coming or problem with
Emerald, but rather with SQL.
So, now we need to fix SQL so that Emerald does not charge or round up the
If anyone knows how to do this, or can help in some other way, please let
Thanks in advanced,
For more information about this list (including removal) go to: