[Emerald] paying invoices with a negative total

Josh Hillman ( (no email) )
Wed, 23 Jun 1999 17:35:55 -0400

Emerald 2.5.278 will not allow you to pay an invoice
(Invoice.Type='Invoice') when Invoice.Amount is a negative value. No errors
of any kind are displayed--the payment window simply doesn't react to
hitting Enter. If you remove the negative symbol from the
amount-to-be-paid, the positive payment will go through. Afterward, you
have to run the following to fix it (in the case where
Invoice.Type='Invoice', this is all that's necessary):
update payments
set amount = 0-amount
where paymentid = 12345

The reason the invoice had a negative total is because it represented a
payment from us to the customer for an accidental credit card charge after
the account was closed.

Emerald 2.5.278
SQL 6.5 SP5a
NT 4 SP5 intel

Josh Hillman
hillman@talstar.com