Re: [Emerald] Emerald SQL and Negative Balances...

Eric ( )
Mon, 11 Oct 1999 08:39:19 -0400

None of our rates are beyond 2 decimals (eg. PPP = $20.00, etc.) The only
thing that counts a percentage is the annual pay period, which is set to
17% because we couldn't get Emerald to read 16.67% discount. I must have
missed something, what could be causing the balance of ($0.01) to show up
for our customers?
I will check into the newer version of Emerald, but if all that gets me is
the ability for Emerald to calculate past 2 decimals, then maybe that wont
solve the problem.
Thanks for the help.
Eric Jensen
At 03:38 PM 10/8/99 -0700, you wrote:
>Eric wrote:
> >
> > 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
> > cents.
>Its not an SQL or Emerald bug. It has to do with numbers. There are
>two resolutions to this problem:
>1) Change your rates/percentages to not including more than two
>2) Upgrade to a later version of Emerald that supports calculating past
> two decimals (you can get this from support or the beta dirs). Make
> sure you set the "calculate past two decimals" option in the Admin if
> you choose this.
>Dale E. Reed Jr. Emerald and RadiusNT
>IEA Software, Inc.
>For more information about this list (including removal) go to:

For more information about this list (including removal) go to: