RE: [Emerald] Invoice Next term

Greg Keys ( (no email) )
Wed, 9 Dec 1998 15:55:14 -0500

Ok..... that makes for a good answer...... would you by any chance have a
query up you sleeve that will spot this condition? (I.E. all invoices paid
but the dates are mismatched)

> -----Original Message-----
> From: emerald-request@iea-software.com
> [mailto:emerald-request@iea-software.com]On Behalf Of Dale E. Reed Jr.
> Sent: Wednesday, December 09, 1998 2:56 PM
> To: emerald@iea-software.com
> Subject: Re: [Emerald] Invoice Next term
>
>
> 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. (daler@iea-software.com)
> _________________________________________________________________
> IEA Software, Inc. | RadiusNT, Emerald, and NT FAQs
> Internet Solutions for Today | http://www.iea-software.com
>
> For more information about this list, including removal,
> please see http://www.iea-software.com/maillist.html
>