Hello - I am using QODBC desktop read write 2007 v 7.10.00.231.  I have set up an ODBC connection and am using a third party tool to extract balances from the Customer:List table and write them to our CRM application (Goldmine). 

For efficiency, I only want to select balances updated since the last time the process ran. I set up a query to pull records where Customer.TimeModified is greater than the last process rundatetime.  However, this doesn't appear to capture records with updated balances.  It looks like changes in balance don't put any timestamp on the customer record.

Is there a table and field I can use to determine when the customer's balance was last updated, or another method I can apply? I see there is a combination table Sales, but cannot tell if this could be used to identify only the changed records.   Thanks for any help you can provide.

The Sales table includes only invoices, credit memos and sales receipts information. Balances can also be changed by payments. So you're going to have to do something like this:

For Invoices, Credit Memos and Sales Receipts Modified from the Start of Today (Current System Date) 

Select Sales.CustomerRefFullName, max(Customer.Balance) as "NewBalance"
from Sales unoptimized, Customer unoptimized
where Sales.CustomerRefListID=Customer.ListID
and Sales.TimeModified >= {fn TIMESTAMPADD(SQL_TSI_YEAR, 0, {fn CURDATE()})}
group by Sales.CustomerRefFullName

And for Payments Modified from the Start of Today (Current System Date) 

Select ReceivePayment.CustomerRefFullName, max(Customer.Balance) as "NewBalance"
from ReceivePayment unoptimized, Customer unoptimized
where ReceivePayment.CustomerRefListID=Customer.ListID
and ReceivePayment.TimeModified >= {fn TIMESTAMPADD(SQL_TSI_YEAR, 0, {fn CURDATE()})}
group by ReceivePayment.CustomerRefFullName