[Emerald] Possible bad invoicing problem?

Jason Powell ( (no email) )
Sun, 20 Feb 2000 12:07:52 -0800

I just ran this query to update to Emerald 328 that was listed in

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?

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?


Jason Powell

For more information about this list (including removal) go to: