We appear to have strange things happening when we apply partial =
payments to an invoice
We have a customer who has a $500 invoice. The customer pays us $100 so =
we there for pay the invoice and set the amount to $100.
What then happends is the invoice is marked as Paid, and then next =
invoice renewal period, another invoice is generated, however there is =
an additional charge for the full amount of the previous invoice, Not =
the amount from the previous invoice minus the $100 payment which was =
Needless to say, on the credit card accounts our system then goes and =
automatically charges that full amount to the customers card, and they =
then call us up at a later date wanting explanations, and demanding =
refunds on cards etc.
Basically i'm trying to asses where the error is :
1. The User ? (Is that not how you apply a partial payment?)
2. The System/DB ?- Maybe there's a stored procedure or trigger thats =
not being launched correctly. I know we currently are having problems =
with SQLExecutive, it keeps returning an error 109 when we try and start =
it, so nightly stored procedures that we've setup arn't running by =
3. The Software? I realise not likely but will consider anything at =
We are running Emerald 2.5.322 on NT workstation machines
Server is MS SQL 7
Any Input, Ideas or suggestions would be terrific!
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">