Re: [Emerald] Invoice Next term

Dale E. Reed Jr. ( (no email) )
Wed, 09 Dec 1998 11:55:43 -0800

Greg Keys wrote:
> Dale, Could you possibly post the SQL query used to determine whether the
> Invoice Next Term makes an invoice vs. saying "No new invoices to generate"
> ?
> That way, Maybe I can figure out WHY!! Emerald 2.5 (and 2.2 and 2.1) will
> not generate invoices for renewal accounts for some of my customers who are
> expired and have NO unpaid or outstanding invoices.
> They seem to get a little testy at getting no invoice and then getting cut
> off for non-payment......... can not imagine why :)

Most of the time why Emerald doesn't bill a person for thier next
term is that the expiredate is BEFORE the enddate of the last invoice.

For Example:

Invoice Start Date: 11/5/98
Invoice End Date: 12/5/98
MBR Expire Date: 12/1/98

You can not set the expire date back, or it will cause the problem.

-- Dale E. Reed Jr.  (       IEA Software, Inc.      |  RadiusNT, Emerald, and NT FAQs Internet Solutions for Today  |