From: "Joe Reynolds" <joe@outdoors.net> Subject: RE: [Emerald] Payments Date: Thu, 7 Nov 2002 10:00:23 -0500 Message-ID: <BDEPKHFAFGIMOEFNADFIKEDIDBAA.joe@outdoors.net>
>>>As a side note, you should also update PendingCredits
if you want the Current Balance to reflect the payment.<<<<
What Table/Column would need updating for a Pending Credit?
-----Original Message-----
From: emerald-request@iea-software.com
[mailto:emerald-request@iea-software.com]On Behalf Of Dale E. Reed Jr.
Sent: Wednesday, November 06, 2002 6:03 PM
To: emerald@iea-software.com
Subject: RE: [Emerald] Payments
> 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.
Dale
------------
This is a user supported list. If you require assistance from IEA Software's
Support Engineers, please check out our Support resources at
http://www.iea-software.com/support.
For more information about this list (including removal) go to:
http://www.iea-software.com/support/maillists/liststart