I have a VB6 application creating a list for the bank for payroll purposes and it was working just fine until the customer upgraded to QB Pro 2008 and QODBC v8. Both are the latest versions as I updated them myself today (2008 jan 08). The code used is listed below:

txtSql = "sp_report PayrollTransactionsByPayee show  AccountFullName, Date, TxnType, RefNumber, Amount, Account, NameAccountNumber parameters DateFrom = {d'2008-014-08'}, DateTo = {d'2008-01-11'}, IncludeAccounts = 'InUse'  WHERE RowType = 'DataRow' AND TxnType = 'Pay Cheque'"

Adodc1.ConnectionString = "DSN=QuickBooks Data"
Adodc1.RecordSource = txtSql
Adodc1.Refresh

Now with the upgrades, no 'Pay Cheque' data is returned whatsoever, tried to remove/change parameters/WHERE clause without success. Even with no parameters and no where clause at all, the returned data is minimal. By the other hand, QB2008 is showing the PayrollTransactionsByPayee report properly.
Jan 11 is payroll ... so please advise.

Thanks
Alex

Try:

txtSql = "sp_report PayrollTransactionsByPayee show  AccountFullName, Date, TxnType, RefNumber, Amount, Account, NameAccountNumber parameters DateFrom = {d'2008-01-08'}, DateTo = {d'2008-01-11'}, IncludeAccounts = 'InUse'  WHERE RowType = 'DataRow' AND TxnType = 'Paycheck'"

The QuickBooks 2008 Canadian Edition now uses the USA SDK.

I tried that but did not work. I tried this

sp_report PayrollTransactionsByPayee show Date_Title, Name_Title, RefNumber_Title, TxnType_Title, Memo_Title, Account_Title, Amount_Title, Text, TxnType, Date, RefNumber, Name, Memo, Account, Amount
parameters DateFrom = {d'2007-01-01'}, DateTo = {d'2008-01-31'}
WHERE TxnType <>''

I got no rows at all for 'Pay Cheque' or 'Paycheck'
what I got is only 'Liability Adjust' and 'YTD Adjust'
so no cheques at all for the last 13 month (100 employees * 13 month * 2 per month .... 2600 records and I got only 150 !)

Please advise.
Thanks, Alex