Thanks for looking into this. I didn't realize that an
Invoice.Type=Invoice interferred with the generation of Renewal invoices.
I thought only mismatched Renewal invoices / maExpireDates could cause
problems. Anyway, the problem is fixed and this is what I did to fix it:
There were two invoices (Type=Invoice), one paid, and the other was created
a few days ago. The start/end dates WERE 3/5/98 - 6/5/98 and 6/5/98 -
9/5/98 (while the current maExpireDate = 6/1/98, which coincides with the
regular Renewal invoices). I changed the start/end dates on those two
invoices so that they were the first of the month instead of the 5th, just
to be consistent with the normal billing cycle. Then, I ran the following
for the most recent Invoice (Type=Invoice) to temporarily void it:
UPDATE Invoices SET Type='Void' WHERE InvoiceID = 7543
After that, I was able to create the next normal Renewal invoice (6/1 -
9/1). After creating it, I changed invoice 7543 back to Type=Invoice so
that both can be paid.
Josh Hillman
hillman@talstar.com
----------
> From: Dale E. Reed Jr. <daler@iea-software.com>
> To: emerald@iea-software.com
> Subject: Re: Emerald would not issue a Renewal-Invoice
> Date: Friday, June 05, 1998 1:53 AM
>
> Josh Hillman wrote:
> >
> > As far as invoices go, isn't this only relevant if the invoice is of
type
> > "Renewal" and not "Invoice"? I just found out today that one of our
>
> No. The issue with this account is that the start/end dates are not
> the same. Emerald will ignore invoices that have the same start/end
date,
> but and invoice or renewal that does not have the same start/end date
> is considered overlapping.
>
> MasterAccounts:
> maExpireDate = 6/1/98
> Active = 1
> PayPeriod = Quarterly
> PayMethod = Invoice
> SubAccounts:
> Active = 1
>
> Date InvoiceID StartDate EndDate Amount
> Login Description
> --------- --------- ----------- --------- ---------
--------------------------
> ------------ --------------------------------------------------
> Invoice.Type=Invoice
> 05/29/98 Item 7543
> -360.00 Negotiated by
> 05/29/98 Item 7543
> 30.00 Virtual Domain
> Hosting
> 05/29/98 Item 7543
> 250.00 Website
> Development
> 05/29/98 Item 7543
> 300.00 Banner
> Ad
> 05/29/98 Total Due 7543 06/05/98 09/05/98
> 750.00
>
> This is the one that is causing the problem, since the enddate is higher
> than the expire 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