RE: [Emerald] Payments

New Message Reply Date view Thread view Subject view Author view
Dale E. Reed Jr. (
Wed, 6 Nov 2002 15:03:07 -0800

From: "Dale E. Reed Jr." <>
Subject: RE: [Emerald] Payments
Date: Wed, 6 Nov 2002 15:03:07 -0800
Message-ID: <>

> After a payment of 79.95 was added to payment table by custom program, the
> numbers/dates above remained the same.

And they will. :)
> Am I correct in assuming that a statement will be created at some
> point that
> will zero out the numbers and advance the expire date? Reason I
> ask is that
> a preview batch report for Statements does not create a new statement for
> this user.

Yes. After the next invoice/statement is created for the customer, the dates will advance. However, this is NOT the typical behavior and only done because you are not using Emerald to make the payment. Using Emerald to make the payment would advance the dates and numbers for you. As a side note, you should also update PendingCredits if you want the Current Balance to reflect the payment.

> At this point, even though the member record shows a payment of
> 79.95 AFTER
> the Statement of 79.95, it looks like Emerald will need to create another
> statement to bring the account into balance.

Which is the expected behavior for what you are trying to do. If you used Emerald to make the payment, that would be an issue. Do you have the ability to call a DLL API rather than adding the payment to the DB directly? If you do, then you can use the Payment API and not have to worry about this stuff.


New Message Reply Date view Thread view Subject view Author view
This archive was generated on Wed Nov 06 2002 - 14:43:23 Pacific Standard Time