From: "Dale E. Reed Jr." <email@example.com> Subject: RE: [Emerald] Payments Date: Wed, 6 Nov 2002 15:03:07 -0800 Message-ID: <LAELKJHLOBGMNAFCOPIEAEHDCCAA.firstname.lastname@example.org>
> 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.