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
customers was never billed for quarterly service from 6/1 - 9/1 and I still
can't get the next invoice to be created ("no new invoices to create!").
In the past, I've run into this and it was always something simple like
what you already described (MasterAccounts.ExpireDate < Invoice.EndDate
AND/OR a previous "Renewal" invoice was not paid or voided) and fixing it
was a piece of cake. This one has got me somewhat stumped. I have a text
file that I placed in one of my web-directories displaying the billing
history for this customer:
http://hillman.talstar.com/temp/ait.txt
If you could take a peek at this and possibly shed some light on the
matter, I'd sure appreciate it.
Creating "Renewal" invoices for other customers is not a problem. It
appears to be specific to this one billing record.
NT4 SP3, MSSQL 6.5 SP3, Emerald 2.1.11
Thanks,
Josh Hillman
hillman@talstar.com
> 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!"