Re: Invoicing

Dale E. Reed Jr. ( (no email) )
Tue, 25 Feb 1997 20:32:27 -0800

Wayne Jordan wrote:
>
> Dale you were going to tell me how to mark invoices up to a certain date so
> they would not print or email again since I have already sent them. Then
> since I have the newest rev of Emerald, the next time I send invoices by
> email it should mark them sent. But I need to do that for the ones that got
> sent and not marked.

Update Invoices Sent SentDate = GetDate() Where InvoiceID <= 1111

Replacing 1111 with the last invoice to mark as sent.

-- Dale E. Reed Jr.  (daler@iea.com)_________________________________________________________________       IEA Software, Inc.      |  RadiusNT, Emerald, and NT FAQs Internet Solutions for Today  |    http://www.emerald.iea.com