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...
UPDATE Statements
SET sentdate = statementdate
WHERE (SentDate IS NULL)
Thanks,
Ronnie
> -----Original Message-----
> From: emerald-request@iea-software.com
> [mailto:emerald-request@iea-software.com] On Behalf Of Dale
> E. Reed Jr.
> Sent: Thursday, April 25, 2002 7:15 AM
> To: emerald@iea-software.com
> 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.
>
> Dale
>
>
> ------------
>
> 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
http://www.iea-software.com/support.
For more information about this list (including removal) go to:
http://www.iea-software.com/support/maillists/liststart