RE: Emerald would not issue a Renewal-Invoice

Greg Keys ( (no email) )
Wed, 3 Jun 1998 17:10:49 -0400

Dale/All

Dale, you were right per our conversation that the dates were overlapping.
For anyone interested, here is the script I wrote that lists the offending
invoices.
if this turns up your invoices your problem is overlap.

//**************************************************************
select i.invoiceid,
i.customerid,
i.startdate,
i.enddate,
ma.maexpiredate,
i.sentdate,
p.date,
i.amount

from invoices i, masteraccounts ma, invoiceitems ii, payments p

where i.customerid=ma.customerid
and i.enddate>ma.maexpiredate
and (ii.invoiceid=i.invoiceid and ii.paymentid<>null)
and ii.paymentid=p.paymentid

order by i.invoiceid

//**************************************************************
The offending invoices can be changed with an UPDATE Statement that sets
i.startdate=DATEADD(month,-1,ma.maexpiredate) and sets
i.enddate=ma.maexpiredate

This does assume that all the offending invoices are for a one month period
and will require some minor adjustment if this is not the case.

> -----Original Message-----
> From: emerald-request@iea-software.com
> [mailto:emerald-request@iea-software.com]On Behalf Of Dale E. Reed Jr.
> Sent: Wednesday, June 03, 1998 4:27 PM
> To: emerald@iea-software.com
> Subject: Re: Emerald would not issue a Renewal-Invoice
>
>
> Richard Sensale wrote:
> >
> > Mine is doing the same thing now. I tried setting the batch
> for like 4/1/98
> > and still nothing even though we have multiple unpaid invoices.
> Im running
> > 2.11.1
>
> > >emerald just won't issue a renewal for customer that expired
> on May 17, it
> > did not issue in the batch process nor on the manual Renewal
> issuance I've
> > tried 2.2.23 or 2.2.42 and same thing "No new invoices to create!"
>
> The typical reason for this is because you moved the expiration
> date of the MBR back, and not have an overlapping billing cycle.
> You must either void the overlapping invoice, or move the expiration
> date to the enddate of the last invoice for it to bill the customer.
> Use the history tab on the MBR, find the last invoice, and check the
> end date. Then compare that to the expire date. The exipre date
> MUST be latter (or equal to) that end date.
>
> --
> 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
>