Normal proceedure for the business world is to provide an invoice for
each service or goods purchased, then provide a statement once a month
for those accounts that have a credit line.. My customers do not have a
credit line, they pay for their services in advance.
IF I ever get to the point that I want to send statements, I will have
several thousand that I do NOT want to send.. So can I just populate the
Sentdate with a query like this...
SET sentdate = statementdate
WHERE (SentDate IS NULL)
> -----Original Message-----
> From: firstname.lastname@example.org
> [mailto:email@example.com] On Behalf Of Dale
> E. Reed Jr.
> Sent: Thursday, April 25, 2002 7:15 AM
> To: firstname.lastname@example.org
> Subject: Re: [Emerald] Re-send invoices
> > Due to the "text mode" failure of 4.2.1 I would like to resend all
> > UNPAID invoices that were generated during the last 15
> days. Any one
> > have a script to set those to resend, or tell me where and what the
> > options are to do that are?
> Invoices or statements? You should be sending Statements to
> your customers, not invoices.
> This is a user supported list. If you require assistance from
> IEA Software's Support Engineers, please check out our
> Support resources at http://www.iea-software.com/support.
> For more information about this list (including removal) go
> to: http://www.iea-software.com/support/maillists/liststart
This is a user supported list. If you require assistance from IEA Software's
Support Engineers, please check out our Support resources at
For more information about this list (including removal) go to: