Re: [Emerald] Possible bad invoicing problem?

Dale E. Reed Jr. ( (no email) )
Mon, 21 Feb 2000 17:47:19 +0200

Jason Powell wrote:
>
> I just ran this query to update to Emerald 328 that was listed in
> changes.txt
>
> Update Payments
> Set InvoiceID = (Select Min(InvoiceID)
> From Invoices i
> Where i.CustomerID = Payments.CustomerID
> and Payments.Date <= i.Date)
> Where InvoiceID is NULL
>
> and recieved 1183 changed rows.....IS THIS EXPECTED?

Yes. I would expect most of your records to be updated.

> The query for Payment updates for version 2.5.303 should have
> set to the minimum invoice, not the maximum:
>
> I ran that previous query also. Is there a chance this messed up my whole
> invoice schedule?

Nope. You can run the above query and it will correct everything.

-- 

Dale E. Reed Jr.      Emerald and RadiusNT__________________________________________IEA Software, Inc.    www.iea-software.com



For more information about this list (including removal) go to:http://www.iea-software.com/support/maillists/liststart