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?
THANKS,
Jason Powell
For more information about this list (including removal) go to:
http://www.iea-software.com/support/maillists/liststart