[Emerald] Emerald SQL and Negative Balances...

Eric ( ejensen@accnorwalk.com )
Thu, 07 Oct 1999 13:31:48 -0400

Messages sorted by: [ date ][ thread ][ subject ][ author ]
Previous message: B. Smith: "[Emerald] Adding Multiple Line Items on Manual Invoices"
Next message: Drew Philip Halevy: "[Emerald] generating letter for new users"
Next in thread: Dale E. Reed Jr.: "Re: [Emerald] Emerald SQL and Negative Balances..."

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.
If anyone knows how to do this, or can help in some other way, please let
me know!
Thanks in advanced,
Eric Jensen

For more information about this list (including removal) go to:
http://www.iea-software.com/support/maillists/liststart

Previous message: B. Smith: "[Emerald] Adding Multiple Line Items on Manual Invoices"
Next message: Drew Philip Halevy: "[Emerald] generating letter for new users"
Next in thread: Dale E. Reed Jr.: "Re: [Emerald] Emerald SQL and Negative Balances..."