[Emerald] Part Payments on Invoices

The Webtel Webmaster ( (no email) )
Mon, 17 Apr 2000 11:15:07 +1000

This is a multi-part message in MIME format.

------=_NextPart_000_0096_01BFA85E.2FD42E10
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

Hi All,

We appear to have strange things happening when we apply partial =
payments to an invoice

Example.

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 =
applied.

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 =
themself.

3. The Software? I realise not likely but will consider anything at =
the moment.

We are running Emerald 2.5.322 on NT workstation machines
Server is MS SQL 7

Any Input, Ideas or suggestions would be terrific!

Thanks
Steve

------=_NextPart_000_0096_01BFA85E.2FD42E10
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">

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